1748169 Members
4132 Online
108758 Solutions
New Discussion юеВ

error message ora-04031

 
SOLVED
Go to solution
dngaya
Advisor

error message ora-04031

hello,
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")
gtaia31vd.cp_cvrg


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

5 REPLIES 5
Karthik S S
Honored Contributor

Re: error message ora-04031

Hi,

Try this link,

http://www.cryer.co.uk/brian/oracle/ORA04031.htm

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.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=146599.1
Remember, wherever you go, there you are...
Jean-Luc Oudart
Honored Contributor
Solution

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.

Regards,
Jean-Luc
fiat lux
Jim Elke
New Member

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 8.1.7.4, and especially prior to 8.1.7.2. We've worked around the problem by resizing shared pool until we get a chance to patch up to 8.1.7.4.
Yogeeraj_1
Honored Contributor

Re: error message ora-04031

hi,

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

Your package is most probably not doing so...

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