Shared Pool Size

From: shuan.tay\(PCI¾G¸R³Ô\) <shuan.tay_at_pci.co.id>
Date: Sun, 01 Dec 2002 16:34:10 -0800
Message-ID: <F001.0050F999.20021201163410@fatcity.com>

Dear all DBAs,

My Oracle 8.0.5(running on Linux 6.4 kernel 2.2.14) is getting slower recently. Every data input output is slow.

And the "Server Stat" in Toad showing:
Library Cache Get Hit Ratio 51.5540 "May need to increase DB_BLOCK_BUFFERS" Library Cache Pin Hit Ratio 93.6161 "Shared Pool area too small"

Is that means i should increase the size of shared pool and DB_BLOCK_BUFFERS? the values in init.ora:

db_block_buffers = 550
shared_pool_size = 19000000

Thanks for helps!

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: =?big5?B?c2h1YW4udGF5XChQQ0m+R7hSs9RcKQ==?=   INET: shuan.tay_at_pci.co.id

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sun Dec 01 2002 - 18:34:10 CST