Common Dynamic Performance views accessible in NOMOUNT stage -V$PARAMETER, V$OPTION, V$SGA

Q.  Identify the common Dynamic Performance views which are accessible in NOMOUNT stage?
- Published on 29 Jul 15

a. V$PARAMETER, V$OPTION, V$SGA
b. V$THREAT, V$LOGFILE, V$DATAFILE
c. Both A & B
d. V$CONTROLFILE, V$DATABASE

ANSWER: V$PARAMETER, V$OPTION, V$SGA
 

    Discussion

  • Nirja Shah   -Posted on 31 Aug 15
    - The Startup (nomount) Stage
    - When you issue the startup command, the first thing the database will do is enter the nomount stage.
    - During the nomount stage, Oracle first opens and reads the initialization parameter file (init.ora) to see how the database is configured.
    - After the parameter file is accessed, the memory areas associated with the database instance are allocated.
    - Also, during the nomount stage, the Oracle background processes are started.
    - Together, we call these processes and the associated allocated memory the Oracle instance. - Once the instance has started successfully, the database is considered to be in the nomount stage.
    - If you issue the startup command, then Oracle will automatically move onto the next stage of the startup, the mount stage.

    - The Oracle Server contains a set of underlying views that are maintained by the server and accessible to the database administrator user SYS.

    - These views are called dynamic performance views because they are continuously updated while a database is open and in use, and their contents relate primarily to performance.

    - The file CATALOG.SQL contains definitions of the views and public synonyms for the dynamic performance views.

    - You must run CATALOG.SQL to create these views and synonyms.
    - V$PARAMETER , V$OPTION , V$SGA
    - V$PARAMETER - This view lists information about initialization parameters.
    - V$OPTION - This view lists options that are installed with the Oracle Server.
    - V$SGA - This view contains summary information on the System Global Area.

    - V$THREAT, V$LOGFILE, V$DATAFILE
    - V$LOGFILE - This view contains information about redo log files.
    - V$DATAFILE - This view contains datafile information from the control file.

    - V$CONTROLFILE, V$DATABASE
    - V$CONTROLFILE - This view lists the names of the control files.
    - V$DATABASE - This view contains database information from the control file.

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