Sunday, August 12, 2012

How to obtain Control File Information

Information about control file status and locations can be retrieved by querying the data dictionary.

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_FILES: List the name, status, and location of the control files.

No comments:

Post a Comment