V$CONTROLFILE

The location and status of each controlfile in the database.

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


© Copyright SS64.com 1999-2013
Some rights reserved