v$logmnr_contents

This view contains log history information. When a SELECT statement is executed against the v$logmnr_contents view, the archive redo log files are read sequentially. Translated records from the redo log files are returned as rows in the v$logmnr_contents view. This continues until either the filter criteria, such as EndTime or endSCN, specified at startup is met or the end of the archive log file is reached.

v$logmnr_dictionary

This view contains log history information. This view shows the following useful information:

• db_txn_scn – This is the SCN at which the dictionary was created.
   

• dictionary_scn – This is the database checkpoint SCN at which the dictionary was created.

dba_db_links

This view describes the database links. This view does not display the PASSWORD column.

dba_log_groups

This view describes the log group definitions on the tables in the database. The following statement can be used to list the supplemental log groups:

set linesize 140
COLUMN  log_group_name FORMAT A30
COLUMN  owner          FORMAT A24
COLUMN  table_name     FORMAT A30
COLUMN  always HEADING 'Type of Log Group' FORMAT A30