DBA_LOGMNR_PURGED_LOG

DBA_LOGMNR_PURGED_LOG displays archived redo log files that have been applied to the logical standby database and can be deleted because they are no longer needed. FIles in this view are refreshed as a result of executing either of the following PL/SQL procedures:

• DBMS_LOGSTDBY.PURGE_SESSION (for Oracle Data Guard SQL Apply)

• DBMS_CAPTURE.SET_FIRST_SCN (for Oracle Streams)