topic Re: Oracle Error: ORA-04031 in Operating System - HP-UX

Oracle Error: ORA-04031

Wei_9 — Thu, 08 Apr 2004 02:52:01 GMT

Our application got an Oracle error message
ORA-04031.

Any suggestion about it?

OS: HP-UX11.0

Oracle: 9.2.0

App: Tuxedo 7.0

Re: Oracle Error: ORA-04031

Jean-Luc Oudart — Thu, 08 Apr 2004 03:00:26 GMT

Hi,

not so long ago I replied to similar message.
Anyway, this is to do with the shared pool.
Either too small or too fragmented, or ... both !

cf. attachment

regards,
Jean-Luc

Re: Oracle Error: ORA-04031

Francisco J. Soler — Thu, 08 Apr 2004 03:00:42 GMT

Hi,
Check this url:
http://www.cryer.co.uk/brian/oracle/ORA04031.htm

Frank.

Re: Oracle Error: ORA-04031

Jean-Luc Oudart — Thu, 08 Apr 2004 03:02:05 GMT

I also have a SQL script you can/should run regularly to check how much free space you have left in the shared pool.

SQL script : attachment

Regards,
Jean-Luc

Re: Oracle Error: ORA-04031

Sanjay Kumar Suri — Thu, 08 Apr 2004 03:45:49 GMT

$oerr ora 4031 has following output:

04031, 00000, "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 theINIT.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".

sks

Re: Oracle Error: ORA-04031

Nicolas Dumeige — Thu, 08 Apr 2004 03:49:30 GMT

Nice stuff Jean-Luc

Re: Oracle Error: ORA-04031

Surya Narayana — Fri, 09 Apr 2004 11:05:13 GMT

There have been previous posts on this from others with similar problems. Two other
areas to check are: Memory and swap space usage (swapinfo -tam) and modify Oracle's allocation of memory (look up the command chatr.)

Re: Oracle Error: ORA-04031

Printaporn_1 — Sat, 10 Apr 2004 08:49:48 GMT

also try pin large package into memory.