In your database,the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?()
- AThe optimizer statistics are collected automatically.
- BOnly the timed operating system (OS) statistics and plan execution statistics are collected.
- CThe Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
- DThe snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
- ESnapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.