My Oracle Support Banner

Steps To Disable Real Time Statistics From 19c (Doc ID 2700103.1)

Last updated on AUGUST 12, 2020

Applies to:

Siebel CRM - Version 8.0.0.6 SIA [20423] and later
Information in this document applies to any platform.

Goal

What is siebel recommendation on real time statistics in 19c DB ?

There is new feature in 19c which is enabled by default stats

19c New Feature:Real-Time Statistics (Doc ID 2552657.1)

Especially below two params

_optimizer_gather_stats_on_conventional_dml and _optimizer_use_stats_on_conventional_dm

by default its hidden parameter in DB and automatically enables this feature. Is these stats 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.