Re: The exact difference between SQL profile and baselines in Oracle 11
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 10 Oct 2011 18:35:46 +0000 (UTC)
Message-ID: <pan.2011.10.10.18.35.46_at_gmail.com>
On Mon, 10 Oct 2011 19:09:08 +0200, Robert Klemme wrote:
Date: Mon, 10 Oct 2011 18:35:46 +0000 (UTC)
Message-ID: <pan.2011.10.10.18.35.46_at_gmail.com>
On Mon, 10 Oct 2011 19:09:08 +0200, Robert Klemme wrote:
> I think a baseline contains the data on which profile creation is based:
Baselines are plans. Profiles contain hints and therefore are used to influence plans. My problem is what happens when I have both. Will profiles influence the plans determined by baselines? What is the exact mechanism? Oracle has several mechanisms covering roughly the same area: outlines, profiles and baselines. I am trying to develop test cases to see what happens in the different situations, but it's slow. What I'm asking for is if somebody else has done that research.
-- http://mgogala.byethost5.comReceived on Mon Oct 10 2011 - 13:35:46 CDT