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.

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-l
Received on Thu Jan 08 2009 - 11:56:37 CST

Original text of this message