Since you're on 12.1.0.2 it might be the last stage of:
http://jonathanlewis.wordpress.com/2016/08/02/adaptive-mayhem/
Regards
Jonathan Lewis
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Hameed, Amir <Amir.Hameed@xxxxxxxxx>
Sent: 24 February 2017 14:55:07
To: oracle-l@xxxxxxxxxxxxx
Subject: 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
I am trying to understand the following:
1. Does Oracle collect extended statistics automatically if the
optimizer_adaptive_features parameter is set to TRUE?
2. Is there a way to find out from the explain plan if extended
statistics were used in the plan?
Thank you,
Amir
--
//www.freelists.org/webpage/oracle-l