Re: The exact difference between SQL profile and baselines in Oracle 11
From: Randolf Geist <mahrah_at_web.de>
Date: Tue, 11 Oct 2011 05:21:28 -0700 (PDT)
Message-ID: <c33a4ce6-eed4-4f25-abed-7564137857bd_at_dk6g2000vbb.googlegroups.com>
On 10 Okt., 18:17, 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: Tue, 11 Oct 2011 05:21:28 -0700 (PDT)
Message-ID: <c33a4ce6-eed4-4f25-abed-7564137857bd_at_dk6g2000vbb.googlegroups.com>
On 10 Okt., 18:17, 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
Another good read that should not be left unmentioned: http://intermediatesql.com
Search for the expression "SQL Plan Management", and a few interesting posts will pop up.
Hope this helps,
Randolf
Received on Tue Oct 11 2011 - 07:21:28 CDT