V$CONTROLFILE - Lists the names of control filesV$CONTROLFILE_RECORD_SECTION - Displays information about control file record sectionsV$PARAMETER - Can be used to display the names of control files as specified in the CONTROL_FILES initialization parameterSQL> SELECT NAME FROM V$CONTROLFILE;
NAME
-------------------------------------
/u01/oracle/prod/control01.ctl
/u02/oracle/prod/control02.ctl
/u03/oracle/prod/control03.ctl
No comments:
Post a Comment