RE: Extended database statistics
Date: Fri, 24 Feb 2017 15:05:23 +0000
Message-ID: <AF02C941134B1A4AB5F61A726D08DCED201EE9B0_at_USA7109MB012.na.xerox.net>
Thanks Tim.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tim Gorman
Sent: Friday, February 24, 2017 10:02 AM
To: oracle-l_at_freelists.org
Amir,
The version of EBS is important to share as well, but since the underlying database is 12c, I'm guessing it likely that EBS is R12.2.x?
If so, please be aware that the FND_STATS package in EBS R12.2 supports the gathering of extended statistics<https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T174306.htm>, and you may want to check the settings in use to determine if the presence of the extended statistics is caused by EBS settings, rather than something in the RDBMS parameters?
Hope this helps...
-Tim
On 2/24/17 07:55, Hameed, Amir wrote:
I am trying to understand the following:
Thank you,
--
The EBS version is 12.1.3.
Subject: Re: Extended database statistics
Hi,
The Oracle database version is 12c (12.1.0.2). The application is Oracle E-Business Suite.
While working on a performance issue, we discovered that there were a lot of extended statistics present in the database for standard EBS tables. We do not create extended statistics on any table as part of our statistics gathering process. The following parameters were set to TRUE:
optimizer_adaptive_features
optimizer_adaptive_reporting_only
Amir
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 24 2017 - 16:05:23 CET