Pavan DBA's Blog

The DBA Knowledge Store

script to find redo generated by current sessions

Posted by Pavan DBA on March 30, 2012


#################################################

redo generated by current sessions

#################################################

 

select v$session.sid, username, value redo_size

from v$sesstat, v$statname, v$session

where v$sesstat.STATISTIC# = v$statname.STATISTIC#

and v$session.sid = v$sesstat.sid

and name = ‘redo size’

and value > 0

and username is not null

order by value

/

Advertisements

12 Responses to “script to find redo generated by current sessions”

  1. I really enjoy examining on this web site, it contains great articles. “Beware lest in your anxiety to avoid war you obtain a master.” by Demosthenes.

  2. murthi said

    Hi Sir,
    please tell me steps for
    how to migrate database mysql to oracle?

  3. Ram said

    Hi Pavan,

    The client requirement is as follows:
    On the same server , they want production db and dev db should be running.But they dont want the db who manges development db to do startup and shutdown on the production db. They should be able to do so on the dev db only

    How to manage it ?

    • Pavan DBA said

      Hi Ram,

      You have not specified the OS and Oracle versions. so I am assuming it to be Linux flavour and Oracle 10g.
      At OS level, you can create two users (for example oraprod and oradev). do installations separately with those users, then don’t share password of oraprod user to anyone except whom you wish to manage prod database.

  4. dinesh dubey said

    This is great and what is redo log buffer wait and how to trace to the source from where they are coming and how to resolve them.

    • Pavan DBA said

      redolog buffer wait means some transaction is waiting to get free buffer in log buffer cache. generally this happens when more transactions are hitting the database which are generating huge redo and log buffer cache size is small. We can identify this as a wait event in “top 5 timed events” in AWR report. Most of the times, the resolution would be increasing the size of log buffer cache

  5. abinas said

    Pavan please help me in this.

    i want to change my character set of db from al32utf8 to wei8…

    how can i do and option expect creating the db.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: