Sqlexpert is part of the TOAD expert package I believe. The TOAD price is cheaper than the stand alone package. The choices that the package gives you for tuning are helpfull reminders and the package will perform a time/cost study also. Ron >>> ryan.gaffuri@xxxxxxx 03/15/2004 11:07:22 AM >>> what did you think of sqlexpert? > > From: Jonathan Gennick <jonathan@xxxxxxxxxxx> > Date: 2004/03/15 Mon AM 10:40:33 EST > To: Mark Leith <oracle-l@xxxxxxxxxxxxx> > Subject: Re[4]: oracle can ignore hints > > Hello Mark, > > Yep. SQLExpert. Leccotech. That sounds about right. That's > the tool I've seen demoed. > > Best regards, > > Jonathan Gennick --- Brighten the corner where you are > http://Gennick.com * 906.387.1698 * mailto:jonathan@xxxxxxxxxxx > > 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@xxxxxxxxxxx and > include the word "subscribe" in either the subject or body. > > > Monday, March 15, 2004, 9:05:01 AM, Mark Leith (mark@xxxxxxxxxxxxxxxx) wrote: > ML> Jonathan - are you referring to SQLExpert? This tool does in fact > ML> re-write a given piece of SQL in every semantically equivalent way that > ML> is possible (including hints, rewriting the code semantics etc.) - then > ML> shows you all of the re-written statements that have an alternate > ML> execution plan to the source SQL for benchmarking.. > > ML> I'm pretty sure that no other SQL tuner in the market does this quite > ML> like SQLExpert (please correct me if I'm wrong - I don't get the chance > ML> to test out new versions of competitors products lately, and they may be > ML> catching up with SQLExpert - which has been doing tuning this way since > ML> first release..). > > ML> The vendor is Leccotech by the way - we are a UK distributor. > > ML> Mark > > ML> Mark Leith > ML> Cool-Tools UK Limited > > ML> Tel: 01905 330 281 > ML> Fax: 08701 275 283 > ML> mark@xxxxxxxxxxxxxxxx > ML> http://www.cool-tools.co.uk > > > ML> -----Original Message----- > ML> From: oracle-l-bounce@xxxxxxxxxxxxx > ML> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of ryan.gaffuri@xxxxxxx > ML> Sent: 15 March 2004 13:19 > ML> To: oracle-l@xxxxxxxxxxxxx; Niall Litchfield > ML> Subject: Re: Re[2]: oracle can ignore hints > > > ML> embarcadero is one. I think quest's does the same thing. > >> > >> From: Jonathan Gennick <jonathan@xxxxxxxxxxx> > >> Date: 2004/03/15 Mon AM 08:01:38 EST > >> To: Niall Litchfield <oracle-l@xxxxxxxxxxxxx> > >> Subject: Re[2]: oracle can ignore hints > >> > >> Monday, March 15, 2004, 4:12:55 AM, Niall Litchfield > >> (n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx) 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@xxxxxxxxxxx > >> > >> Join the Oracle-article list and receive one > >> article on Oracle technologies per month by > >> email. To join, visit > ML> http://four.pairlist.net/mailman/listinfo/oracle-article, > >> or send email to Oracle-article-request@xxxxxxxxxxx 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@xxxxxxxxxxxxx put > >> 'unsubscribe' in the subject line. > >> -- > >> Archives are at //www.freelists.org/archives/oracle-l/ > >> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > >> ----------------------------------------------------------------- > >> > > ML> ---------------------------------------------------------------- > ML> Please see the official ORACLE-L FAQ: http://www.orafaq.com > ML> ---------------------------------------------------------------- > ML> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put > ML> 'unsubscribe' in the subject line. > ML> -- > ML> Archives are at //www.freelists.org/archives/oracle-l/ > ML> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ML> ----------------------------------------------------------------- > > ML> --- > ML> Incoming mail is certified Virus Free. > ML> Checked by AVG anti-virus system (http://www.grisoft.com). > ML> Version: 6.0.619 / Virus Database: 398 - Release Date: 10/03/2004 > > > ML> --- > ML> Outgoing mail is certified Virus Free. > ML> Checked by AVG anti-virus system (http://www.grisoft.com). > ML> Version: 6.0.619 / Virus Database: 398 - Release Date: 10/03/2004 > > > ML> ---------------------------------------------------------------- > ML> Please see the official ORACLE-L FAQ: http://www.orafaq.com > ML> ---------------------------------------------------------------- > ML> To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > ML> put 'unsubscribe' in the subject line. > ML> -- > ML> Archives are at //www.freelists.org/archives/oracle-l/ > ML> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ML> ----------------------------------------------------------------- > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------