Steps To Disable the Feature of Real-Time Statistics on Oracle Database 19c?
(Doc ID 2700103.1)
Last updated on FEBRUARY 28, 2021
Applies to:Siebel CRM - Version 22.214.171.124 SIA  and later
Information in this document applies to any platform.
Oracle Database 19c introduced a new feature of Real-time statistics gathering. This is enabled by default.
Especially below two params
_optimizer_gather_stats_on_conventional_dml and _optimizer_use_stats_on_conventional_dm
1. What is the Siebel recommendation on real time statistics in 19c DB ?
2. Does this feature need to be disabled for Siebel DB?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document