Optimizer Statistics are a set of data distribution statistics collected in real time as data is inserted, deleted, or updated, which are stored in AWR and used for generating SQL execution plans.
B.
Optimizer Statistics are statistics about data distribution within Oracle Datafiles.
C.
Optimizer Statistics are table, column, index, and system statistics used for generating efficient SQL execution plans.
D.
Optimizer Statistics are part of system performance statistics stored in AWR required for calculating SQL execution plans.
The Answer Is:
C
This question includes an explanation.
Explanation:
A.False. Not real-time; collected periodically.
B.False. Not about datafile distribution.
C.True. Includes table, column, index stats for plan generation.