?? gen_health.sql
字號:
--* File Name : Gen_Health.sql
--* Author : DR Timothy S Hall
--* Description : Miscellaneous queries to check the general health of the system.
--* Call Syntax : @Gen_Health
--* Last Modified: 15/07/2000
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;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -