RE: Opinions on Performance Tuning Software

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Tue, 23 Jan 2001 21:08:35 -0000
Message-Id: <10750.127323@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0010_01C08580.A5E48960 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

RE: Opinions on Performance Tuning SoftwareAhh but when it comes to re-writing SQL, and you don't have a day to try and tune various statements, and you can get a tool to do it for you? Where's the problem there..

My opinion is that tuning tools are there to save the most valuable commodity for a DBA - TIME (apart from coffee and Dilbert!)!! All of these tools are granted - pointy clicky - but if you manage to implement them to your own personal standards, and get them working for YOU, that is where they score!

Now Natasha, from what I have heard from you guys in the field, the general opinion out of the list you have formed there is that Precise would be the best option. They have very minimal overhead on the system, and works extremly well, as they have managed to map the memory structures of UNIX, and collect their data from there. Most other tools log on to Oracle, as a user (SYS mostly) and fire queries to the database.

There are two questions though, what are you trying to acheive with a tool, and how much $$$$ do you have to spend? I have heard Precise is a little costly, but hey if it works that well why not spend the cash? Leave the tool to monitor while you get PROactive!

Mark Leith
Cool Tools UK Ltd

T: 01905 330 281
M: 07771 691 122
E: mark_at_cool-tools.co.uk

"Everbody has to believe in something, I believe I'll have another beer!"

  -----Original Message-----
  From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Koivu, Lisa   Sent: Tuesday, January 23, 2001 07:38
  To: Multiple recipients of list ORACLE-L   Subject: RE: Opinions on Performance Tuning Software

Here's to tuning without the pointy-clicky stuff. I agree that you don't need a spendy piece of software to do it for you... you just need to know what to look for.

-----Original Message-----
From: Gogala, Mladen [mailto:MGogala_at_oxhp.com] Sent: Tuesday, January 23, 2001 2:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: Opinions on Performance Tuning Software

  My personal favorites are the top session monitor, otune32 (the utilities   that
  can be found on Guy Harrison's web site), sqlplus and vmstat/iostat.   Statspack
  and/or utlbstat/utlestat are also useful.

-----Original Message-----
Sent: Tuesday, January 23, 2001 1:37 PM To: Multiple recipients of list ORACLE-L

Hi gurus

  Has anyone had the privilege of test driving Savant Diagnostics, Precise SQL
  and
  Oracle Enterprise Manager and formed an opinion of which is the best?

Gaja don't respond to this : )

Regards
Natasha

  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com   --
  Author: Natasha Batson
    INET: nbatson_at_neal-and-massy.com

  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).   --
  Please see the official ORACLE-L FAQ: http://www.orafaq.com   --
  Author: Gogala, Mladen
    INET: MGogala_at_oxhp.com

  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_000_0010_01C08580.A5E48960 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>RE: Opinions on Performance Tuning Software</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR></HEAD>
