Re: buffer hit cache ratio should be ...

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 29 Dec 2003 07:51:30 -0800
Message-ID: <1efdad5b.0312290751.6b6210a@posting.google.com>

pharfromhome_at_hotmail.com (Geomancer) wrote in message news:<cf90fb89.0312241840.741e52a3_at_posting.google.com>...
> > DBAs should promote continous monitoring to fix the problems before
> > they surface to user community instead of sitting back, waiting the
> > time users start screaming around about the performance...
>
> Yes! And STATSPACK is the best way to monitor trends over time.

statspack can be problematic, because its aggregate data. Its useful, but can be misleading.

go to www.hotsos.com and read carrie milsaps article called 'operational timing data'. Received on Mon Dec 29 2003 - 09:51:30 CST