My Oracle Support Banner

Siebel CRM and Oracle Database 19c: Changing from coe_siebel_stats.sql Script to DBMS_STATS to collect Siebel Schema Statistics (Doc ID 2806299.1)

Last updated on NOVEMBER 25, 2021

Applies to:

Siebel CRM - Version 18.6 and later
Information in this document applies to any platform.

Goal

Based on the new document Performance Tuning Guidelines for Siebel CRM Applications Upgrading to Oracle 19c (Doc ID 2791575.1), Siebel environments running Oracle 19c should not have the statistics collected by Siebel provided coe_siebel_stats.sql script, but by Oracle db DBMS_STATS command.

It was noticed that the current Siebel environment has more than 3300 tables, which statistics are locked.

1. Should the statistics be unlocked for these tables?
2. Does the mandate to "drop and lock statistics for Siebel tables with 15 rows or less" in 10g, 11g and 12c databases still applicable in 19c databases?
 

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


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