Control Files Data Dictionary Views

The following views display information about control files:

View	Description
`V$DATABASE`	Displays database information from the control file
`V$CONTROLFILE`	Lists the names of control files
`V$CONTROLFILE_RECORD_SECTION`	Displays information about control file record sections
`V$PARAMETER`	Displays the names of control files as specified in the `CONTROL_FILES` initialization parameter

This example lists the names of the control files.

SQL> SELECT NAME FROM V$CONTROLFILE;

NAME
-------------------------------------
/u01/oracle/prod/control01.ctl
/u02/oracle/prod/control02.ctl 
/u03/oracle/prod/control03.ctl