Xref: alice comp.databases.oracle.server:83066
Message-ID: <3898515A.2F6210B1@totalise.co.uk>
Date: Wed, 02 Feb 2000 15:46:34 +0000
From: Martin Hepworth <maxsec@totalise.co.uk>
X-Mailer: Mozilla 4.7 [en-gb] (WinNT; U)
X-Accept-Language: en,pdf
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
To: NetComrade <andreyNSPAM@bookexchange.net>
Subject: Re: Q Diagnostic vs. Instance Monitor
References: <38984bc8.2111427@news.earthlink.net>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: 2 Feb 2000 15:47:23 GMT, bisgw.blackwell.co.uk
Lines: 26
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!colt.net!newspeer.highwayone.net!news2lo.highwayone.net!bisgw.blackwell.co.uk

NetComrade wrote:
> 
> Well, so far I can only say one thing, although Instance Monitor looks
> cooler, it crashes on my Win98 machine all the time...
> 
> Anybody got any other ideas on which one to keep?
> 
> Thanx.
> ---------------
> In case I forgot to mention:
> We use Oracle 7.3.4 on Solaris 2.6, 2.7 boxes
> ---------------
> Andrey Dmitriev  eFax: (978) 383-5892  Daytime: (917) 750-3630
> AOL: NetComrade  ICQ: 11340726 remove NSPAM to email

For my money I'd go for Q (or Precise/SQL).

Instance monitor can't monitor your environment 24x7 as it reads the v$
tables and can overload your oracle RDBMS very easily - you have it use
it sparingly!

Q and Precise/SQL monitor the SGA directly. For the nice gui I'd favour
Q, but I haven't really had chance to eval Precise/SQL yet so it's hard
to judge.

Martin