Monday, November 4, 2013

Using ARCHIVELOG Mode Data Dictionary Views

Oracle provides several data dictionary views that can be used to monitor and manage the
online and archived redo logs.

V$ARCHIVE The V$ARCHIVE view provides information on redo logs that are in need of being archived.
V$ARCHIVE_DEST The V$ARCHIVE_DEST view provides information on each individual archive-log destination.
Typically this view is used for Oracle Data Guard.
V$ARCHIVE_DEST_STATE  The V$ARCHIVE_DEST_STATE view provides status information on each of the
 individual archive-log destination directories
V$ARCHIVE_PROCESSES The V$ARCHIVE_PROCESSES view provides information on the different ARCH
processes running on your system.
V$ARCHIVED_LOG The V$ARCHIVED_LOG view provides information on individual archived redo logs.
V$LOG The V$LOG view provides information on the online redo log groups.
V$LOGFILE The V$LOGFILE view provides information on specific online redo logs
V$LOG_HISTORY The V$LOG_HISTORY view provides historical information on all online/archived redo logs.