Difference between revisions of "Control file information"
From MyWiki
| 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