Re: How are SQL Profiles calculated?
From: Greg Rahn <greg_at_structureddata.org>
Date: Thu, 8 Jan 2009 09:56:37 -0800
Message-ID: <a9c093440901080956j6406d81cr58cc1ca0e7cc5694_at_mail.gmail.com>
On Thu, Jan 8, 2009 at 9:38 AM, Charles Schultz <sacrophyte_at_gmail.com> wrote:
> Yes, that explains a lot, thank you very much!
> It is exciting how 11g takes this concept ("cardinality feedback", thanks
> Wolfgang!) even further.
Date: Thu, 8 Jan 2009 09:56:37 -0800
Message-ID: <a9c093440901080956j6406d81cr58cc1ca0e7cc5694_at_mail.gmail.com>
On Thu, Jan 8, 2009 at 9:38 AM, Charles Schultz <sacrophyte_at_gmail.com> wrote:
> Yes, that explains a lot, thank you very much!
> It is exciting how 11g takes this concept ("cardinality feedback", thanks
> Wolfgang!) even further.
SQL Profiles are available in 10g, so it is not a new 11g feature.
I believe Wolfgang was inspired by the slides I put together for this
presentation:
Oracle OpenWorld 2005: A Practical Approach to Optimizer Statistics in
Oracle Database 10g
http://www.oracle.com/technology/deploy/performance/pdf/PS_S961_273961_106-1_FIN_v2.pdf
which was based on some field work I had done at a few customer sites.
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 08 2009 - 11:56:37 CST