Re: Interpreting statistics

From: Winnie Liu <poohland_at_hotmail.com>
Date: Mon, 6 Jul 1998 21:16:28 -0700
Message-ID: <6ns772$f1e@sjx-ixn2.ix.netcom.com>

you may want to check for the hit ratio (for db buffer, all the latches, rollback segment, Shared pool area) to be in the 90s. The hit ratio is the ratio of misses/gets. Try to look for the statistics for all those 'waits' too. If wait is high and the hit ratio is low, you may want to increase the corresponding elements.

umm.. if you have some specific perfomance issue to look for (like db buffers or something), you can email me directly to see if I can help you to figure that out.

Winnie

Vaughan Mc Carthy wrote in message <6nfibl$2db$1_at_hermes.is.co.za>...
>Hi there
>Does anybody have information on how to interpret the statistics generated
>by running utilities like bstat and snap7nap, etc. There are a lot of
>statistics generated by running these tools, but almost nothing is said
>about interpreting these statistics and how to rectify problems after you
>have interpreted them.
>Thanks a lot.
>Vaughan Mc Carthy
>
>
Received on Mon Jul 06 1998 - 23:16:28 CDT