RE: Opinions on Performance Tuning Software

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Wed, 24 Jan 2001 19:18:36 -0000
Message-Id: <10751.127399@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0008_01C0863A.739873D0 Content-Type: text/plain;

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

RE: Opinions on Performance Tuning SoftwareDoes it have to be one of the two? :) Take a look at the NORAD range of tools from Bradmark (Cool Tools is a distributor in the UK). The management tool that we have, DBControl, is easy to use, set up and maintain. Intuitive and all the other sales buzz words you can think of. They have just released a new version which is 8i compatible, and deals with LMTs, IOTs, Bitmapped indexes etc. They have added in partition management aswell.. Trend analysis, reorgs, blah blah blah...

Having used DBControl against OEM, I personally feel that DBControl wins hands down, as do most people (85-90%). I can't speak about Savant Diagnostics though as I haven't had a chance to play with that one as yet. Anyone got a web address, and can you download from the web?

If you are also looking at performance monitoring tools, we have another module called Norad Surveillance. Again, just been updated, now works on SQLServer as well as Oracle and Sybase. Also now 8i compatible (and runs on LINUX). Read more at Bradmark's site if you wish www.bradmark.com

Regards

Mark

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Natasha Batson Sent: Wednesday, January 24, 2001 05:06
To: Multiple recipients of list ORACLE-L Subject: 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?

------=_NextPart_000_0008_01C0863A.739873D0 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>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D174480719-24012001>Does=20
it have to be one of the two? :) Take a look at the NORAD range of = tools=20
from Bradmark (Cool Tools is a distributor in the UK). The management = tool that=20
we have, DBControl, is easy to use, set up and maintain. Intuitive and = all the=20
other sales buzz words you can think of. They have just released a new = version=20
which is 8i compatible, and deals with LMTs, IOTs, Bitmapped indexes = etc. They=20
have added in partition management aswell.. Trend analysis, reorgs, blah = blah=20
blah...</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D174480719-24012001></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D174480719-24012001>Having=20
used DBControl against OEM, I personally feel that DBControl wins hands = down, as=20
do most people (85-90%). I can't speak about Savant Diagnostics though = as I=20
haven't had a chance to play with that one as yet. Anyone got a web = address, and=20
can you download from the web? </SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D174480719-24012001></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D174480719-24012001>If you=20
are also looking at performance monitoring tools, we have another module = called=20
Norad Surveillance. Again, just been updated, now works on SQLServer as = well as=20
Oracle and Sybase. Also now 8i compatible (and runs on LINUX).=20
</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D174480719-24012001></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =
class=3D174480719-24012001>Read=20
more at Bradmark's site if you wish <FONT color=3D#0000ff face=3DArial = size=3D2><SPAN=20
class=3D174480719-24012001><A =
href=3D"http://www.bradmark.com">www.bradmark.com</A>=20
</SPAN></FONT></SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D174480719-24012001></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D174480719-24012001>Regards</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D174480719-24012001></SPAN></FONT> </DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D174480719-24012001>Mark</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN=20
class=3D174480719-24012001></SPAN></FONT> </DIV>
<DIV><FONT face=3DTahoma><BR></FONT> </DIV>
<DIV><FONT face=3DTahoma><FONT size=3D2><SPAN=20
class=3D174480719-24012001> </SPAN>-----Original = Message-----<BR><B>From:</B>=20
root_at_fatcity.com [mailto:root_at_fatcity.com]<B>On Behalf Of </B>Natasha=20 Batson<BR><B>Sent:</B> Wednesday, January 24, 2001 05:06<BR><B>To:</B> = Multiple=20
recipients of list ORACLE-L<BR><B>Subject:</B> Re: Opinions on = Performance=20
Tuning Software<BR><BR></DIV></FONT>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px"></FONT>
  <DIV><FONT face=3DArial size=3D2></FONT> </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=20
  to 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 = Received on Wed Jan 24 2001 - 13:18:36 CST