My Oracle Support Banner

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 SIA [20423] 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.