How to Change the Frequency of Database Statistics Updates?
(Doc ID 2611453.1)
Last updated on MARCH 12, 2021
Applies to:Siebel CRM - Version 7.5.3  and later
Information in this document applies to any platform.
Oracle RDBMS for Siebel
When using the coe_siebel_stats_11_4_4_6.sql script from Doc ID 2077227.2 to collect database statistics it was noted that few large tables do not get analyzed frequently.
Production has a table with 610 Million rows and 400k rows change every day. Such table would need to be analyzed more frequently.
Can the [sysdate - x ] value in the script be modified to increase the frequency of database statistics stats updated?
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