Oracle PL/SQL/System Tables Views/V log history
Get the log history information for the past 3 days
<source lang="sql">
SQL> select * from v$log_history where first_time > sysdate - 3; no rows selected SQL> SQL> SQL>
</source>
<source lang="sql">
SQL> select * from v$log_history where first_time > sysdate - 3; no rows selected SQL> SQL> SQL>
</source>