RE: ram used
- From: "Jiang, Lu" <Lu.Jiang@xxxxxxxxxxxx>
- To: eugene.pipko@xxxxxxxxxxxx, "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 5 May 2009 16:26:56 -0400
Eugene,
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
Other related posts:
