nerdexam
Oracle

1Z0-054 · Question #141

Your organization has purchased licenses for the Diagnostic Pack along with the Oracle Database 11g software.The application workload on your database is known to be stable between 10:00 PM and…

The correct answer is C. AWR Compare Report. See the full explanation below for the reasoning.

Question

Your organization has purchased licenses for the Diagnostic Pack along with the Oracle Database 11g software.The application workload on your database is known to be stable between 10:00 PM and midnight every night, but the performance on a particular Thursday was poor between 10:00 PM and 11:00 PM. Which tool would you consider using first to diagnose the cause of the performance degradation?

Options

  • ADatabase Replay
  • BSTATSPACK Report
  • CAWR Compare Report
  • DSQL Performance Analyzer

How the community answered

(43 responses)
  • A
    5% (2)
  • B
    7% (3)
  • C
    86% (37)
  • D
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice