RE: maturing monitoring scheme

Josh

   One idea for you to consider. Buy the book Oracle9i High-Performance Tuning with STATSPACK by Don Burleson. His book is chock full of ideas about overall database monitoring, regardless of whether you decide to use STATSPACK or not. As an example, he points out that the database sits atop a computer system and you can be deceived if you only look at the database. You must monitor the system itself and then review the Oracle statistics in light of what was going on with the system. He provides lots of ideas of what you can monitor on the system.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, September 24, 2003 9:50 AM To: Multiple recipients of list ORACLE-L

Some random thoughts, with examples
1) Tracks historical information to determine when a value is out of normal range or when a value has suddenly increased.

    ex. - SQL*Net messages consume 85-95% of wait time. If this value drops to
75% or rises to 99% alarm.

• AR_DATA tablespace is at 90%, but has been there for 180 days. 2) Offers insight into possible root causes. ex. - SQL*Net message count has not changed, but average wait time has increased 25%. Possible network latency problem.
• INVOICE_HEADER table has allocated 10 new extents in the past 5 days, which is 5000% above normal 3) Includes the latest proven optimization techniques ex. - Focuses on wait times and not ratios 4) Includes all events, even "idle" ones, so that the dba can decide what is and is not important.

Daniel

Josh Collier wrote:

> Greetings,
>
> What are the characteristics of a mature monitoring scheme? I am trying to
> tighten up the monitoring at my shop. What are the things and actions
which
> a mature monitoring scheme watches and does?
>
> thanks,
>
> Josh
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Josh Collier
> INET: Josh.Collier_at_Banfield.net
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).