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 JUNE 05, 2023

Applies to:

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

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