V$CONTROLFILE lists the names of control files - Oracle Control Files

Q.  In Displaying Control File Information which view lists the names of control files?
- Published on 27 Jul 15

a. V$DATABASE
b. V$PARAMETER
c. V$CONTROLFILE
d. V$CONTROLFILE_RECORD_SECTION

ANSWER: V$CONTROLFILE
 

    Discussion

  • Nirja Shah   -Posted on 28 Aug 15
    - The following views display information about control files:

    1. V$DATABASE - It displays database information from the control file

    2. V$CONTROLFILE - It lists the names of control files

    3. V$CONTROLFILE_RECORD_SECTION - It displays information about control file record sections

    4. V$PARAMETER - It displays the names of control files as specified in the CONTROL_FILES initialization parameter

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