监听器是否正常 | 能够使用sqlplus远程登录,如不能登录则告警,填写告警信息; |
当前会话数量 | SELECT count(*) FROM v$session; 超过50个表示太多,告警; |
查看MT分区情况 | SELECT min(PARTITION_NAME),max(PARTITION_NAME) FROM dba_tab_partitions WHERE TABLE_NAME = UPPER('MCPP_CDR_MT_T') ORDER BY partition_name DESC; 如果最大分区时间没有提前10天,则告警;如果最小分区时间小于100天以上,则告警; |
查看MO分区情况 | SELECT min(PARTITION_NAME),max(PARTITION_NAME) FROM dba_tab_partitions WHERE TABLE_NAME = UPPER('MCPP_CDR_MO_T') ORDER BY partition_name DESC; 如果最大分区时间没有提前10天,则告警;如果最小分区时间小于100天以上,则告警; |
查看表空间情况 | set linesize 200; set pagesize 50000; SELECT c.tablespace_name "tablespace", ROUND(a.bytes/1048576,2) "total(MB)", ROUND(b.bytes/1048576,0) "free(MB)", ROUND((a.bytes-b.bytes)/1048576,0) "used(MB)", ROUND(b.bytes/a.bytes * 100,0) "free(%)", ROUND((a.bytes-b.bytes)/a.bytes,2) * 100 "used(%)" FROM (SELECT tablespace_name, SUM(a.bytes) bytes, MIN(a.bytes) minbytes, MAX(a.bytes) maxbytes FROM sys.DBA_DATA_FILES a GROUP BY tablespace_name) a, (SELECT a.tablespace_name, NVL(SUM(b.bytes),0) bytes FROM sys.DBA_DATA_FILES a, sys.DBA_FREE_SPACE b WHERE a.tablespace_name = b.tablespace_name (+) AND a.file_id = b.file_id (+) GROUP BY a.tablespace_name) b, sys.DBA_TABLESPACES c WHERE a.tablespace_name = b.tablespace_name(+) AND a.tablespace_name = c.tablespace_name ORDER BY 6; 查看表空间使用情况,如果有表空间空闲低于20%,则告警 |
数据库巡检
最新推荐文章于 2024-07-15 10:06:00 发布