- Oracle-Developer.com -

Navigation: Home  | Discussion Forums (Get expert advice)  |  Scripts  |  About Us  | Links  | Job Openings  
ORA-04031 unable to allocate string bytes of shared memory
Comment on this Topic


ORA-04031 unable to allocate string bytes of shared memory
("string","string","string","string")

Cause: More shared memory is needed than was allocated in the shared pool.

Action: If the shared pool is out of memory, 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 of the initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_
POOL_SIZE. If the large pool is out of memory, increase the initialization
parameter LARGE_POOL_SIZE.


Comment on ORA-04031 unable to allocate string bytes of shared memory

 

Owned and Operated by Varun Jain, Inc, an Oracle Consulting Firm

Copyright ©2007 Oracle-Developer.com