Re: The exact difference between SQL profile and baselines in Oracle 11

From: Randolf Geist <>
Date: Tue, 11 Oct 2011 05:21:28 -0700 (PDT)
Message-ID: <>

On 10 Okt., 18:17, Mladen Gogala <> 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?
> --

Another good read that should not be left unmentioned:

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

Original text of this message