V$DATABASE - Definition - Oracle Redo Log

Q.  Which shows if the database is in ARCHIVELOG or NOARCHIVELOG mode and if MANUAL (archiving mode) has been specified in a Dynamic performance view?
- Published on 29 Jul 15

a. V$ARCHIVED_LOG
b. V$DATABASE
c. V$ARCHIVE_DEST
d. V$ARCHIEVE_PROCESSES

ANSWER: V$DATABASE

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 24 Sep 15
    - Several dynamic performance views contain useful information about archived redo logs, as summarized in the following table.

    - V$DATABASE - It shows if the database is in ARCHIVELOG or NOARCHIVELOG mode and if MANUAL (archiving mode) has been specified.

    - V$ARCHIVED_LOG - It displays historical archived log information from the control file. If you use a recovery catalog, the RC_ARCHIVED_LOG view contains similar information.

    - V$ARCHIVE_DEST - It describes the current instance, all archive destinations, and the current value, mode, and status of these destinations.

    - V$ARCHIVE_PROCESSES - Displays information about the state of the various archive processes for an instance.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