SQL ScriptRedo Log History |
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
None.
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');
column d1 form a12 heading "Date" select to_char(to_date(time,'MM/DD/RR HH24:mi:ss'),'DD-MON-YYYY') d1, count(*) from v$log_history group by to_char(to_date(time,'MM/DD/RR HH24:mi:ss'),'DD-MON-YYYY');
Return to Index of SQL Scripts
Home
|
Company Profile
|
Services
|
Contact Us
|
SQL scripts and tips
|
Quiz
|