Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Get the log history information for the past 3 days

SQL>  select *  from v$log_history  where first_time > sysdate - 3; no rows selected SQL>