数据库健康检查

-- Description  : queries to check the general health of the system.
-- Call Syntax  : @gen_health

SET PAGESIZE 0
SET FEEDBACK OFF
SET VERIFY OFF

SPOOL f:temp.sql

SELECT file_id,
       tablespace_name,
       file_name,
       status
FROM   sys.dba_data_files;

SELECT file#,
       name,
       status,
       enabled
FROM   v$datafile;

SELECT *
FROM   v$backup;

SELECT *
FROM   v$recovery_status;

SELECT *
FROM   v$recover_file;

SELECT *
FROM   v$recovery_file_status;

SELECT *
FROM   v$recovery_log;

SELECT username,
       command,
       status,
       module
FROM   v$session;

SPOOL OFF

SET PAGESIZE 14
SET FEEDBACK ON