RE: ram used

Don't know how big is your total SGA/PGA and how many user sessions you have. Since you have set /3GB /PAE switches, the total memory for these items would be limited to 2.7GB. If you have set big size you could try to reduce SGA/PGA to reserve more process memory and get rid of ORA-04030 error.  

Lu    

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Eugene Pipko Sent: Monday, May 04, 2009 4:00 PM
To: 'oracle-l-freelists'
Subject: ram used  

Hi all,

I inherited 8.1.7.4 (was upgraded from 8.1.6.3) on Win2000 Adv. Server(was upgraded from NT).  

Physical RAM is 4Gb

db_block_size = 4096

sort_area_size = 6291456

sort_area_retained_size = 1048576

shared_pool_size = 419430400  

Getting ORA-04030: out of process memory when trying to allocate 709132 bytes (callheap,kllcqas:kllsltba).

How/where (besides windows task manager) can I lookup how much memory is being used at the time this error occurs?  

Thanks,  

Eugene Pipko

Seattle Pacific Industries

office: 253.872.5243

cell: 206.304.7726

P Please consider the environment before printing this e-mail.  

--
http://www.freelists.org/webpage/oracle-l