Which two are true about Optimizer Statistics? (Choose two.)
Which two are true about Optimizer Statistics? (Choose two.)
Optimizer statistics can be gathered using the DBMS_STATS package, which is a standard method for collecting and managing these statistics in Oracle databases. Additionally, by default, Oracle automatically gathers optimizer statistics through a scheduled maintenance job to ensure that the optimizer has the necessary information to generate efficient execution plans. These two statements accurately describe well-known features of the Oracle Database optimizer.
AE correct
Ref.: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/optimizer-statistics-concepts.html#GUID-3ED2DA31-F61B-4E8F-9166-79FB01392B1D
what happend with this parameter, OPTIMIZER_REAL_TIME_STATISTICS?
Oracle Database 19c introduces real-time statistics, which extend online support to conventional DML statements. Because statistics can go stale between DBMS_STATS jobs, real-time statistics help the optimizer generate more optimal plans.
Sure of AE, Optimizer can use stale statistics this is why it's important to frequently analize them
AE Correct: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/optimizer-statistics-concepts.html#GUID-3ED2DA31-F61B-4E8F-9166-79FB01392B1D
Agree, AE correct