We are running several Oracle DBs (8.1.7) under Win2000 (all SPs applyed). 2 CPUs/2 GBt RAM.
And every server is periodically crashing with a nice "out of process memory when trying to allocate ???? bytes" error message. It looks like it is only a metter of time (from hours to days) before this happens.
SQL statements and stored procedures usually take 30+ minutes to execute, so the servers are very havily used. And are processing huge amounts of data.
The following is from init.ora file:
# MEMORY PARAMETERS
db_block_buffers = 93750
#orig shared_pool_size = 314368000
shared_pool_size = 204800000
large_pool_size = 76800000
log_buffer = 76800000
sort_area_size = 76800000
sort_area_retained_size = 76800000
#pre_page_sga = true
# BLOCK SIZE PARAMETER
db_block_size = 8192
java_pool_size = 6144000
Can anyone tell me what can be wrong with those memory settings for a 2 CPU/2 GBt RAM machine? If it is not the memory setting, than what can be the origin of the problem?
And, Mem Size is ~1.9G, VM Size is ~1.9 G before Oracle dyes