oracle报警的阀值,如何设置lmt的空间警告阀值-Oracle

如何设置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;

/