My Oracle Support Banner

Many Modifications / Bad Statistics Even Though They're Gathered Daily (Doc ID 2761975.1)

Last updated on MARCH 19, 2021

Applies to:

Oracle E-Business Suite Performance - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, System Tuning Issue

ACTUAL BEHAVIOR
---------------
Statistics analyzer reports many Tables With More Than 10% Modifications even immediately after Gather Schema Statistics.

Params for Gather Schema Stats: ALL, , , NOBACKUP, , LASTRUN, GATHER AUTO, , Y

EXPECTED BEHAVIOR
-----------------------
There shouldn't appear in this way, as GSS has been already executed

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run GSS
2. Run DB analyzer from EBS Database Performance and Statistics Analyzer Doc ID 2126712.1
3. The issue can be observed in db analyzer output



Changes

 

Cause

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
Symptoms
Changes
Cause
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.