Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-4031 on Startup, Large SGA, Large DB_BLOCK_BUFFERs
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