Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-4031 on Startup, Large SGA, Large DB_BLOCK_BUFFERs

ORA-4031 on Startup, Large SGA, Large DB_BLOCK_BUFFERs

From: Michael Wilson <michael_at_ebay.com>
Date: Fri, 1 May 1998 22:28:51 -0700
Message-ID: <6ieb0q$ls8$1@its.hooked.net>


We're running into a problem increasing DB_BLOCK_BUFFERS from 120,000 to, well, anything (we'd like 300,000). During startup, we get the following message:

ORA-04031: unable to allocate 23259740 bytes of shared memory ("unknown object","sga heap","gc_*")

Things we've tried:

1)
2) Increase SHARED_AREA_SIZE to 50000000
3) Added swap space

SHMM* is set to:

set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=256
set shmsys:shminfo_shmmax=1610612736
set shmsys:shminfo_shmseg=128

The environment is Solaris 2.5.1, E4000, 4Gb of memory. Oracle version 7.3.2.2.0.

The odd thing is 4031 seems to refer to a get for memory AFTER the SGA is allocated, almost as if the increase in DB_BLOCK_BUFFERS is creating some huge object in the shared area (which I thought was for cursors, pl/sql, etc). Considering that we're in startup, and don't have ANY packages pinned, this is most curious.

Any thoughts here? We really need those buffers, and we've got memory to spare...

TIA. Received on Sat May 02 1998 - 00:28:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US