Oracle
1Z0-050 · Question #38
In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?
The correct answer is E. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically. See the full explanation below for the reasoning.
Question
In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?
Options
- ASnapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY
- BThe Oracle server dynamically generates the necessary statistics on tables as part of query
- COptimizer statistics are collected automatically
- DOnly timed operating system (OS) statistics and plan execution statistics are collected
- EThe snapshots for the Automatic Workload Repository (AWR) are not generated automatically
How the community answered
(17 responses)- A6% (1)
- B6% (1)
- D12% (2)
- E76% (13)
Community Discussion
No community discussion yet for this question.