db_block_size is 8192 ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 1:48 PM
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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?utf-8?Q?shuan.tay\=28PCI=E9=84=AD=E7=A5=BA=E5=8B=9B\=29?= 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).
