V LOGFILE identifies redo log groups & members & member status - Oracle Redo Log

Q.  Which view identifies redo log groups and members and member status in the Redo Log Information?
- Published on 12 Aug 15

a. V$LOG
b. V$LOGFILE
c. V$LOG_HISTORY
d. None of the above

ANSWER: V$LOGFILE
 

    Discussion

  • Nirja Shah   -Posted on 24 Sep 15
    - The following views provide information on redo logs.

    - V$LOG - It displays the redo log file information from the control file

    - V$LOGFILE - It identifies redo log groups and members and member status

    - V$LOG_HISTORY - It contains log history information

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.)