Re: Shared Pool Size

From: shuan.tay\(PCI鄭祺勛\) <shuan.tay_at_pci.co.id>
Date: Sun, 01 Dec 2002 23:28:39 -0800
Message-ID: <F001.0050FA50.20021201232839@fatcity.com>

db_block_size is 8192

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> 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³Ô\) <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).

-- 
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: 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 Mon Dec 02 2002 - 01:28:39 CST