Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database performance monitoring tool for developers.

RE: Database performance monitoring tool for developers.

From: Rachel Carmichael <>
Date: Wed, 16 Apr 2003 05:43:51 -0800
Message-ID: <>

Ah but see, I didn't say 'DBA privs'. Most of the tools can be used by an account that has select only on any of the v$ or dba_ views.

I also said "database aware". Which means they understand what the results mean.

And then there are things like....

the hosting company we use has reports on performance etc that authorized users can look at. Reports are on CPU, Webservers, page downloads and Oracle. Here's the sad part. There are 4 Oracle reports:

  1. Dictionary Cache Hits (ARGH!!!!!!!!!!!!!!!!!)
  2. Percentage of Current Processes (as in we have 30 processes attached and 300 processes configured in the init.ora)
  3. Sessions Waiting for Lock
  4. Total Sort Rate (rate of sorts per minute) on disk and in memory)

NONE of these are really useful, as they are reported on a daily basis.

The first we know is really useless, and one of these days I'm going to install a cron job to run Connor's BCHR script, just for giggles.

The percentage of current processes makes no sense to me, as we run with connection pooling.

Sessions waiting for Lock on a daily basis? I suppose it could be useful, if only to point me to an app to start tuning.

And what really worries me is that the Sort Rate report is the "most popular" (most viewed) of all of them. Not by me, I just learned about these reports yesterday.

I need to have a LONG talk with the hosting company.

Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
Please see the official ORACLE-L FAQ:
Author: Rachel Carmichael

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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).
Received on Wed Apr 16 2003 - 08:43:51 CDT

Original text of this message