ram used

From: Eugene Pipko <eugene.pipko_at_unionbay.com>
Date: Mon, 4 May 2009 13:00:26 -0700
Message-ID: <34DB87F47199374280ADFD2968CDBCFA87D621FD56_at_MAIL01KT.seattlepacificindustries.com>

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

Received on Mon May 04 2009 - 15:00:26 CDT