Click here to e-mail your resume and cover letter to 1000's of Top Employers and Recruiters!

Sunday, September 21, 2008

Control File V$ Views

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 - Can be used to display the names of control files as specified in the CONTROL_FILES initialization parameter

SQL> SELECT NAME FROM V$CONTROLFILE;

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

No comments:

Blog Archive