What is the impact of this setting?

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

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.



Leave a Reply 1

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


amateur

amateur

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