Preventative Maintenence for Oracle Servers

I am implementing the Preventative Maintenence procedures for an Oracle 7.3.4 database on NT. We are currently running scripts by hand that check on the health of certain aspects of the system. I am looking for input on what should be looked at, what trends should be monitored, and what people are doing to integrate events into alerts (email, pager, etc.).

Currently, our manual script is tracking the following:

SGA

• buffer hit ratio
• redo log buffer requests
• dictionary cache hit ratio
• shared sql pool hit ratio

Tablespace Analysis (by datafile)

• total bytes
• %used

Table and Index Fragmentation (# extents).

• total # bytes used
• # extents used by the object.
• segment fragmentation

Rollback Segments

• extents
• wraps
• extensions

We plan on tracking trends, and automating the PM process to provide better reporting and predicting. We also want to provide hooks into alert systems that send email/page/etc when thresholds are achieved.

Thanks for any input on this subect!

Jon.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Aug 24 1998 - 17:14:24 CDT