RE: Reg: ORA-04030

HI Chuck,

 

Yes it's 32-bit Windows.

 

Regards,

Mamta

 

________________________________

From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Chuck Edwards
Sent: Wednesday, 25 February 2009 08:25
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: 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: