nerdexam
Oracle

1Z0-054 · Question #197

1Z0-054 Question #197: Real Exam Question with Answer & Explanation

The correct answer is B. database buffer cache is not large enough. See the full explanation below for the reasoning.

Question

View the Exhibit and examine the TKPROF output. While studying the TKPROF output, you find that the number of disk reads is close to the total number of buffers used (query + current) for some statements. What is the reason for this?

Exhibit

1Z0-054 question #197 exhibit

Options

  • Ashared pool is not large enough
  • Bdatabase buffer cache is not large enough
  • Ctoo few DBWn processes
  • Dfragmentation in the database buffer cache

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice