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 8.0.0.6 SIA [20423] and later
Information in this document applies to any platform.

Goal

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?

 

Solution

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
Goal
Solution
References


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