Oracle PL/SQL/System Tables Views/V log history
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>
SQL> select * from v$log_history where first_time > sysdate - 3;
no rows selected
SQL>
SQL>
SQL>