Manitoring Redo


SELECT Start_Date,
 Start_Time,
 Num_Logs,
 ROUND (Num_Logs * (Vl.Bytes / (1024 * 1024)), 2) AS Mbytes,
 Vdb.NAME AS Dbname
 FROM ( SELECT TO_CHAR (Vlh.First_Time, 'YYYY-MM-DD') AS Start_Date,
 TO_CHAR (Vlh.First_Time, 'HH24') || ':00' AS Start_Time,
 COUNT (Vlh.Thread#) Num_Logs
 FROM V$log_History Vlh
 GROUP BY TO_CHAR (Vlh.First_Time, 'YYYY-MM-DD'),
 TO_CHAR (Vlh.First_Time, 'HH24') || ':00') Log_Hist,
 V$log Vl,
 V$database Vdb
 WHERE Vl.Group# = 1
ORDER BY Log_Hist.Start_Date, Log_Hist.Start_Time;

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: