Target type=Database Instance
Occurred At=Nov 9, 2012 11:22:53 AM EST
Message=Tablespace tabs_20 is 97 percent full
Metric=Tablespace Space Used (%)
Notification Rule Name=Database Availability and Critical States
Notification Rule Owner=SYSMAN
Is this only happening with this particular metric or is it happening for other metrics on this targets? This is a server-generated metric so I am wondering if this time stamp is actually coming from the database itself.
Also - what is the timezone of this target set to? You can query MGMT$TARGETS view with target name='DB1' and target type = 'oracle_database'.
1> The time zone of the database target, the time zone of the OMS
2> run the following sql on SQL plus directly against the database instance that is raising the alert:
-- See Outstanding Server Generated Alerts
-- 9 == Space Used %, 133 == Free Space (MB)
SELECT reason_id, object_name, metric_value, TIME_SUGGESTED, CREATION_TIME
WHERE (reason_id=133 or reason_id=9)
AND object_name like '%'
ORDER BY object_name;
-- See the alert history for TABLESPACE objects
SELECT object_name, reason_id, reason, metric_value
FROM dba_alert_history, TIME_SUGGESTED, CREATION_TIME