ORACLE MONITOR
PRESENTATION
( last change 02/10/2001 )

 
 oracle + unix + cron + perl + ftp + web 
=
An Oracle performance/tuning Monitor
(( All for free! ))
(( Once you've spent millions ))
(( on hardware and software! ))
feedback: holg@earthlink.net View the Monitor Home Page

This monitor is set up to be a DBA tool, but the same mechanism
could be used as part of any application.

The idea is this:
Benefits:

Lets define some conventions (though arbitrary) to focus on tunning/performance issues.

How much "work" is a database doing?

We will define "work" as how much physical reading and writing is done on the database.

How "efficient" is the database in operation?

We will define "efficient" as how much activity is taking place in memory (cashe hit ratios). Also we can add large full table scans and disk vrs memory sorts.

How "healthy" is the database.

We will define "healthy" as the databases use of physical space, or basically extent allocation factors. Also index "dead" space.

Topics:
.