Difference between revisions of "Control file information"

From MyWiki
Jump to: navigation, search
Line 2: Line 2:
 
V$PARAMETER -  Lists status and location of all parameters.<BR>
 
V$PARAMETER -  Lists status and location of all parameters.<BR>
 
V$CONTROLFILE_RECORD_SECTION -  Provides  information about the control file record sections.<BR>
 
V$CONTROLFILE_RECORD_SECTION -  Provides  information about the control file record sections.<BR>
 +
 +
show parameters control_file<br>

Revision as of 13:09, 19 June 2015

V$CONTROLFILE - Lists the name and status of all control files associated with the instance.
V$PARAMETER - Lists status and location of all parameters.
V$CONTROLFILE_RECORD_SECTION - Provides information about the control file record sections.

show parameters control_file