当前位置:操作系统 > Unix/Linux >>

如何设置lmt的空间警告阀值

如何设置lmt的空间警告阀值
 
The following example sets the free-space-remaining thresholds in the USERS tablespace to 10 MB (warning) and 2 MB (critical), and disables the percent-full thresholds.
设置user tbs 在free 空间为10M时为-warning ,2M时为-critical,同时禁用
 percent-full thresholds.
 
--------------------------------------------------------------------------------
DB VERSION: oracle 11g
--------------------------------------------------------------------------------
 
BEGIN
DBMS_SERVER_ALERT.SET_THRESHOLD(
   metrics_id              => DBMS_SERVER_ALERT.TABLESPACE_BYT_FREE,
   warning_operator        => DBMS_SERVER_ALERT.OPERATOR_LE,
   warning_value           => '10240',
   critical_operator       => DBMS_SERVER_ALERT.OPERATOR_LE,
   critical_value          => '2048',
   observation_period      => 1,
   consecutive_occurrences => 1,
   instance_name           => NULL,
   object_type             =>DBMS_SERVER_ALERT.OBJECT_TYPE_TABLESPACE,
   object_name             => 'USERS');
DBMS_SERVER_ALERT.SET_THRESHOLD(
   metrics_id                 => DBMS_SERVER_ALERT.TABLESPACE_PCT_FULL,
   warning_operator          => DBMS_SERVER_ALERT.OPERATOR_GT,
   warning_value           => '0',
   critical_operator         => DBMS_SERVER_ALERT.OPERATOR_GT,
   critical_value             => '0',
   observation_period      => 1,
   consecutive_occurrences => 1,
   instance_name           => NULL,
   object_type             => DBMS_SERVER_ALERT.OBJECT_TYPE_TABLESPACE,
   object_name             => 'USERS');
END;
/
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,