10g tablespace % full metric

Giganews Newsgroups
Subject: 10g tablespace % full metric
Posted by:  Chuck (skilover_nospam@bluebottle.com)
Date: Wed, 28 Nov 2007

There was a change in 10g in how the tablespace % full alerts trigger
and get cleared. It began being handled by the DB itself instead of the
EM agent. Here's my question. When you set warning and critical
thresholds via grid control for a 10g database, shouldn't that set the
metrics in the DB without having to manually use the DBMS_SERVER_ALERTS
package? In my case it is not. I have tried running a clearstate of the
agent, then added a pair of thresholds for a specific tablespace, but a
query of DBA_THRESHOLDS does not show my changes. It just shows the
defaults.

TIA.

Replies