ORA-04030: out of process memory

From: Jesus <jesus_angel_g_at_hotmail.com>
Date: 22 Jul 2002 01:25:03 -0700
Message-ID: <a0ff9777.0207220025.52bd98dc@posting.google.com>

Hi,

We have a Data Mart data base, including tables of 1,4,13 and 14 millions of rows. When we try to execute one query which need data from all these four tables (all of then linked), we received the error:

ORA-04030: out of process memory when trying to allocate 1040896 bytes (cursor work he,kllcqas:kllsltba) :-4030

Althought we are not experienced DBA, we had tried increase the Db_block_buffers and Shared_pool_size, but we don't achieve any improvement.

We are working with Oracle 8.1.6 over Unixware 7.1.1. Our principal Oracle parameters are:

db_block_buffers = 64200

shared_pool_size = 150000000

parallel_min_servers = 2
parallel_max_servers = 28

large_pool_size = 66144000
log_checkpoint_interval = 10000
log_checkpoint_timeout = 0

processes = 150

log_buffer = 256000

db_block_size = 8192

sort_area_size = 100000000
sort_area_retained_size = 100000000

Thank you in advance for your help.

Jesus. Received on Mon Jul 22 2002 - 03:25:03 CDT