<BODY>
<DIV>Ahh=20
but when it comes to re-writing SQL, and you don't have a day to try and = tune=20
various statements, and you can get a tool to do it for you? Where's the = problem=20
there..</DIV>
<DIV><SPAN=20
class=3D794545320-23012001> </DIV>
<DIV>My=20
opinion is that tuning tools are there to save the most = valuable commodity=20
for a DBA - TIME (apart from coffee and Dilbert!)!! All of these tools = are=20
granted - pointy clicky - but if you manage to implement them to your = own=20
personal standards, and get them working for YOU, that is where they = score!=20
</DIV>
<DIV><SPAN=20
class=3D794545320-23012001> </DIV>
<DIV>Now=20
Natasha, from what I have heard from you guys in the field, the = general=20
opinion out of the list you have formed there is that Precise would be = the best=20
option. They have very minimal overhead on the system, and works = extremly well,=20
as they have managed to map the memory structures of UNIX, and collect = their=20
data from there. Most other tools log on to Oracle, as a user (SYS = mostly) and=20
fire queries to the database.</DIV>
<DIV><SPAN=20
class=3D794545320-23012001> </DIV>
<DIV>There=20
are two questions though, what are you trying to acheive with a tool, = and how=20
much $$$$ do you have to spend? I have heard Precise is a little costly, = but hey=20
if it works that well why not spend the cash? Leave the tool to monitor = while=20
you get PROactive! </DIV>
<DIV><SPAN=20
class=3D794545320-23012001> </DIV>
<DIV>
Mark Leith Cool Tools UK Ltd T: 01905 330 =
281 M:=20
07771 691 122 E: mark_at_cool-tools.co.uk "Everbody has to = believe in=20
something, I believe I'll have another beer!" </DIV>
<DIV><SPAN=20
class=3D794545320-23012001> </DIV>
<DIV><SPAN=20
class=3D794545320-23012001> </DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
 <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr>-----Original Message----- From: root_at_fatcity.com=20 [mailto:root_at_fatcity.com]On Behalf Of Koivu, = Lisa Sent:=20
 Tuesday, January 23, 2001 07:38 To: Multiple recipients of = list=20
 ORACLE-L Subject: RE: Opinions on Performance Tuning=20 Software </DIV>
 Here's to tuning without the pointy-clicky = stuff.  I=20
 agree that you don't need a spendy piece of software to do it for = you... =20
 you just need to know what to look for. -----Original Message----- From:=20
 Gogala, Mladen [<A=20
 href=3D"mailto:MGogala_at_oxhp.com">mailto:MGogala_at_oxhp.com</A>] =
 <FONT=20

 size=3D2>Sent: Tuesday, January 23, 2001 2:21 PM To:=20
 Multiple recipients of list ORACLE-L Subject: RE:=20
 Opinions on Performance Tuning Software My personal favorites are the top session monitor, = otune32=20
 (the utilities that can be=20
 found on Guy Harrison's web site), sqlplus and vmstat/iostat. =
 <FONT=20

 size=3D2>Statspack and/or utlbstat/utlestat = are also=20
 useful. 
 -----Original Message----- Sent:=20
 Tuesday, January 23, 2001 1:37 PM To: = Multiple=20
 recipients of list ORACLE-L Hi gurus Has anyone had the privilege of test driving Savant=20 Diagnostics, Precise SQL and =
 <FONT=20

 size=3D2>Oracle Enterprise Manager and formed an opinion of which is = the=20
 best? 
 Gaja don't respond to this : ) Regards Natasha =
 

 -- Please see the official = ORACLE-L=20
 FAQ: <A href=3D"http://www.orafaq.com"=20 target=3D_blank>http://www.orafaq.com</A> -- =

Author: Natasha Batson  =20
INET: nbatson_at_neal-and-massy.com Fat City Network Services    -- (858) =

538-5051  FAX: (858) 538-5051 San = Diego,=20
 California        -- Public = Internet access=20
 / Mailing Lists <FONT=20
 =

size=3D2>----------------------------------------------------------------=

----=20
 To REMOVE yourself from this mailing list, send an = E-Mail=20
 message to: ListGuru_at_fatcity.com (note EXACT = spelling=20
 of 'ListGuru') and in the message BODY, = include a line=20
 containing: UNSUB ORACLE-L (or the name of = mailing=20
 list you want to be removed from).  You may also=20
 send the HELP command for other information (like subscribing). =

-- Please see the = official ORACLE-L=20
FAQ: <A href=3D"http://www.orafaq.com"=20 target=3D_blank>http://www.orafaq.com</A> -- =

Author: Gogala, Mladen  =20
 INET: MGogala_at_oxhp.com 
 Fat City Network Services    -- (858) =

538-5051  FAX: (858) 538-5051 San = Diego,=20
 California        -- Public = Internet access=20
 / Mailing Lists <FONT=20
 =

size=3D2>----------------------------------------------------------------=