Oracle provides several data dictionary views that can be used to monitor and manage the
online and archived redo logs.
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. |
2 comments:
Thank you
Thank you
Post a Comment