OraFAQ Forum: Enterprise Manager » Tablespace monitor

Home » RDBMS Server » Enterprise Manager » Tablespace monitor

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Tablespace monitor [message #268093]

Mon, 17 September 2007 09:01

yog_23
Messages: 79
Registered: March 2007

Member

In OEM there are threshold for the tablespace metrics for each tablespace which is nice.

How do we setup to skip monitoirng a tablespace which is of no interest ?

e.g. Skip monitor USERS tablespace, but monitor other tablespaces..

Thank you
Yog

Report message to a moderator

Re: Tablespace monitor [message #268184 is a reply to message #268093]

Mon, 17 September 2007 22:09

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Run it whether you have locally or dictionary managed tablespace.

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          => '0',
   observation_period      => 0,
   consecutive_occurrences => 0,
   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      => 0,
   consecutive_occurrences => 0,
   instance_name           => NULL,
   object_type             => DBMS_SERVER_ALERT.OBJECT_TYPE_TABLESPACE,
   object_name             => 'USERS');
END;
/

Report message to a moderator