[code language=”sql”]

— To get the log switch frequency
select to_char(FIRST_TIME, ‘MON-DD’),
count(*)
from v$log_history
group by to_char(FIRST_TIME, ‘MON-DD’)
order by 1;

[/code]