What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?
A.
Optimizer statistics are collected automatically.
B.
Only timed operating system (OS) statistics and plan execution statistics are collected.
C.
Automatic Workload Repository (AWR) snapshots are not generated automatically.
D.
The Oracle server dynamically generates the necessary object-level statistics on tables as part of query
optimization.
Explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214