Re: Extended database statistics

From: Jonathan Lewis <>
Date: Fri, 24 Feb 2017 15:09:17 +0000
Message-ID: <MMXP123MB0847645AC156B5FDEF4F12ADA5520_at_MMXP123MB0847.GBRP123.PROD.OUTLOOK.COM>

Since you're on it might be the last stage of:

Jonathan Lewis

From: <> on behalf of Hameed, Amir <> Sent: 24 February 2017 14:55:07
Subject: Extended database statistics

The Oracle database version is 12c ( 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

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,

Received on Fri Feb 24 2017 - 16:09:17 CET

Original text of this message