The exact difference between SQL profile and baselines in Oracle 11
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 10 Oct 2011 16:17:22 +0000 (UTC)
Message-ID: <pan.2011.10.10.16.17.22_at_gmail.com>
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?
Date: Mon, 10 Oct 2011 16:17:22 +0000 (UTC)
Message-ID: <pan.2011.10.10.16.17.22_at_gmail.com>
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.comReceived on Mon Oct 10 2011 - 11:17:22 CDT