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.
[EMAIL PROTECTED]
-----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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
