Oracle
1Z0-043 · Question #143
Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace…
The correct answer is E. Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace. See the full explanation below for the reasoning.
Question
Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently, the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool, you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do?
Options
- ADisable SQL tracing for the APPS tablespace.
- BDisable logging attributes for the APPS tablespace.
- CModify the tablespace to be a dictionary-managed tablespace.
- DIncrease the critical threshold value for the tablespace space usage metrics for the APPS tablespace.
- EIncrease the warning threshold value for the tablespace space usage metric for the APPS tablespace.
How the community answered
(34 responses)- A15% (5)
- C3% (1)
- D9% (3)
- E74% (25)
Community Discussion
No community discussion yet for this question.