V$CONTROLFILE - Investigate this missing control file - Oracle Datafiles and Tempfiles

Q.  Which view would you query at this stage to investigate this missing control file?
- Published on 19 Oct 15

a. V$INSTANCE
b. V$CONTROLFILE
c. DBA_CONTROL_FILES
d. V$DATABASE_PROPERTIES

ANSWER: V$CONTROLFILE
 

    Discussion

  • Nirja Shah   -Posted on 25 Sep 15
    - V$CONTROLFILE - This view lists the names of the control files.

    - V$INSTANCE - This view displays the state of the current instance.

    - DATABASE_PROPERTIES - DATABASE_PROPERTIES lists Permanent database properties.

    - DBA CONTROL_FILE - Control file is a small binary file that records the physical structure of the database.

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