Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Diagnosing causes to ORA-4031
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.
Received on Fri Sep 07 2001 - 01:23:14 CDT