Home Oracle Commands v$ Performance views
 Oracle Data Dictionary

V$CONTROLFILE

Data Dictionary View

Columns
   ___________________________
 
   STATUS
   NAME

Example:

SQL> SET LINESIZE 135
SQL> SET PAGESIZE 9999
SQL> COLUMN name FORMAT A45
SQL>
SQL> SELECT
   2 name,
   3 LPAD(status, 7) status
   4 FROM v$controlfile
   5 ORDER BY name
   6 /

NAME                                          STATUS
--------------------------------------------- -------
M:\ORADATA\LIVE\CONTROL03.CTL
T:\ORADATA\LIVE\CONTROL01.CTL
T:\ORADATA\LIVE\CONTROL02.CTL

SQL>

Related:

V$CONTROLFILE_RECORD_SECTION



Simon Sheppard
SS64.com