Re: Low hit ratio, but only for indexes

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Mon, 14 Jan 2002 12:05:22 GMT
Message-ID: <3c42c92c.1472055@news-vip.optusnet.com.au>

Andy doodled thusly:

>As you can see, all the values are great, apart from the INDEX figure
>which is terrible! Why is this, and how can I improve it?
>

I don't think the INDEX line means much on that one. never found a good explanation of why it never looks good. but it doesn't seem to matter much, so ignore it.

>The SHARED_POOL_SIZE is set to 600MB.
>

yaba-daba-doo, attaboy! what you running there? SAP?

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Mon Jan 14 2002 - 06:05:22 CST