In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.
What is the impact of this setting?
A.
Optimizer statistics are collected automatically.
B.
Only timed operating system (OS) statistics and plan execution statistics are collected.
C.
The snapshots for the Automatic Workload Repository (AWR) are not generated
automatically.
D.
Snapshots cannot be collected manually by using the
DBMS_WORKLOAD_REPOSITORY package.
E.
The Oracle server dynamically generates the necessary statistics on tables as part of
query optimization.
correct answer: C
C
C
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214
Setting the STATISTICS_LEVEL parameter to BASIC disables the collection of many of the important statistics required by Oracle Database features and functionality, including:
Automatic Workload Repository (AWR) Snapshots
Automatic Database Diagnostic Monitor (ADDM)
All server-generated alerts
Automatic SGA Memory Management
Automatic optimizer statistics collection
Object level statistics
End to End Application Tracing (V$CLIENT_STATS)
Database time distribution statistics (V$SESS_TIME_MODEL and V$SYS_TIME_MODEL)
Service level statistics
Buffer cache advisory
MTTR advisory
Shared pool sizing advisory
Segment level statistics
PGA Target advisory
Timed statistics
Monitoring of statistics