Oracle
1Z0-062 · Question #268
What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?
The correct answer is C. Automatic Workload Repository(AWR) snapshots are not generated automatically.. https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN1021
Managing Performance
Question
What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?
Options
- AOptimizer statistics are collected automatically.
- BOnly timed operating system (OS) statistics and plan execution statistics are collected.
- CAutomatic Workload Repository(AWR) snapshots are not generated automatically.
- DThe Oracle server dynamically generates the necessary object-level statistics on tables as part
How the community answered
(28 responses)- A4% (1)
- C93% (26)
- D4% (1)
Explanation
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN1021
Topics
#Initialization parameters#STATISTICS_LEVEL#AWR snapshots#Optimizer statistics
Community Discussion
No community discussion yet for this question.