oracle 11g ora-04031 [message #534682] |
Thu, 08 December 2011 06:30 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/cf015f608599a014ca027bbd8ea3b98c?s=64&d=mm&r=g) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68663 Registered: March 2007 Location: Nanterre, France, http://...
|
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".
|
|
|
|
|