oracle 11g ora-04031 [message #534682] |
Thu, 08 December 2011 06:30 |
|
lerry_wu
Messages: 12 Registered: December 2011
|
Junior Member |
|
|
hello:
oracle 11g use AMM manage memory,but my db use manual manage memory,shared_pool 6G
I want to know what is KGLHD which occupy 3G
|
|
|
|
Re: oracle 11g ora-04031 [message #534684 is a reply to message #534682] |
Thu, 08 December 2011 07:11 |
|
Michel Cadot
Messages: 68729 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
ORA-04031: unable to allocate %s bytes of shared memory (\"%s\",\"%s\",\"%s\",\"%s\")
*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
INIT.ORA parameters "shared_pool_reserved_size" and
"shared_pool_size".
If the large pool is out of memory, increase the INIT.ORA
parameter "large_pool_size".
|
|
|
|
|