First what's the db_block_size ? Anyway try to increase db_block_buffers = 5000
--- shuan.tay\(PCI�G�R��\) <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
