Re: Opinions on Performance Tuning Software

From: Natasha Batson <nbatson_at_neal-and-massy.com>
Date: Wed, 24 Jan 2001 13:07:39 -0400
Message-Id: <10751.127377@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_019C_01C08606.A185CC40 Content-Type: text/plain;

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

RE: Opinions on Performance Tuning Software Thanks for the feedback everyone!

I have to agree with Mark with regards to hey why not use a tool that's = going to save you time?
I also agree with his suggestion of Precise SQL to be used as an SQL = statement tuning tool.

How about a DB Management tool? e.g. Oracle Enterprise = Manager/Performance Pack or Savant
Diagnostics? Which do you think is the better of the two? Anyone?

Original Message -----=20 From: Mark Leith=20 To: Multiple recipients of list ORACLE-L=20 Sent: Tuesday, January 23, 2001 5:10 PM Subject: RE: Opinions on Performance Tuning Software

Ahh 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!=20

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!=20

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!"=20

-----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-----=20
From: Gogala, Mladen [mailto:MGogala_at_oxhp.com]=20 Sent: Tuesday, January 23, 2001 2:21 PM=20 To: Multiple recipients of list ORACLE-L=20 Subject: RE: Opinions on Performance Tuning Software=20

My personal favorites are the top session monitor, otune32 (the = utilities=20

that=20
can be found on Guy Harrison's web site), sqlplus and vmstat/iostat. =

Statspack=20
and/or utlbstat/utlestat are also useful.=20

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

Hi gurus=20

Has anyone had the privilege of test driving Savant Diagnostics, = Precise SQL=20

and=20
Oracle Enterprise Manager and formed an opinion of which is the = best?=20

Gaja don't respond to this : )=20

Regards=20
Natasha=20

--=20

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

    Author: Natasha Batson=20
      INET: nbatson_at_neal-and-massy.com=20

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051=20 San Diego, California -- Public Internet access / Mailing = Lists=20

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

--=20

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

    Author: Gogala, Mladen=20
      INET: MGogala_at_oxhp.com=20

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051=20 San Diego, California -- Public Internet access / Mailing = Lists=20

------=_NextPart_000_019C_01C08606.A185CC40 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 http-equiv=3DContent-Type content=3D"text/html; =

charset=3Diso-8859-1">

<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks for the feedback =

everyone!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I have to agree with Mark with regards = to hey why=20
not use a tool that's going to save you time?</FONT></DIV> <DIV><FONT face=3DArial size=3D2>I also agree with his suggestion of = Precise SQL to=20
be used as an SQL statement tuning tool.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>How about a DB Management tool? e.g. = Oracle=20
Enterprise Manager/Performance Pack or Savant</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Diagnostics? Which do you think is the = better of=20
the two? Anyone?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV> <BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; = BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A title=3Dmark_at_cool-tools.co.uk =
href=3D"mailto:mark_at_cool-tools.co.uk">Mark=20   Leith</A> </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = title=3DORACLE-L_at_fatcity.com=20
  href=3D"mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list = ORACLE-L</A>=20
  </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Tuesday, January 23, 2001 = 5:10=20
  PM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: Opinions on = Performance=20
  Tuning Software</DIV>
  <DIV><FONT face=3DArial size=3D2></FONT><FONT face=3DArial = size=3D2></FONT><BR></DIV>
  <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN = class=3D794545320-23012001>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=20
  problem there..</SPAN></FONT></DIV>
  <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20   class=3D794545320-23012001></SPAN></FONT> </DIV>   <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN = class=3D794545320-23012001>My=20
  opinion is that tuning tools are there to save the most=20   valuable commodity for a DBA - TIME (apart from coffee and = Dilbert!)!!=20
  All of these tools are granted - pointy clicky - but if you manage to=20   implement them to your own personal standards, and get them working = for YOU,=20
  that is where they score! </SPAN></FONT></DIV>   <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20   class=3D794545320-23012001></SPAN></FONT> </DIV>   <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN = class=3D794545320-23012001>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=20
  best option. They have very minimal overhead on the system, and works = extremly=20
  well, as they have managed to map the memory structures of UNIX, and = collect=20
  their data from there. Most other tools log on to Oracle, as a user = (SYS=20
  mostly) and fire queries to the database.</SPAN></FONT></DIV>   <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20   class=3D794545320-23012001></SPAN></FONT> </DIV>   <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20   class=3D794545320-23012001>There are two questions though, what are = you trying=20
  to acheive with a tool, and how much $$$$ do you have to spend? I have = heard=20
  Precise is a little costly, but hey if it works that well why not = spend the=20
  cash? Leave the tool to monitor while you get PROactive! = </SPAN></FONT></DIV>
  <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20   class=3D794545320-23012001></SPAN></FONT> </DIV>   <DIV>
  <P><FONT size=3D2>Mark Leith<BR>Cool Tools UK Ltd<BR><BR>T: 01905 330 = 281<BR>M:=20
  07771 691 122<BR>E: mark_at_cool-tools.co.uk<BR><BR>"Everbody has to = believe in=20
  something, I believe I'll have another beer!"</FONT> </P></DIV>   <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20   class=3D794545320-23012001></SPAN></FONT> </DIV>   <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20   class=3D794545320-23012001></SPAN></FONT> </DIV>   <BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">     <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT = face=3DTahoma=20

size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com =

[mailto:root_at_fatcity.com]<B>On Behalf Of </B>Koivu, = Lisa<BR><B>Sent:</B>=20

Tuesday, January 23, 2001 07:38<BR><B>To:</B> Multiple recipients of = list=20

ORACLE-L<BR><B>Subject:</B> RE: Opinions on Performance Tuning=20 Software<BR><BR></DIV></FONT>
<P><FONT size=3D2>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=20 you...  you just need to know what to look for.</FONT></P><BR> <P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT = size=3D2>From:=20

Gogala, Mladen [<A=20
href=3D"mailto:MGogala_at_oxhp.com">mailto:MGogala_at_oxhp.com</A>]</FONT> = <BR><FONT=20

size=3D2>Sent: Tuesday, January 23, 2001 2:21 PM</FONT> <BR><FONT = size=3D2>To:=20

Multiple recipients of list ORACLE-L</FONT> <BR><FONT = size=3D2>Subject: RE:=20

Opinions on Performance Tuning Software</FONT> </P><BR> <P><FONT size=3D2>My personal favorites are the top session monitor, = otune32=20

(the utilities</FONT> <BR><FONT size=3D2>that</FONT> <BR><FONT = size=3D2>can be=20

found on Guy Harrison's web site), sqlplus and vmstat/iostat.</FONT> =

<BR><FONT size=3D2>Statspack</FONT> <BR><FONT size=3D2>and/or = utlbstat/utlestat=20

are also useful.</FONT> </P>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT = size=3D2>Sent:=20

Tuesday, January 23, 2001 1:37 PM</FONT> <BR><FONT size=3D2>To: = Multiple=20

recipients of list ORACLE-L</FONT> </P><BR> <P><FONT size=3D2>Hi gurus</FONT> </P> <P><FONT size=3D2>Has anyone had the privilege of test driving = Savant=20

Diagnostics, Precise SQL</FONT> <BR><FONT size=3D2>and</FONT> = <BR><FONT=20

size=3D2>Oracle Enterprise Manager and formed an opinion of which is = the=20

best?</FONT> </P>

    <P><FONT size=3D2>Gaja don't respond to this : )</FONT> </P>
    <P><FONT size=3D2>Regards</FONT> <BR><FONT size=3D2>Natasha</FONT> =
</P><BR><BR>
    <P><FONT size=3D2>-- </FONT><BR><FONT size=3D2>Please see the =

official ORACLE-L=20

FAQ: <A target=3D_blank=20
href=3D"http://www.orafaq.com">http://www.orafaq.com</A></FONT> = <BR><FONT=20

size=3D2>-- </FONT><BR><FONT size=3D2>Author: Natasha Batson</FONT> = <BR><FONT=20

size=3D2>  INET: nbatson_at_neal-and-massy.com</FONT> </P> <P><FONT size=3D2>Fat City Network Services    -- = (858)=20

538-5051  FAX: (858) 538-5051</FONT> <BR><FONT size=3D2>San = Diego,=20

California        -- Public = Internet=20

access / Mailing Lists</FONT> <BR><FONT=20 =

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

----</FONT>=20

<BR><FONT size=3D2>To REMOVE yourself from this mailing list, send = an E-Mail=20

    message</FONT> <BR><FONT size=3D2>to: ListGuru_at_fatcity.com (note = EXACT=20
    spelling of 'ListGuru') and in</FONT> <BR><FONT size=3D2>the message = BODY,=20
    include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT = size=3D2>(or the=20

name of mailing list you want to be removed from).  You = may</FONT>=20

<BR><FONT size=3D2>also send the HELP command for other information = (like=20

subscribing).</FONT> <BR><FONT size=3D2>-- </FONT><BR><FONT = size=3D2>Please see=20

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

size=3D2>-- </FONT><BR><FONT size=3D2>Author: Gogala, Mladen</FONT> = <BR><FONT=20

size=3D2>  INET: MGogala_at_oxhp.com</FONT> </P> <P><FONT size=3D2>Fat City Network Services    -- = (858)=20

538-5051  FAX: (858) 538-5051</FONT> <BR><FONT size=3D2>San = Diego,=20

California        -- Public = Internet=20

access / Mailing Lists</FONT> <BR><FONT=20 =

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

----</FONT>=20

<BR><FONT size=3D2>To REMOVE yourself from this mailing list, send = an E-Mail=20