Re: Reg: ORA-04030

Is this 32-bit Windows?


On Feb 24, 2009, at 4:22 PM, NEELI-SC, Mamta wrote:


Hello DBA’s
I’m receiving ORA -04030: out of process memory when trying to allocate 8176 bytes. 

I have 64 GB of RAM.
Mine is 11.5.9 on windows 2003 server. Is this happening due to hitting OS limit? 

Please find the below query output in the attachment.

select
   sid,name,value
from
   v$statname n,v$sesstat s
where
   n.STATISTIC# = s.STATISTIC# and
   name like 'session%memory%'
order by 3 asc;

Please suggest me what could be issues and the things to be checked.

Regards
Mamta
<memory issue 240209.xls>




_____________________________

Chuck Edwards
Blue Gecko, Inc
http://www.bluegecko.net

chuck@xxxxxxxxxxxxx
office: (206) 508-4760
mobile: (206) 661-1328

Other related posts: