SQL Script Redo Log History

Updated : 04-Apr-2002
Version : 2.0

Description

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

Corrected for verion 8i

Parameters

None.

SQL Source

 
spool redohist.lst

column d1 form a12 heading "Date"
column sw_cnt form 99999 heading 'Number|of|Switches'

select to_char(to_date(first_time,'DD-MON-RR HH24:mi:ss'),'DD-MON-YYYY') d1,
          count(*) sw_cnt
from v$log_history
group by to_char(to_date(first_time,'DD-MON-RR HH24:mi:ss'),'DD-MON-YYYY');

spool off

Previous Oracle Version Links

Redo Log History

Return to Index of SQL Scripts

Home | Company Profile | Services | Contact Us | SQL scripts and tips | Quiz Legal