Simple SGA help

OK, so I have a new utility to monitor overall SGA usage. Breaks it down to show statistics on the major components.

Nothing that unusual, but, I notice that 'Buffer Cache Hit Ratio' is low from my perspective (78.56%). 'Library Cache Hit Ratio' is running at 97.54%, while 'Data Dictionary Cache Hit' is running at 96.11%. I would like to increase 'Buffer Cache Hit Ratio' to about 93-95% but am unsure which SGA parameter I need to increase.

Thanks for your assistance. Received on Mon Jan 15 2001 - 08:00:39 CST