Home » RDBMS Server » Enterprise Manager » Tablespace monitor
Tablespace monitor [message #268093] Mon, 17 September 2007 09:01 Go to next message
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


Re: Tablespace monitor [message #268184 is a reply to message #268093] Mon, 17 September 2007 22:09 Go to previous messageGo to next message
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;
/


Re: Tablespace monitor [message #268460 is a reply to message #268184] Tue, 18 September 2007 15:04 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
/forum/fa/3075/0/
  • Attachment: oem.jpg
    (Size: 1.83MB, Downloaded 2703 times)
Re: Tablespace monitor [message #268491 is a reply to message #268093] Tue, 18 September 2007 22:19 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

In addition with Dream, OEM is only available to configure locally managed not dictionary managed tablespace. Laughing
Re: Tablespace monitor [message #270116 is a reply to message #268093] Tue, 25 September 2007 15:18 Go to previous messageGo to next message
yog_23
Messages: 79
Registered: March 2007
Member
thank you...

Whats the difference between managed & dictionary managed ?

thank you
yog
Re: Tablespace monitor [message #270119 is a reply to message #270116] Tue, 25 September 2007 15:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe a little search on the documentation may help.

Regards
Michel
Re: Tablespace monitor [message #270120 is a reply to message #268093] Tue, 25 September 2007 15:25 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Why should OP be bothered actually RTFM when folks will spoon feed him answers?
Re: Tablespace monitor [message #270122 is a reply to message #268093] Tue, 25 September 2007 15:40 Go to previous message
yog_23
Messages: 79
Registered: March 2007
Member
Thanks..

I am confused because there is a metric called "Tablespace [Dictionary Managed]" ?

Previous Topic: Notifications
Next Topic: May I install DB Management additionally?
Goto Forum:
  


Current Time: Thu Mar 28 19:51:04 CDT 2024