cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle; out of memory

E. Vodegel
Occasional Advisor

Oracle; out of memory

Hi,

Our DBA has encountered the following error message:

IMP-00003: ORACLE error 4030 encountered
ORA-04030: out of process memory when trying to allocate 48 bytes
(callheap,temporary memory)

Next she typed the following command as Oracle:
ulimit -as and got the following output:
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 262144
stack(kbytes) 8192
memory(kbytes) unlimited
coredump(blocks) 4194303
nofiles(descriptors) 2048

The data and stack does she want to put to "unlimited".

Which kernel parameters do I have to change?

Many thankX,
Erwin




2 REPLIES
nancy rippey
Trusted Contributor

Re: Oracle; out of memory

The following thread should help.
It gives recommended kernel paramaters for oracle
http://forums.itrc.hp.com/cm/QuestionAnswer/1,11866,0x7acacf38d6bdd5118ff10090279cd0f9,00.html
nrip
Steven Gillard_2
Honored Contributor

Re: Oracle; out of memory

The kernel parameters to change are maxdsiz (for the data segment) and maxssiz (for the stack segment).

If you're running a 64bit version of Oracle then maxdsiz_64bit and maxssiz_64bit are the appropriate parameters. If this is the case I'd also check your swap space utilisation with swapinfo -atm, because the default maxdsiz_64bit is large (1Gig) and I'd be surprised if the Oracle server process was hitting that.

Regards,
Steve