利用Oracle threshold（度量阀值）监控表空间

This group of metrics gives you the availability and status of the managed database. Metrics include:Database Status、Database Process Check、aximum # of sessions since startup and Availability. 在Oracle10G中引入了metric，用来监控数据库表空间，如下实例：1、确认现有的metricSQL> conn / as sysdba已连接。SQL> select count（1） from dba_thresholds;COUNT（1）----------222、创建表空间SQL> select metric_id,metric_name from v$metricname where metric_name like"%space%"2 ;METRIC_ID METRIC_NAME---------- ----------------------------------------------------------------9001 Tablespace Bytes Space Usage9000 Tablespace Space UsageSQL> create tablespace tbs_lw datafile "/opt/oracle/oradata/charge/tbs_lw01.dbf" size 10m;表空间已创建。3、创建新的metricSQL> BEGIN dbms_server_alert.set_threshold （dbms_server_alert.tablespace_pct_full,NULL, NULL, NULL, NULL, 1, 1, NULL, dbms_server_alert.object_type_tablespace, "TBS_LW"）;END;2 /PL/SQL 过程已成功完成。4、查看新创建的metricSQL> select count（1） from dba_thresholds;COUNT（1）----------23SQL> SELECT warning_value, critical_value, status FROM dba_thresholds WHERE metrics_name = "Tablespace Space Usage" AND object_name = "TBS_LW";WARNING_VALUE CRITICAL_VALUE STATUS-------------------- -------------------- -------80 95 VALID5、模拟一个表数据增长达到thresholdSQL> create table t1 tablespace tbs_lw as select * from user_objects;表已创建。SQL> select count（*） from t1;COUNT（*）----------30060SQL> insert into t1 select * from t1 where rownum<4001;已创建4000行。SQL> insert into t1 select * from t1 where rownum<4001;已创建4000行。SQL> commit;提交完成。6、查看是否生效SQL> SELECT reason, message_level,DECODE（message_level, 5, "WARNING", 1, "CRITICAL"） ALERT_LEVEL FROM dba_outstanding_alerts WHERE object_name = "TBS_LW";REASON MESSAGE_LEVEL ALERT_LE-------------------------------------------------- ------------- --------表空间 [TBS_LW] 已占用 [90 Percent] 5 WARNING7、停用metricSQL> BEGIN dbms_server_alert.set_threshold （dbms_server_alert.tablespace_pct_full,dbms_server_alert.operator_do_not_check, "0",dbms_server_alert.operator_do_not_check, "0", 1, 1, NULL,dbms_server_alert.object_type_tablespace, "TBS_LW"）;END;2 /PL/SQL 过程已成功完成。SQL> SELECT warning_value, critical_value, status FROM dba_thresholds WHERE metrics_name = "Tablespace Space Usage" AND object_name = "TBS_LW";WARNING_VALUE CRITICAL_VALUE STATUS-------------------- -------------------- -------0 0 VALID8、取消metricBEGIN dbms_server_alert.set_threshold （dbms_server_alert.tablespace_pct_full,NULL, NULL, NULL, NULL, 1, 1, NULL, dbms_server_alert.object_type_tablespace, "TBS_LW"）;END;2 /PL/SQL 过程已成功完成。SQL> SELECT warning_value, critical_value, status FROM dba_thresholds WHERE metrics_name = "Tablespace Space Usage" AND object_name = "TBS_LW";未选定行Oracle 监听内存泄露问题Oracle asm 添加磁盘组相关资讯 oracle

[INS-32052] Oracle基目录和Oracle （07/22/2014 07:41:41）
Oracle 4个大对象（lobs）数据类型（02/03/2013 12:33:05）
Oracle按时间段分组统计（07/26/2012 10:36:48）

[Oracle] dbms_metadata.get_ddl的（07/12/2013 07:37:30）
Liferay Portal 配置使用Oracle和（07/31/2012 20:07:18）
Concurrent Request:Inactive （07/20/2012 07:44:05）

本文评论查看全部评论（0）