巡检任务列表:
1.服务器资源使用情况

SELECT * FROM V$SYSSTAT;
SELECT * FROM V$THREADS;
SELECT * FROM V$SESSIONS;
SELECT * FROM V$TASK_QUEUE;

2.内存池

SELECT * FROM V$MEM_POOL;

3.缓存池

SELECT * FROM V$BUFFERPOOL;

4.字典缓存

SELECT * FROM V$DB_CACHE;

5.段中大对象

SELECT * FROM V$SEGMENT_INFOS;
SELECT * FROM SYSOBJECTS;
SELECT * FROM SYSINDEXES;
SELECT * FROM V$TABLESPACE;

6.段中碎片对象

SELECT * FROM V$SEGMENT_INFOS;
SELECT * FROM SYSOBJECTS;
SELECT * FROM SYSINDEXES;
TABLE_USED_SPACE(?,?);
INDEX_USED_SPACE(?,?);

7.表空间

SELECT * FROM V$TABLESPACE;
SELECT * FROM V$DATAFILE;

8.redo日志

SELECT * FROM V$RLOG;
SELECT * FROM V$RLOGFILE;

9.归档

SELECT * FROM V$ARCH_STATUS;
SELECT * FROM V$ARCH_FILE;

10.备份集

SELECT * FROM V$DM_INI;
SF_BAKSET_BACKUP_DIR_ADD('DISK', ?);
SELECT * FROM V$BACKUPSET;
SELECT * FROM V$BACKUPSET_BKP;
SELECT SF_BAKSET_CHECK(?, ?);

11.会话概况

SELECT * FROM SYSOBJECTS;
SELECT * FROM SYSUSERS;
SELECT * FROM V$SESSIONS;
SELECT * FROM V$SESSION_STAT;
SELECT * FROM V$TRXWAIT;
SELECT * FROM V$DSC_TRXWAIT;

12.死锁

SELECT * FROM V$DEADLOCK_HISTORY;
SELECT * FROM V$SESSION_HISTORY;

13.用户

SELECT * FROM SYSOBJECTS;
SELECT * FROM SYSUSERS;
SELECT * FROM V$SESSIONS;
SELECT * FROM SYSPWDCHGS;

14.失效索引

SELECT * FROM SYSOBJECTS;
SELECT * FROM SYSINDEXES;
SELECT * FROM V$TABLESPACE;

15.作业

SELECT * FROM SYSJOB.SYSJOBS;
SELECT * FROM SYSJOBS.SYSJOBHISTORIES2;

16.外部链接

SELECT * FROM SYSOBJECTS;

17.运行日志

SELECT * FROM V$INSTANCE_LOG_HISTORY;

18.dmini配置

SELECT * FROM V$DM_INI;