nerdexam
Oracle

1Z0-417 · Question #34

Which are two kinds of statistics collected and processed by the Automatic Workload Repository (AWR) you would utilize when tuning an Oracle Database instance?

The correct answer is A. Wait Event statistics D. Standby Database throughput statistics. https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027

Automatic Performance Tuning Features

Question

Which are two kinds of statistics collected and processed by the Automatic Workload Repository (AWR) you would utilize when tuning an Oracle Database instance?

Options

  • AWait Event statistics
  • BSession and System statistics
  • CUser privileges statistics
  • DStandby Database throughput statistics
  • EInterconnect statistics

How the community answered

(13 responses)
  • A
    85% (11)
  • B
    8% (1)
  • C
    8% (1)

Explanation

https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF027

Topics

#AWR#wait events#session statistics#performance monitoring

Community Discussion

No community discussion yet for this question.

Full 1Z0-417 Practice