What is the impact of this setting?

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

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

A.
Only the timed operating system (OS) statistics and plan execution statistics are collected.

B.
The Oracle server dynamically generates the necessary statistics on tables as part of query
optimization.

C.
The optimizer statistics are collected automatically.

D.
The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.

E.
Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY
PACKAGE.



Leave a Reply 0

Your email address will not be published. Required fields are marked *