PREFERENCE_OVERRIDES_PARAMETER in Oracle
What is PREFERENCE_OVERRIDES_PARAMETER We discussed optimizer statistics preferences in the previous blog post and we know that that got overwritten by the values given explicitly in the dbms_stats procedure Oracle Database 12 Release 2 includes a new DBMS_STATS preference called PREFERENCE_OVERRIDES_PARAMETER When this preference is set to TRUE, it allows preference settings to override DBMS_STATS …
PREFERENCE_OVERRIDES_PARAMETER in Oracle Read More »