TOAD server Statistics - how to interpret?

From: Øystein Ørnegård <Oystein.Ornegaard_at_fa.uib.no>
Date: Mon, 27 Sep 1999 09:52:13 +0200
Message-ID: <37EF222D.C653948B@fa.uib.no>

I have installed TOAD (Tool for Oracle Application Developers) and I have just started using it when I run accross Server Statistics tool and find two warningsigns (red dots):

library cache pin hit ratio value = 8485,26 (shared pool area too small)
chained fetch ratio value = 0,2765 (PCTFREE too low for a table)
what is the impact of this or what impacts can it have?
how can the problems be corrected?

I am not in charge of the database - I am just trying to learn.

I am very thankful for any response to these questions!

Oystein, Norway Received on Mon Sep 27 1999 - 02:52:13 CDT