V$CONTROLFILE
Data Dictionary ViewColumns ___________________________ 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: