DanBrother的部落格

In Oracle 11gR2,
Alert Thresholds can be set through OEM or DBMS_SERVER_ALERT package.

OEM GUI:
   Metric and Policy Settings -> Metric Thresholds -> Tablespace Space Used(%) All others

Revert to tablespace default threshold setting:
>>
exec dbms_server_alert.set_threshold(-
METRICS_ID=>DBMS_SERVER_ALERT.TABLESPACE_PCT_FULL, -
WARNING_OPERATOR=>null,-
WARNING_VALUE=>null, -
CRITICAL_OPERATOR=>null,-
CRITICAL_VALUE=> null,-
OBSERVATION_PERIOD=>null,-
CONSECUTIVE_OCCURRENCES=>null,-
INSTANCE_NAME=>null,-
OBJECT_TYPE=>DBMS_SERVER_ALERT.OBJECT_TYPE_TABLESPACE,-
OBJECT_NAME=>null);