Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

error message ora-04031

Go to solution

error message ora-04031

I have an application installed on a basis oracle 8.1.7 on HP 11.
when the users launch some requests, they receive the follow error message :
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","unknown object","library cache","oacdef info")

how can I make for resolve this problem so that it does not occur more ?.
thank you for your assistance.

Karthik S S
Honored Contributor

Re: error message ora-04031


Try this link,

If you have a metalink account that is the best place to look for more info.

-Karthik S S
For a list of all the ways technology has failed to improve the quality of life, please press three. - Alice Kahn
James A. Donovan
Honored Contributor

Re: error message ora-04031

ORA-04031 error is indicitive of problems (shortage/fragmentation) in your shared pool

Here is a Metalink link to a step-by-step procedure on resolving ORA-04031 errors.
Remember, wherever you go, there you are...
Jean-Luc Oudart
Honored Contributor

Re: error message ora-04031

Got the pb a while ago and had to increase the size of our shared pool.

Find attached a SQL script pool_estimate , this will give hints on used space.

fiat lux
Jim Elke
Occasional Visitor

Re: error message ora-04031

Are seeing this currently on one db we support. Issue can be legitimate shared pool being sized too small, but in our case due to an Oracle bug which the shared pool "miscellaneous" bucket (see v$sgastat) is continually growing. There are many Oracle shared pool bugs in 8.1.7.x levels prior to, and especially prior to We've worked around the problem by resizing shared pool until we get a chance to patch up to
Honored Contributor

Re: error message ora-04031


to avoid 4031's -- you must use bind variables

Your package is most probably not doing so...

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)