Oracle Control Files Information Report
This script displays information about Oracle database control files. It retrieves control file names and their status from the V$CONTROLFILE dynamic performance view, helping DBAs verify control file configuration and availability.
oraclesqlbackup-restorev1.0.0
0 stars0 downloads13 views0 comments
By OracleDba • Created
Code
(18 lines)123456789101112131415161718
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/controlfiles.sql
-- Author : Tim Hall
-- Description : Displays information about controlfiles.
-- Requirements : Access to the V$ views.
-- Call Syntax : @controlfiles
-- Last Modified: 21/12/2004
-- -----------------------------------------------------------------------------------
SET LINESIZE 100
COLUMN name FORMAT A80
SELECT name,
status
FROM v$controlfile
ORDER BY name;
SET LINESIZE 80