System Tables Data Dictionary Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. System Tables Data Dictionary
  4. 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>