Your Doorstep to the Temple of Oracle

Oracle EBS

Parameters Used in Gather Schema Statistics Program

Posted by appsdba11i on April 11, 2011

To describe the meaning of the following parameters used in the Gather Schema Statistics program:
History Mode
Gather Options
Modifications Threshold
Invalidate Dependent Cursors


* History mode is used to maintain history of gather stats runs. By default, the last run is maintained.

* Gather options refers to the Gather Auto feature which can be used to gather stats only on changed objects.

* Estimate_percent
Percentage of rows to estimate. If left empty it will default to 10%. The valid range is 0-99.
A higher percentage will be more accurate, but take longer to run.
If the object(s) that you are gathering statistics for do not change often or the object(s) has data entered that is very similar you may choose a lower number.However, if the data changes frequently a larger number entered for this parameter would be
recommended to provide a more accurate representation of your data.

* The invalidate option controls whether we invalidate cursors in the shared pool after gathering stats. The default behavior invalidates cursors, and this option can be used to avoid this if gathering stats on a busy system and it is not immediately required to utilize the new statistics.

(Doc ID 556466.1)


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s