Checking Logswitch Frequency


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

Leave a Reply

Your email address will not be published. Required fields are marked *