Home -> Usenet -> comp.databases.oracle -> Re: Shared memory problem on Oracle 7.2.3

Re: Shared memory problem on Oracle 7.2.3

From: Andre Vergison <avergison_at_infosoft.be>
Date: 1996/01/06
Message-ID: <4cltg4$hdr_at_news.Belgium.EU.net>#1/1 







Oracle Server 7.2 Messages manual says :



quote 



ORA-04031	unable to allocate num bytes of shared memory num, num, 
num 



 Cause:	More shared memory is needed than was allocated in the operating 
system process. SGA private memory has been exhausted



 Action:	Either use the DBMS_SHARED_POOL package to pin large 
packages, reduce your use of shared memory, or increase the amount of 
available shared  memory by increasing the value set for the 
SHARED_POOL_SIZE initialization parameter.



unquote



I just got a reply from Sridhar Subramaniam <avion_at_ozemail.com.au> 
concerning pinning packages. ("Keeping stored procedures in the shared 
pool ?" in this newsgroup)


Sridhar mentions the ora-4031 as well.



Good luck.
Received on Sat Jan 06 1996 - 00:00:00 CET












Original text of this message