Re: maturing monitoring scheme

2003-09-24 Thread Daniel Fink
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

RE: maturing monitoring scheme

2003-09-24 Thread DENNIS WILLIAMS
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