Re: maturing monitoring scheme

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: Daniel Fink
  INET: Daniel.Fink_at_Sun.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).



text/x-vcard attachment: Card for Daniel Fink