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.
STATISTICS_LEVEL specifies the level of collection for database and operating system statistics. The Oracle Database collects these statistics for a variety of purposes, including making self-management decisions.
The alert log file (also referred to as the ALERT.LOG) is a chronological log of messages and errors written out by an Oracle Database. Typical messages found in this file is: database startup, shutdown, log switches, space errors, etc. This file should constantly be monitored to detect unexpected messages and corruptions.
Setting the STATISTICS_LEVEL parameter to BASIC disables the collection”
Automatic Workload Repository (AWR) Snapshots
Automatic Database Diagnostic Monitor (ADDM)
All server-generated alerts
Automatic SGA Memory Management
Automatic optimizer statistics collection
Service level statistics
Buffer cache advisory
MTTR advisory
Shared pool sizing advisory
BASIC – AWR – NOT