Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feed.tweaknews.nl!87.79.20.101.MISMATCH!newsreader4.netcologne.de!news.netcologne.de!newsfeed.straub-nv.de!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.oracle.server Subject: Re: The exact difference between SQL profile and baselines in Oracle 11 Date: Mon, 10 Oct 2011 18:35:46 +0000 (UTC) Organization: solani.org Lines: 16 Message-ID: References: <9fgn5lF8pcU1@mid.individual.net> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1318271746 31868 eJwFwYEBgDAIA7CXxoCi5wil/59gkg7DVCARqRRxrXjnkKveXKtuvWb0QwCasN0R+/Gub344NhJ5 (10 Oct 2011 18:35:46 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Mon, 10 Oct 2011 18:35:46 +0000 (UTC) User-Agent: Pan/0.133 (House of Butterflies) X-User-ID: eJwFwQkBwDAIA0BLg0A65PAU/xJ656Cwj9Fpvr6CKR38d7eNiKs2BQOzS7unpkLO/RRRmdsPMQYSQA== Cancel-Lock: sha1:fmoI7PHFzq6oXoPzyXEgaIr71k8= X-NNTP-Posting-Host: eJwFwQkBwDAIBDBLlB85cAz/EpaY+HOEurna2Wl6FfzAiDpqzC75vopIEuxMM9iMo4R1damt3l3H4AMGXcyietmPK+kH5vMaVA== Xref: news.cambrium.nl 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.com