Operating System - HP-UX
1748265 Members
3616 Online
108760 Solutions
New Discussion юеВ

Re: Oracle Error: ORA-04031

 
Wei_9
Occasional Advisor

Oracle Error: ORA-04031

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


7 REPLIES 7
Jean-Luc Oudart
Honored Contributor

Re: Oracle Error: ORA-04031

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
fiat lux
Francisco J. Soler
Honored Contributor

Re: Oracle Error: ORA-04031

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

Frank.
Linux?. Yes, of course.
Jean-Luc Oudart
Honored Contributor

Re: Oracle Error: ORA-04031

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
fiat lux
Sanjay Kumar Suri
Honored Contributor

Re: Oracle Error: ORA-04031

$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
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Nicolas Dumeige
Esteemed Contributor

Re: Oracle Error: ORA-04031

Nice stuff Jean-Luc
All different, all Unix
Surya Narayana
Occasional Advisor

Re: Oracle Error: ORA-04031

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.)
Printaporn_1
Esteemed Contributor

Re: Oracle Error: ORA-04031

also try pin large package into memory.
enjoy any little thing in my life