Home » RDBMS Server » Server Administration » metric collection
metric collection [message #264753] Tue, 04 September 2007 08:06 Go to next message
maoro
Messages: 310
Registered: May 2005
Senior Member
hello
i have created a tablespace that does not autoextend and i specified that at 80% i should get a warning
i created a table in this tablespace and inserted records
millions of records
but didnt get the warning yet
i am wondering whats is the schedule of collection for metrics of such warning?
i mean ill get the warning within a window of 30 minutes or 5 minutes;
can i edit such collection?
database 10g on windows 2003
thanks
Re: metric collection [message #264765 is a reply to message #264753] Tue, 04 September 2007 09:00 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
and what percentage full is it now?
Re: metric collection [message #264766 is a reply to message #264753] Tue, 04 September 2007 09:02 Go to previous messageGo to next message
maoro
Messages: 310
Registered: May 2005
Senior Member
100 % full
still didnt get any warning
thanks
Re: metric collection [message #264775 is a reply to message #264766] Tue, 04 September 2007 10:02 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
YOu configure EM notification if yes then you have to also configure following metric.
1. Critical
2. Warning
3. Clear

Open OEM page click on all metric on main page then select tablespace metric and define above three metric and proper configure em notification then you will get email warnings.

Regards
Taj
Re: metric collection [message #264792 is a reply to message #264766] Tue, 04 September 2007 10:42 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
maoro wrote on Tue, 04 September 2007 08:02
100 % full
still didnt get any warning
thanks



double check you settings.(Critical $ Warning)
Re: metric collection [message #264970 is a reply to message #264753] Wed, 05 September 2007 02:47 Go to previous messageGo to next message
maoro
Messages: 310
Registered: May 2005
Senior Member
hello
everything is fine
the warning is displayed,
but i need to know how much time it needs to discover that a tablespace is full ?
how often this check is performed
and if i can change it
thanks gurus
Re: metric collection [message #265949 is a reply to message #264970] Sat, 08 September 2007 01:08 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
but i need to know how much time it needs to discover that a tablespace is full ?
For that you have to set below Severity.
1. Critical
2. Warnings
3. Clear


Regards
Taj
Previous Topic: Unable to login to SQLPLUS to start an Instance
Next Topic: How I run a shell script from the scheduler on 10.2.0.2.0 ?
Goto Forum:
  


Current Time: Wed Dec 07 14:39:32 CST 2016

Total time taken to generate the page: 0.23256 seconds