Re: Query Performance with params

From: Ram Raman <veeeraman_at_gmail.com>
Date: Mon, 1 May 2017 09:48:15 -0500
Message-ID: <CAHSa0M3Y8nZetzP5-cfsW2Lq9LU4oLgYq8mEXU3ywX2bF6Hxuw_at_mail.gmail.com>



Thanks everyone who responded. I will research, capture statements, etc. I got dragged into other issues Monday am!

On Mon, May 1, 2017 at 9:02 AM, Stefan Koehler <contact_at_soocs.de> wrote:

> Hey Mladen,
> sorry i do not get it.
>
> The new type of histograms (including new collection - NDV for frequency
> and "Top-N" histograms) are mainly implemented by DBMS_STATS and the cost
> based optimizer has just slightly enhanced its arithmetic for it. The
> clustering factor enhancement (table_cached_blocks) has already been
> available
> with 11.2.0.4 (back-port).
>
> These are just little enhancements of the CBO and far away from a
> "complete re-write" - especially not justifying "My usual advice to the
> customers is
> to wait for the first major patch set of the version 12.2".
>
> Oracle's 12.1 CBO is more than stable for production.
>
> Best Regards
> Stefan Koehler
>
> Independent Oracle performance consultant and researcher
> Website: http://www.soocs.de
> Twitter: _at_OracleSK
> Upcoming online seminar: http://tinyurl.com/17-06-13-Shared-Pool-Internals
>
> > Mladen Gogala <gogala.mladen_at_gmail.com> hat am 1. Mai 2017 um 14:22
> geschrieben:
> >
> > Well, there are several more changes you didn't mention: new type of
> > histograms, much larger histograms and a new way to calculate clustering
> > factor.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 01 2017 - 16:48:15 CEST

Original text of this message