ORA-04031: Unable to Allocate %n Bytes of Shared Memory ("shared pool",%s,%s,%s)

Subject:	ORA-04031: Unable to Allocate %n Bytes of Shared Memory ("shared pool",%s,%s,%s)
	Doc ID:	Note:161810.1	Type:	TROUBLESHOOTING
	Last Revision Date:	05-JUL-2004	Status:	PUBLISHED

·         fact: Oracle Server - Enterprise Edition

·          

·         symptom: ORA-04031: unable to allocate %s bytes of shared memory (\"%

·         s\",\"%s\",\"%s\",\"%s\")

·          

·         cause: New object can not be loaded into shared pool. Shared pool is either 

·         too small or too fragmented or both.

·          

·          

fix:

Try to increase shared_pool_size in init.ora file. If it seems large enough 

then  improve segmentation in shared pool by reserving part of shared pool for 

large objects using parameter SHARED_POOL_RESERVED_SIZE (good value to start 

tuning is 1/3 of shared-pool size). It is possible to decide what is "

large object" by parameter SHARED_POOL_RESERVED_MIN_ALLOC.

Reference:

Note 62143.1