Re: out of process memory

Hi, Marco

I think your problem is you don't have enough rollback segments, just talk to DBA and increase your rollback segments, and hope the problem vanish.

Henry

In article <7u4n4u$jv1$1_at_nnrp1.deja.com>,   Marco Hernandez <mpadilla_at_my-deja.com> wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 14 1999 - 16:11:49 CDT