out of process memory

From: Marco Hernandez <mpadilla_at_my-deja.com>
Date: Thu, 14 Oct 1999 13:51:33 GMT
Message-ID: <7u4n4u$jv1$1@nnrp1.deja.com>

We have 2 oracle servers in a replication environment.When the jobs wake up and try to work we get this message:

ORA-12012: error on auto execute of job 494
ORA-12008: error in snapshot refresh path
ORA-04030: out of process memory when trying to allocate 52368 bytes

(pga heap,k
sm stack)

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 386
ORA-06512: at "SYS.DBMS_IREFRESH", line 450
ORA-06512: at "SYS.DBMS_REFRESH", line 182

They are in 2 HP-UX 10.20 OS.
init.ora:
log_buffer = 256000
sort_area_size = 512000
db_block_buffers = 5000
shared_pool_size = 30000000
open_cursors = 2000
...
job_queue_processes = 1
job_queue_interval = 4
#job_queue_keep_connections = TRUE
#distributed_lock_timeout = 500
#distributed_transactions = 5

global_names = true

ANY IDEA WHAT'S WRONG??
THANK'S IN ADVANCE
--
Gracias

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 14 1999 - 08:51:33 CDT