Reg: ORA-04030

From: "NEELI-SC, Mamta" <Mamta.NEELI@xxxxxxxxxxxxxx>
To: <ora-apps-dba@xxxxxxxxxxxxx>
Date: Wed, 25 Feb 2009 08:22:27 +0800

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

Follow-Ups:

Re: Reg: ORA-04030
From: Chuck Edwards

Reg: ORA-04030

Other related posts: