Re: Oracle performance monitoring

You might look in ORACLE_HOME/rdbms/admin for the 2 routines utlbstat.sql and utlestat.sql. The SQLDBA facility (tool) also has some features for monitoring. The best part of these is the 'free' price. They come with Oracle.

This may not be exactly what you are looking for but it will be worthwhile to look.

Chuck

Tim Jebb (jebb_t_r_at_bt-web.bt.co.uk) wrote:
: Hi,
:
: I am looking for a product or Oracle facility which I am not sure exists.
: I need to be able to monitor the performance of a database (not of a
: single session). I need information about overall response time, i/o,
: loading, etc. I need to be able to interrogate the monitor
: programmatically while it is running. Ideally I would be able to start,
: stop and configure the monitor dynamically.
:
: Does anyone know of such beasts, if so what are they and where can I get
: them?
:
: Thanks
:
: Tim Jebb
:
Received on Wed Dec 13 1995 - 00:00:00 CET