Re: The exact difference between SQL profile and baselines in Oracle 11
From: joel garry <joel-garry_at_home.com>
Date: Mon, 10 Oct 2011 10:03:47 -0700 (PDT)
Message-ID: <ae0b3aa8-8bcc-44db-81e0-a5f1ecb50fbf_at_6g2000prh.googlegroups.com>
On Oct 10, 9:17 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> I must say that I'm not quite clear about the conceptual differences
> among the two. I know that SQL Profiles put in a lot of OPT_ESTIMATE
> hints and adjust cardinality estimates. I know that baselines are
> actually plans but their usage seems extremely similar. Can anyone shed
> some light on the conceptual differences?
>
> --http://mgogala.byethost5.com
Date: Mon, 10 Oct 2011 10:03:47 -0700 (PDT)
Message-ID: <ae0b3aa8-8bcc-44db-81e0-a5f1ecb50fbf_at_6g2000prh.googlegroups.com>
On Oct 10, 9:17 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> I must say that I'm not quite clear about the conceptual differences
> among the two. I know that SQL Profiles put in a lot of OPT_ESTIMATE
> hints and adjust cardinality estimates. I know that baselines are
> actually plans but their usage seems extremely similar. Can anyone shed
> some light on the conceptual differences?
>
> --http://mgogala.byethost5.com
I'm not there yet, but http://jonathanlewis.wordpress.com/2011/01/07/sql-plan-baselines/ is a pretty good start, especially the Kerry Osborne note on licensing.
jg
-- _at_home.com is bogus. More like Zzzzz than buzzword bingo: http://news.techeye.net/software/ellisons-oracle-social-network-bafflesReceived on Mon Oct 10 2011 - 12:03:47 CDT