-- 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
阅读(728) | 评论(0) | 转发(0) |