Oracle
1Z0-067 · Question #38
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 correct answer is D. The statistics_level parameter is set tobasic. To enable the dbms_server_alert package functionality, set the statistical_level initialization parameter to TYPICAL or ALL.
New Features for Manageability
Question
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?
Options
- AThe event parameter was not set.
- BThe sql_trace parameter is set to false.
- CEnterprise Manager was not used.
- DThe statistics_level parameter is set tobasic.
- EThe t:kid_statistics parameter is set to false.
How the community answered
(61 responses)- A3% (2)
- B2% (1)
- C8% (5)
- D72% (44)
- E15% (9)
Explanation
To enable the dbms_server_alert package functionality, set the statistical_level initialization parameter to TYPICAL or ALL.
Topics
#tablespace thresholds#space usage alerts#STATISTICS_LEVEL#BASIC setting
Community Discussion
No community discussion yet for this question.