Oracle
1Z0-083 · Question #20
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)
The correct answer is A. By default, AWR snapshots are taken every 60 minutes. B. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter. D. The taking of AWR snapshots can be disabled. https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214
Monitoring and Tuning
Question
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)
Options
- ABy default, AWR snapshots are taken every 60 minutes.
- BIts collection level is determined by the value of the STATISTICS_LEVEL database parameter.
- CBy default, AWR snapshots are retained for 7 days.
- DThe taking of AWR snapshots can be disabled.
- EAWR data is stored in the SYSTEM tablespace.
How the community answered
(16 responses)- A81% (13)
- C6% (1)
- E13% (2)
Explanation
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214
Topics
#AWR#snapshots#STATISTICS_LEVEL#retention period
Community Discussion
No community discussion yet for this question.