My Oracle Support Banner

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 [100] and later
Information in this document applies to any platform.
Oracle RDBMS for Siebel

Goal

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.

For example:
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?

 

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.