Question: Which statements about the Automatic Workload Repository (AWR) are true? (Choose all that apply.) 1. By default, snapshots are taken and stored in the AWR

Which statements about the Automatic Workload Repository (AWR) are true? (Choose all that apply.)

1. By default, snapshots are taken and stored in the AWR every 60 minutes.

2. The SMON background process writes snapshots to the AWR at regular intervals.

3. You can only access snapshots collected in the AWR using the DBMS_WORKLOAD_REPOSITORY package.

4. Tables in the AWR are stored in the SYSAUX tablespace and are owned by SYSMAN.

5. The default AWR retention period is 10 days.

6. The AWR contains snapshots of database metrics that are used for self-tuning.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!