When preparing a new database installation, you want to ensure automatic collection of timed statistics. Which three configuration parameters are applicable?
A.
STATISTICS_LEVEL parameter set to TYPICAL
B.
STATISTICS_LEVELparameter set to All
C.
TIMED_STATISTICSparameter set to true
D.
ALL_TIMED_STATISTICSparameter set to TRUE
E.
AUTO_STATSparameter set to TRUE
F.
STATISTICS_LEVELparameter set to BASIC.
ABF ???
ABC
ABC
https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams245.htm#REFRN10218
Starting with release 11.1.0.7.0, the value of the TIMED_STATISTICS parameter cannot be set to false if the value of STATISTICS_LEVEL is set to TYPICAL or ALL.
ABC