coul you give me your version of oracle ?
if your server hp is a serial K and multi processor and your version oracle
7.2.X
there is a patch which could resolve your problem.
i don't remember the patch number but i think it's a generic bus (all
versions 7.2.X Hp AIX ... )
good luck
<yangxiaode_at_my-deja.com> a écrit dans le message :
7u5gu8$8q1$1_at_nnrp1.deja.com...
> 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 Mon Oct 18 1999 - 16:27:28 CDT
