From oracle-l-bounce@freelists.org Mon Mar 15 07:59:24 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2FDxOs07170 for ; Mon, 15 Mar 2004 07:59:24 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2FDxNo07165 for ; Mon, 15 Mar 2004 07:59:23 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CE7CB390832; Mon, 15 Mar 2004 08:58:17 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 15 Mar 2004 08:57:13 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.189]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D76003907B0 for ; Mon, 15 Mar 2004 08:57:12 -0500 (EST) Received: from [212.227.126.155] (helo=mrelayng.kundenserver.de) by moutng.kundenserver.de with esmtp (Exim 3.35 #1) id 1B2sgD-0001LI-00 for oracle-l@freelists.org; Mon, 15 Mar 2004 15:02:57 +0100 Received: from [62.69.73.48] (helo=mark) by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1) id 1B2sgC-0003b7-00 for oracle-l@freelists.org; Mon, 15 Mar 2004 15:02:57 +0100 From: "Mark Leith" To: Subject: RE: Re[2]: oracle can ignore hints Date: Mon, 15 Mar 2004 14:05:01 -0000 Organization: Cool-Tools UK Limited Message-ID: <004401c40a96$82ee3d40$04fea8c0@mark> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 In-Reply-To: <20040315131843.YSQE26108.lakemtao01.cox.net@smtp.east.cox.net> X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 Importance: Normal X-Provags-ID: kundenserver.de abuse@kundenserver.de auth:b84f750678d1b190d66395c4009b4b4f X-archive-position: 820 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mark@cool-tools.co.uk Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l Jonathan - are you referring to SQLExpert? This tool does in fact re-write a given piece of SQL in every semantically equivalent way that is possible (including hints, rewriting the code semantics etc.) - then shows you all of the re-written statements that have an alternate execution plan to the source SQL for benchmarking.. I'm pretty sure that no other SQL tuner in the market does this quite like SQLExpert (please correct me if I'm wrong - I don’t get the chance to test out new versions of competitors products lately, and they may be catching up with SQLExpert - which has been doing tuning this way since first release..). The vendor is Leccotech by the way - we are a UK distributor. Mark Mark Leith Cool-Tools UK Limited Tel: 01905 330 281 Fax: 08701 275 283 mark@cool-tools.co.uk http://www.cool-tools.co.uk -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of ryan.gaffuri@cox.net Sent: 15 March 2004 13:19 To: oracle-l@freelists.org; Niall Litchfield Subject: Re: Re[2]: oracle can ignore hints embarcadero is one. I think quest's does the same thing. > > From: Jonathan Gennick > Date: 2004/03/15 Mon AM 08:01:38 EST > To: Niall Litchfield > Subject: Re[2]: oracle can ignore hints > > Monday, March 15, 2004, 4:12:55 AM, Niall Litchfield > (n-litchfield@audit-commission.gov.uk) wrote: > NL> Stated like this it is obvious that most tuning efforts are at > NL> best wasteful of effort (and indeed could probably be done better > NL> by software which is great at trying hundreds or thousands of > NL> possibilities in a scattergun approach). > > I have seen such software. I don't recall the vendor at the moment, > but that software exists. You can probably see it demoed at the next > OracleWorld. > > Best regards, > > Jonathan Gennick --- Brighten the corner where you are > http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com > > Join the Oracle-article list and receive one > article on Oracle technologies per month by > email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, > or send email to Oracle-article-request@gennick.com and > include the word "subscribe" in either the subject or body. > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@freelists.org put > 'unsubscribe' in the subject line. > -- > Archives are at http://www.freelists.org/archives/oracle-l/ > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.619 / Virus Database: 398 - Release Date: 10/03/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.619 / Virus Database: 398 - Release Date: 10/03/2004 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------