Pavan DBA's Blog

The DBA Knowledge Store

Posts Tagged ‘script to find redo generated by current sessions’

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: