Alert not showing in database control
From: mek s <sidi.bouzid.meknessy_at_gmail.com>
Date: Mon, 29 Aug 2011 10:16:31 +0200
Message-ID: <CAJX5RkR-WknYs=DEkT+013Hvb3dW5S8tfxH0mxgOg2eB-xGi7A_at_mail.gmail.com>
Hi all,
Date: Mon, 29 Aug 2011 10:16:31 +0200
Message-ID: <CAJX5RkR-WknYs=DEkT+013Hvb3dW5S8tfxH0mxgOg2eB-xGi7A_at_mail.gmail.com>
Hi all,
My database version 11gR2.
In databse control (Enterprise Manager not Grid control), I have the
Tablespace Space Used (%) metric set to Critical Threshold 97% and
Warning Threshold
85%
To test, I have created a tablespace and fill it with data until raise
the Tablespace
Space Used (%) alert.
The problem is that alert is not showing in database control.
Any idea?
Thank you,
BEGIN
*
ERROR at line 1:
ORA-01653: unable to extend table DBA_U.TEST_TRAP_SNMP by 8 in tablespace
TSPACE_TEST
ORA-06512: at line 3
SQL>
SQL> SELECT REASON
, METRIC_VALUE
, MESSAGE_TYPE
, TO_CHAR(CREATION_TIME,'DD-MON-YYYY HH24:MI:SS') AS CREATION_TIME,
HOST_ID
FROM SYS.DBA_OUTSTANDING_ALERTS; 2 3 4 5 6
REASON METRIC_VALUE MESSAGE_TYPE CREATION_TIME HOST_ID ---------------------------------------------- ------------ ------------ ---------------------------------------- -------------------- Tablespace [TSPACE_TEST] is [100 percent] full ### Warning 29-AUG-2011 01:09:45 db01SQL>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 29 2011 - 03:16:31 CDT