Which three statements are true about Automatic Workloa…

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

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.



Leave a Reply 0

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