Oracle
1Z0-043 · Question #12
You observe that a database performance has degraded over a period of time. While investigating the reason, you find that the size of the database buffer cache is not large enough to cache all the…
The correct answer is A. Memory Advisor. See the full explanation below for the reasoning.
Question
You observe that a database performance has degraded over a period of time. While investigating the reason, you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to, in order to determine that required size of the database buffer cache?
Options
- AMemory Advisor
- BSegment Advisor
- CSQL Tuning Advisor
- DSQL Access Advisor
- EAutomatic Database Diagnostic Monitor (ADDM)
How the community answered
(30 responses)- A77% (23)
- B13% (4)
- C3% (1)
- D7% (2)
Community Discussion
No community discussion yet for this question.