SQL Script Redo Log History

Updated: 04-Jan-2003
Version: 2.2

Description

Simple listing of redo log switching over time. A useful tip is to change the format model so that you can see the frequency over different periods e.g. hourly, daily, monthly.

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 


set pages 100

spool redohist.lst

column d1 form a20 heading "Date"
column sw_cnt form 99999 heading 'Number|of|Switches'
column Mb form 999,999 heading "Redo Size"
column redoMbytes form 999,999,9999 heading "Redo Log File Size (Mb)"

break on report
compute sum of sw_cnt on report
compute sum of Mb on report

var redoMbytes number;
begin
   select max(bytes)/1024/1024 into :redoMbytes from v$log;
end;
/

print redoMbytes

select trunc(to_date(first_time,'DD-MON-RR HH24:mi:ss') ) d1
       , count(*) sw_cnt
       , count(*) * :redoMbytes Mb
from v$log_history
group by trunc(to_date(first_time,'DD-MON-RR HH24:mi:ss') )
/

spool off

Related Links

Oracle 7: (SQL Script) Redo Log History

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links