Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Out of process memory when trying to allocate

SOLVED
Go to solution
Steve Andrews_6
Frequent Advisor

Out of process memory when trying to allocate

We received the following message on and HP system running 11.24 It2:
Alert
The following errors are in the ALERT file : ORA-04030: out of process memory when trying to allocate 4032 bytes (ioc_make_sub2,ioc_allocate_pal) ORA-04030: out of process memory when trying to allocate 40984 bytes (koh-kghu call ,pefduralc).

My question is, could the be a shmmax issue or more related to swap size too low?
In God We Trust
7 REPLIES
Jeff Schussele
Honored Contributor
Solution

Re: Out of process memory when trying to allocate

Hi Steve,

IF you're not getting any OS generated error messages then I'd say it's probably an Oracle configuration issue - probably a defined value in the SGA needs to be increased. Now this *may* require a bump in shmmax but just have the DBA tell you what the total SGA value is & make sure shmmax meets or exceeds it.

HTH,
Jeff
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
harry d brown jr
Honored Contributor

Re: Out of process memory when trying to allocate

http://ora-04030.ora-code.com/



What does

uname -a

return?


live free or die
harry d brown jr
Live Free or Die
Peter Godron
Honored Contributor

Re: Out of process memory when trying to allocate

Eric Antunes
Honored Contributor

Re: Out of process memory when trying to allocate

Hi,

This is normally due to shared_pool parameters. Please post the following query results:

select name, value
from v$parameter
where name like '%shared_pool%'

select (1-(sum(getmisses)/sum(gets))) * 100 "Hit Ratio > 95%"
from v$rowcache;

select round(100 * sum(reloads) / sum(pins), 2) "Reloads Pct < 1"
from v$librarycache
having sum(pins) > 1000

select round(100 * sum(getmisses) / sum(gets), 2) "Misses Pct < 5"
from v$rowcache
having sum(gets) > 1000

select name, bytes/1024/1024 "Free Size in MB"
from v$sgastat
where name='free memory';

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
Eric Antunes
Honored Contributor

Re: Out of process memory when trying to allocate

Steve,

Any feedback??

Eric Antunes
Each and every day is a good day to learn.
Jean-Luc Oudart
Honored Contributor

Re: Out of process memory when trying to allocate

Hi Steve,

could I suggest you read this Metalink note 233869.1 : Diagnosing and Resolving ORA-4030 errors

Regards
Jean-Luc
fiat lux
Fred Ruffet
Honored Contributor

Re: Out of process memory when trying to allocate

Maybe SGA is sized over system limits. Look if Oracle's memory isn't configured larger than system can provide (ulimit / shmmax / physical memory)

Regards,

Fred
--

"Reality is just a point of view." (P. K. D.)