Get the log history information for the past 3 days : v_log_history « System Tables Data Dictionary « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Tables Data Dictionary
  3. v_log_history
SQL> select * from v$log_history where first_time > sysdate - 3;

no rows selected

SQL>
SQL>
SQL>








30.117.v_log_history
30.117.1.Get the log history information for the past 3 days