nerdexam
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)
  • A
    77% (23)
  • B
    13% (4)
  • C
    3% (1)
  • D
    7% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice