RE: Oracle Monitor

Hi Mitchell,

When you say "monitor", what exactly do you mean? The definition of a
"Monitoring" tool (in my eyes at least) is a tool that will sit and monitor
your database, and tell you when a problem could be, or is, imminent (via background processes and alerts).

The list that you specify, whilst all good tools, are not (exactly)
"monitors". Quest's Spotlight is more of a "diagnostics" tool, granted it
has a lot of "monitoring" features, but it is essentially a SQL*Net/Net 8 based client, that has to be open for "monitoring" to occur, and more to the point, you have to be looking at the screen to notice any "problems". Quests true "monitoring" tool is I/Watch (or Foglight, depending..).

PocketDBA, again, is not a monitor (we are Expand Beyond's UK distributor). It is more of a diagnostics tool aimed at the "mobile" market. It has no mechanism to get an alert or to you the DBA, though it DOES allow you to get to the bottom of problems very quickly, once you have received an alert however! ;)

I honestly couldn't comment on Oracle Performance Monitor, having not tried it.

There are other tools available on the market though. Here's a list of those that I would class as having "monitors":

Precise (www.precisesoft.com)
Quest (www.quest.com)
BMC (www.bmc.com)
Embarcadero (www.embarcardero.com) - I'm not entirely sure whether Performance Centre has alerting yet.
Bradmark (www.bradmark.com) and therefore (www.cool-tools.co.uk as well :D) Oracle (who needs a URL)

There are a number of others out there in the market, with tools such as
"Big Brother" (now taken over by Quest I think) "orasnap", "mamba" etc. .
The ones listed above however, are those that I would list as the market leaders.

<shameless plug>
We sell Bradmark's offering (NORAD) along with PocketDBA, to allow NORAD alerts to be sent to a mobile phone (as well as email, pager, SNMP_TRAPS etc.), and "actioned" straight away with PocketDBA. </shameless plug>

Remember, often the main driving force for monitors is to ease the DBAs work load, by giving the day to day monitoring tasks to a tool to handle. If you need to be watching a screen - this defeats the object! :)

HTH Mark

 Mark Leith             | T: +44 (0)1905 330 281
 Sales & Marketing      | F: +44 (0)870 127 5283
 Cool Tools UK Ltd      | E: mark_at_cool-tools.co.uk
===================================================
           http://www.cool-tools.co.uk
       Maximising throughput & performance

-----Original Message-----
Sent: 25 February 2003 15:49
To: Multiple recipients of list ORACLE-L

Hi DBAs

We are reviewing anything related to database monitor. The following is my aware. Is there anything else you recommend

Spotlight from quest

Pocket DBA from Expand Beyond

Oracle Performance Monitor

Thanks in advance.

Mitchell

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mitchell
  INET: mitchell.lee_at_rogers.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
-- 
Author: Mark Leith
  INET: mark_at_cool-tools.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).