Re: Preventative Maintenence for Oracle Servers

Oracle Enterprise Manager with Performance and Expert Package is a great GUI tool to accomplish the followings.
Shouping Qian

nordby_at_channelpoint.com wrote:
: 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 Fri Aug 28 1998 - 16:04:35 CDT