Home » RDBMS Server » Server Administration » oracle 11g ora-04031 (oracle 11.2.0.2 aix)
oracle 11g ora-04031 [message #534682] Thu, 08 December 2011 06:30 Go to next message
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 #534683 is a reply to message #534682] Thu, 08 December 2011 06:56 Go to previous messageGo to next message
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
Senior Member
Library cache. What query are you running?
Re: oracle 11g ora-04031 [message #534684 is a reply to message #534682] Thu, 08 December 2011 07:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
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".

Re: oracle 11g ora-04031 [message #534699 is a reply to message #534684] Thu, 08 December 2011 09:09 Go to previous messageGo to next message
lerry_wu
Messages: 12
Registered: December 2011
Junior Member
hi Michel:
I have modify shared_pool_reserved_size=900M,and when I query v$shared_pool_reserved, failure_requese>0 and LAST_FAILURE_SIZE < SHARED_POOL_RESERVED_MIN_ALLOC
Re: oracle 11g ora-04031 [message #534701 is a reply to message #534699] Thu, 08 December 2011 09:11 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Oracle is too dumb to lie.
Believe the error messages!
Previous Topic: Tablespace info
Next Topic: How to reset the parameter value?
Goto Forum:
  


Current Time: Fri Apr 19 02:02:37 CDT 2024