topic Re: error message ora-04031 in Operating System - HP-UX

error message ora-04031

dngaya — Tue, 02 Dec 2003 11:25:03 GMT

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.

Re: error message ora-04031

Karthik S S — Tue, 02 Dec 2003 11:33:19 GMT

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

Re: error message ora-04031

James A. Donovan — Tue, 02 Dec 2003 11:41:50 GMT

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

Re: error message ora-04031

Jean-Luc Oudart — Tue, 02 Dec 2003 14:00:45 GMT

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

Re: error message ora-04031

Jim Elke — Tue, 02 Dec 2003 15:27:49 GMT

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.

Re: error message ora-04031

Yogeeraj_1 — Tue, 02 Dec 2003 23:10:32 GMT

hi,

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

Your package is most probably not doing so...

regards
Yogeeraj