Pavan DBA's Blog

The DBA Knowledge Store

Posts Tagged ‘script to find redo generated’

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

/

Posted in Performance Tuning, Scripts | Tagged: , , | 12 Comments »

 
%d bloggers like this: