Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
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