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

From: Mladen Gogala <>
Date: Mon, 10 Oct 2011 18:35:46 +0000 (UTC)
Message-ID: <>

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.

Received on Mon Oct 10 2011 - 13:35:46 CDT

Original text of this message