Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!postnews.google.com!6g2000prh.googlegroups.com!not-for-mail From: joel garry Newsgroups: comp.databases.oracle.server Subject: Re: The exact difference between SQL profile and baselines in Oracle 11 Date: Mon, 10 Oct 2011 10:03:47 -0700 (PDT) Organization: http://groups.google.com Lines: 19 Message-ID: References: NNTP-Posting-Host: 64.58.150.28 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1318267158 9965 127.0.0.1 (10 Oct 2011 17:19:18 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Mon, 10 Oct 2011 17:19:18 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: 6g2000prh.googlegroups.com; posting-host=64.58.150.28; posting-account=tpQovAkAAABNoH5bwsZAiff2L0zxGwdv User-Agent: G2/1.0 X-Google-Web-Client: true X-Google-Header-Order: HUALESNKRC X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.18) Gecko/20110614 Firefox/3.6.18 ( .NET CLR 3.5.30729),gzip(gfe) Xref: news.cambrium.nl On Oct 10, 9:17=A0am, 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? > > --http://mgogala.byethost5.com I'm not there yet, but http://jonathanlewis.wordpress.com/2011/01/07/sql-pl= an-baselines/ is a pretty good start, especially the Kerry Osborne note on licensing. jg -- @home.com is bogus. More like Zzzzz than buzzword bingo: http://news.techeye.net/software/ellisons-oracle-social-network-baffles