What parameters to adjust?

From: Chan Siu Ming <csm_tec_at_softhome.net>
Date: Sat, 3 Jun 2000 09:36:21 +0800
Message-Id: <10516.107631@fatcity.com>

Hi gurus,

What initorcl.ora parameters and values should I adjust when the TOAD Server Statistics shows the ff warnings?

Statistics                        Values                Comments
----------                        ------                --------
Buffer Cache Hit Ratio            88.6253               May need to increase
DB_BLOCK_BUFFERS
Library Cache Get Hit Ratio       83.4003               Dynamic or
Unsharable SQL?
Chained Fetch Ratio               0.2663                PCTFREE too low for
a table
Parse to Execute Ratio            22.3359               High Parse to

Execute Ratio

Thank you very much for any answers. Received on Fri Jun 02 2000 - 20:36:21 CDT