Redo Logs Information in Data Dictionary

Posted by thakuranupam on November 4, 2009

V$LOG – Contains information about the redo logs from the control file

V$LOGFILES – This view provides the current status of all the redo logs

V$LOG_HISTORY – Contains information concerning archived redo logs from the control file. From here you can find the System Change Number (SCN) view of the archived log files

V$LOGHIST – This view contains information about the redo log file history from the control file

Like this:

Be the first to like this post.

This entry was posted on November 4, 2009 at 6:43 pm and is filed under Redo Log Files. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.