In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?

Automatic optimizer statistics collection requires STATISTICS_LEVEL to be set to TYPICAL or ALL, not BASIC.

Timed OS statistics and plan execution statistics are enabled at the ALL level, not at BASIC.

With STATISTICS_LEVEL=BASIC, Oracle disables automatic AWR snapshot generation because AWR requires the parameter to be set to TYPICAL or ALL. Without automatic snapshots, features like Automatic Database Diagnostic Monitor (ADDM) and automatic optimizer statistics collection are also disabled. TYPICAL is the recommended default that enables AWR and most advisory features.

Manual snapshot collection via DBMS_WORKLOAD_REPOSITORY is still possible even when STATISTICS_LEVEL=BASIC; only automatic snapshot generation is disabled.

Oracle does not dynamically generate table statistics as part of query optimization at any STATISTICS_LEVEL setting; this describes no real Oracle behavior.