Prev Question
Next Question

Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

A.
An AWR snapshot shows the SQL statements that are producing the highest load on the system, based on
criteria such as elapsed time and CPU time.

B.
AWR data is stored in memory and in a database.

C.
All AWR tables belong to the SYSTEM schema.

D.
The manageability monitor (MMON) process gathers statistics and creates an AWR snapshot that is used
by the self-tuning components in a database.

E.
An AWR snapshot contains system-wide tracing and logging information.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *