nerdexam
Oracle

1Z0-034 · Question #91

The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the Automatic Database…

The correct answer is C. Active Session History report. See the full explanation below for the reasoning.

Question

The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the Automatic Database Diagnostic Management (ADDM) analysis for the time period between 10:00 PM and 11:00 PM does not show this performance problem. What would you suggest to analyze this performance problem for the user?

Options

  • ASQL Tuning Advisor
  • BSQL Performance Analyzer
  • CActive Session History report
  • DAWR Compare Periods report

How the community answered

(36 responses)
  • A
    8% (3)
  • B
    3% (1)
  • C
    83% (30)
  • D
    6% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-034 Practice