RE: Remote Oracle monitoring

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Wed, 22 Nov 2000 10:48:41 -0000
Message-Id: <10688.122710@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_001B_01C05471.C75ECB90 Content-Type: text/plain;

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

There a few other options that I know of -

BMC's Patrol - www.bmc.com Look for the Oracle Knowledge Module or they now have Web DBA? An HTML based tool..
DBGeneral - www.bradmark.com Look for the Enterprise Monitoring Module, now rebadging under the name NORAD!
Platinum/CA have one but the name slips my coffee deprived mind - www.ca.com

If you have the cash, my bet would be on Precise. As mentioned in the previous post, this tool doesn't fire SQL to the database to collect it's statistics, therefore has no actual impact on the Oracle instance. They have managed to map the memory structure of the SGA to collect statistics that way. This then means they can collect stats on a sub second interval. They can also collect these stats for a playback to diagnose a performance problem say - yesterday at 2:00pm. Of course there is an overhead on the system, but even that is minimal I believe. As I said though it can be quite costly.

With all of these tools though, they all have slightly different functionalities. If you could share a little more about your monitoring needs - What you would like to gain from a tool - as in alerting, corrective actions, monitoring system stats, Oracle events that you monitor already that may be implemented in to a tool etc. I can try to give a bit more input into what the tools can provide.

HTH Mark

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Allan Nelson Sent: Wednesday, November 22, 2000 12:30 To: Multiple recipients of list ORACLE-L Subject: Re: Remote Oracle monitoring

Precise, OEMed through EMC is the only monitoring process integrated with the SYMAPI which is the only thing that allows you to see exactly what is going on in the EMC array. Precise also gets its stats by reading the SGA rather than by executing SQL which means you can sample at a higher rate without affecting the statistics you are trying to measure.

Allan

Original Message ----- From: Don Dealy II To: Multiple recipients of list ORACLE-L Sent: Monday, November 20, 2000 11:00 PM Subject: Remote Oracle monitoring

We are looking at Precise (Pulse) and Quest (I/Watch) as remote monitoring clients for Oracle db.

Any thoughts or experiences with either product, or a product that we may not have looked at, other than OEM v2?

------=_NextPart_000_001B_01C05471.C75ECB90 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>
<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 style=3D"FONT-FAMILY: Arial" text=3D#000000>
<DIV><FONT size=3D2><SPAN class=3D758541310-22112000>There a few other =
options that=20
I know of - </SPAN></FONT></DIV>
<DIV><FONT size=3D2><SPAN =

class=3D758541310-22112000></SPAN></FONT> </DIV>
<DIV><FONT size=3D2><SPAN class=3D758541310-22112000>BMC's Patrol =
-  <A=20
href=3D"http://www.bmc.com">www.bmc.com</A> Look for the Oracle = Knowledge Module=20

or they now have Web DBA? An HTML based tool..</SPAN></FONT></DIV>

<DIV><FONT size=3D2><SPAN class=3D758541310-22112000>DBGeneral - <A=20
href=3D"http://www.bradmark.com">www.bradmark.com</A> Look for the = Enterprise=20
Monitoring Module, now rebadging under the name = NORAD!</SPAN></FONT></DIV>
<DIV><FONT size=3D2><SPAN class=3D758541310-22112000>Platinum/CA have =
one but the=20
name slips my coffee deprived mind - <A=20 href=3D"http://www.ca.com">www.ca.com</A></SPAN></FONT></DIV>
<DIV><FONT size=3D2><SPAN =

class=3D758541310-22112000></SPAN></FONT> </DIV>
<DIV><FONT size=3D2><SPAN class=3D758541310-22112000>If you have the =
cash, my bet=20
would be on Precise. As mentioned in the previous post, this tool = doesn't fire=20
SQL to the database to collect it's statistics, therefore has no actual = impact=20
on the Oracle instance. They have managed to map the memory structure of = the SGA=20
to collect statistics that way. This then means they can collect stats = on a sub=20
second interval. They can also collect these stats for a playback to = diagnose a=20
performance problem say - yesterday at 2:00pm.  Of course = there=20
is an overhead on the system, but even that is minimal I believe. As I = said=20
though it can be quite costly. </SPAN></FONT></DIV>
<DIV><FONT size=3D2><SPAN =

class=3D758541310-22112000></SPAN></FONT> </DIV>
<DIV><FONT size=3D2><SPAN class=3D758541310-22112000>With all of these =
tools though,=20
they all have slightly different functionalities. If you could share a = little=20
more about your monitoring needs - What you would like to gain from a = tool - as=20
in alerting, corrective actions, monitoring system stats, Oracle events = that you=20
monitor already that may be implemented in to a tool etc. I can try to = give a=20
bit more input into what the tools can provide. </SPAN></FONT></DIV>
<DIV><FONT size=3D2><SPAN =

class=3D758541310-22112000></SPAN></FONT> </DIV>
<DIV><FONT size=3D2><SPAN =

class=3D758541310-22112000>HTH</SPAN></FONT></DIV>
<DIV><FONT size=3D2><SPAN =

class=3D758541310-22112000></SPAN></FONT> </DIV>
<DIV><FONT size=3D2><SPAN =

class=3D758541310-22112000>Mark</SPAN></FONT><FONT=20 size=3D2><SPAN class=3D758541310-22112000></SPAN></FONT></DIV>
<DIV><FONT size=3D2><SPAN =

class=3D758541310-22112000></SPAN></FONT> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
  <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20   [mailto:root_at_fatcity.com]<B>On Behalf Of </B>Allan = Nelson<BR><B>Sent:</B>=20
  Wednesday, November 22, 2000 12:30<BR><B>To:</B> Multiple recipients = of list=20
  ORACLE-L<BR><B>Subject:</B> Re: Remote Oracle = monitoring<BR><BR></DIV></FONT>
  <DIV><FONT size=3D2>Precise, OEMed through EMC is the only monitoring = process=20
  integrated with the SYMAPI which is the only thing that allows you to = see=20
  exactly what is going on in the EMC array.  Precise also gets its = stats=20
  by reading the SGA rather than by executing SQL which means you can = sample at=20
  a higher rate without affecting the statistics you are trying to=20   measure.</FONT></DIV>

  <DIV><FONT size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT size=3D2>Allan</FONT></DIV>
  <BLOCKQUOTE dir=3Dltr=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; = MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-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 href=3D"mailto:dondealy_at_teleport.com" = title=3Ddondealy_at_teleport.com>Don Dealy=20

II</A> </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20 href=3D"mailto:ORACLE-L_at_fatcity.com" = title=3DORACLE-L_at_fatcity.com>Multiple=20

recipients of list ORACLE-L</A> </DIV> <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Monday, November 20, = 2000 11:00=20

PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Remote Oracle = monitoring</DIV>

<DIV><BR></DIV>
<DIV><FONT size=3D2>We are looking at Precise (Pulse) and Quest = (I/Watch) as=20

remote monitoring clients for Oracle db.</FONT></DIV> <DIV> </DIV>
<DIV><FONT size=3D2>Any thoughts or experiences with either product, = or a=20

product that we may not have looked at, other than OEM v2? =20 </FONT></DIV>
<DIV> </DIV> Received on Wed Nov 22 2000 - 04:48:41 CST