You specified the warning and critical thresholds for a locally managed tablespace to be
60% and 70%, respectively.
From the tablespace space usage metrics, you find that the space usage has reached the
specified warning threshold value, but no alerts have been generated.
What could be the reason for this?
A.
The event parameter was not set.
B.
The sql_trace parameter is set to false.
C.
Enterprise Manager was not used.
D.
The statistics_level parameter is set to basic.
E.
The t:kid_statistics parameter is set to false.
ummmm
D… not sure
D Only.
“Database metrics are not computed by Oracle when the initialization parameter called statistics_level is set to BASIC. “
D
I hate this reference, but it’s all I could find:
http://www.dba-oracle.com/t_dbms_server_alert.htm
D
D:
http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams211.htm#REFRN10214
“(…)
Setting the STATISTICS_LEVEL parameter to BASIC disables the collection of many of the important statistics required by Oracle Database features and functionality, including:
(…)
– All server-generated alerts
(…)
These server-generated alerts are used by OEM for the evaluation of metrics
D.
To enable the dbms_server_alert package functionality, set the statistical_level initialization parameter to TYPICAL or ALL.
http://www.dba-oracle.com/t_dbms_server_alert.htm
D