Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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