-- 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;