Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL Tuning

RE: SQL Tuning

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Fri, 3 Nov 2000 13:12:31 -0500
Message-Id: <10669.121099@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C045C1.A2570660
Content-Type: text/plain;

        charset="iso-8859-1"

What is the pricing?

Alex Hillman

-----Original Message-----
From: Mark Leith [mailto:mark_at_cool-tools.co.uk] Sent: Friday, November 03, 2000 10:31 AM To: Multiple recipients of list ORACLE-L Subject: RE: SQL Tuning

I have a suggestion for what I feel is the best SQL optimisation tool in the market! It's a tool called SQLExpert from a company called Leccotech.

This tool uses a feedback engine which looks at the structure of the database, and then rewrites as many semantically equivalent statements as is possible - automatically - for you! You can then run these alternate statements through an automated process to determine which statement has either the best response or elapsed times. Then generate a lovely little report for the damagement!

The tool comes in either Developer or DBA editions, so you can have a developer looking at SQL from source, and developing new SQL, and the DBA gets an extra interactive module that looks at the SOLARIA and alike, and harvests "bad" SQL through criteria - PROCESS/USERNAME/HIGH BUFFER GETS etc..

Take a look at www.leccotech.com to learn more about it..

Also available through Cool-Tools :)

Mark

Mark Leith



Cool Tools UK Ltd
+44 1905 330 281
mark_at_cool-tools.co.uk

P.S sorry about the plug..


Does anyone have any suggestion on a good SQL Tunning tool.

Thanks

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C045C1.A2570660
Content-Type: text/html;

        charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0">
<TITLE>RE: SQL Tuning</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>What is the pricing?</FONT> </P>

<P><FONT SIZE=2>Alex Hillman</FONT>
</P>

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Mark Leith [<A HREF="mailto:mark_at_cool-tools.co.uk">mailto:mark_at_cool-tools.co.uk</A>]</FONT>
<BR><FONT SIZE=2>Sent: Friday, November 03, 2000 10:31 AM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: RE: SQL Tuning</FONT>
</P>
<BR>

<P><FONT SIZE=2>I have a suggestion for what I feel is the best SQL optimisation tool in the</FONT>
<BR><FONT SIZE=2>market! It's a tool called SQLExpert from a company called Leccotech.</FONT> </P>
<P><FONT SIZE=2>This tool uses a feedback engine which looks at the structure of the</FONT>
<BR><FONT SIZE=2>database, and then rewrites as many semantically equivalent statements as is</FONT>
<BR><FONT SIZE=2>possible - automatically - for you! You can then run these alternate</FONT>
<BR><FONT SIZE=2>statements through an automated process to determine which statement has</FONT>
<BR><FONT SIZE=2>either the best response or elapsed times. Then generate a lovely little</FONT>
<BR><FONT SIZE=2>report for the damagement!</FONT>
</P>

<P><FONT SIZE=2>The tool comes in either Developer or DBA editions, so you can have a</FONT>
<BR><FONT SIZE=2>developer looking at SQL from source, and developing new SQL, and the DBA</FONT>
<BR><FONT SIZE=2>gets an extra interactive module that looks at the SOLARIA and alike, and</FONT>
<BR><FONT SIZE=2>harvests &quot;bad&quot; SQL through criteria - PROCESS/USERNAME/HIGH BUFFER GETS</FONT>
<BR><FONT SIZE=2>etc..</FONT>
</P>

<P><FONT SIZE=2>Take a look at www.leccotech.com to learn more about it..</FONT> </P>

<P><FONT SIZE=2>Also available through Cool-Tools :)</FONT> </P>

<P><FONT SIZE=2>Mark</FONT>
</P>

<P><FONT SIZE=2>Mark Leith</FONT>
<BR><FONT SIZE=2>=================</FONT>
<BR><FONT SIZE=2>Cool Tools UK Ltd</FONT>
<BR><FONT SIZE=2>+44 1905 330 281</FONT>
<BR><FONT SIZE=2>mark_at_cool-tools.co.uk</FONT>
</P>

<P><FONT SIZE=2>P.S sorry about the plug..</FONT> </P>

<P><FONT SIZE=2>------</FONT>
</P>

<P><FONT SIZE=2>Does anyone have any suggestion on a good SQL Tunning tool.</FONT> </P>

<P><FONT SIZE=2>Thanks</FONT>
</P>

<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: Mark Leith</FONT>
<BR><FONT SIZE=2>&nbsp; INET: mark_at_cool-tools.co.uk</FONT>
</P>

<P><FONT SIZE=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / Mailing Lists</FONT>
<BR><FONT SIZE=2>--------------------------------------------------------------------</FONT>
<BR><FONT SIZE=2>To REMOVE yourself from this mailing list, send an E-Mail message</FONT>
<BR><FONT SIZE=2>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</FONT>
<BR><FONT SIZE=2>the message BODY, include a line containing: UNSUB ORACLE-L</FONT>
<BR><FONT SIZE=2>(or the name of mailing list you want to be removed from).&nbsp; You may</FONT> <BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT> Received on Fri Nov 03 2000 - 12:12:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US