nerdexam
Oracle

1Z0-054 · Question #147

As part of a proactive tuning activity, you have the Automatic Workload Repository (AWR) and ADDM enabled for your database with the default setting of snapshot retention as 8 days and snapshot…

The correct answer is D. short-lived or intermittent performance issues lasting for less than 5 minutes. See the full explanation below for the reasoning.

Question

As part of a proactive tuning activity, you have the Automatic Workload Repository (AWR) and ADDM enabled for your database with the default setting of snapshot retention as 8 days and snapshot interval as 60 minutes. Which performance issue does NOT appear in the ADDM and needs alternative tools for investigation?

Options

  • Asuboptimal parameter settings
  • Bapplication-level block contention
  • Cperformance issues related to the Resource Manager
  • Dshort-lived or intermittent performance issues lasting for less than 5 minutes

How the community answered

(30 responses)
  • A
    7% (2)
  • B
    17% (5)
  • C
    3% (1)
  • D
    73% (22)

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice