Which two statements are true about the Automatic Workload Repository (AWR)?

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

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

A.
All AWR tables belong to the SYSTEM schema

B.
The AWR contains systemwide tracing and logging information

C.
The snapshots collected by the AWR are accessible through data dictionary views

D.
The snapshots collected by the AWR are used by self-tuning components in the database



Leave a Reply 5

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


vikas vats

vikas vats

a and b are correct

red

red

AWR data are stored in sysaux

awing

awing

AWR is stored in SYSTEM tablespace but are owned by SYS user not SYSTEM.

sky

sky

B,C

(AWR) Automatic workload repository is a collection of persistent system performance statistics owned by SYS.
It resides in SYSAUX tablespace.

awing

awing

Option C is correct:
select snap_id from DBA_HIST_SNAPSHOT