nerdexam
Oracle

1Z0-060 · Question #35

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?

The correct answer is A. Compare Period ADDM report. You may have noticed a performance change on a production system and would like to know why, or you may have implemented a change to a production system and want to know the effect of the change, such as increased concurrency waits. The Compare Period ADDM compares the…

New Features for Performance

Question

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?

Options

  • ACompare Period ADDM report
  • BAWR Compare Period report
  • CActive Session History (ASH) report
  • DTaking a new snapshot and comparing it with a preserved snapshot

How the community answered

(34 responses)
  • A
    82% (28)
  • B
    9% (3)
  • C
    3% (1)
  • D
    6% (2)

Explanation

You may have noticed a performance change on a production system and would like to know why, or you may have implemented a change to a production system and want to know the effect of the change, such as increased concurrency waits. The Compare Period ADDM compares the performance of the database server in two time periods, and returns a report describing the performance changes and the root origin of the

Topics

#Compare Period ADDM#performance comparison#AWR snapshots#performance change analysis

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice