Re: How are SQL Profiles calculated?
From: Greg Rahn <greg_at_structureddata.org>
Date: Thu, 8 Jan 2009 14:11:14 -0800
Message-ID: <a9c093440901081411p30ec8697hdc33a4a6feddf4d5_at_mail.gmail.com>
On Thu, Jan 8, 2009 at 10:27 AM, Charles Schultz <sacrophyte_at_gmail.com> wrote:
> *grin* I do not know who inspired who, but I appreciate that you and many
> others have endeavored to expose the internals and help the rest of us
> unravel the mysteries hidden within.
>
> Yes, I realize SQL Profiles is not new in 11g, but I was referring more
> specifically to the new Sql Plan Management - granted, I realize this is not
> exactly related. As I said, it is the direction that I find exciting. IBM's
> LEO (Learning Optimizer) seems to have set quite a stir in the Oracle world.
Date: Thu, 8 Jan 2009 14:11:14 -0800
Message-ID: <a9c093440901081411p30ec8697hdc33a4a6feddf4d5_at_mail.gmail.com>
On Thu, Jan 8, 2009 at 10:27 AM, Charles Schultz <sacrophyte_at_gmail.com> wrote:
> *grin* I do not know who inspired who, but I appreciate that you and many
> others have endeavored to expose the internals and help the rest of us
> unravel the mysteries hidden within.
>
> Yes, I realize SQL Profiles is not new in 11g, but I was referring more
> specifically to the new Sql Plan Management - granted, I realize this is not
> exactly related. As I said, it is the direction that I find exciting. IBM's
> LEO (Learning Optimizer) seems to have set quite a stir in the Oracle world.
I'm not really worried about it either - I'm glad that people have picked up on it as it the first step in debugging poor execution plans.
Sql Plan Management basically has the same premise as this quote from
George W. Bush:
"There's an old saying ... that says, fool me once, shame on... shame
on you. Fool me - you can't get fooled again."
And it is a very interesting subject area as well as a complex one.
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 08 2009 - 16:11:14 CST