First what's the db_block_size ?
Anyway try to increase db_block_buffers = 5000
- shuan.tay\(PCI¾G¸R³Ô\) <shuan.tay_at_pci.co.id>
wrote:
> 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!
>
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: ASHRAF SALAYMEH
INET: ashraf_salaymeh_at_yahoo.com
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 - 23:48:44 CST
