Home » Server Options » Replication » Hanging Job - How to solve
Hanging Job - How to solve [message #185771] Thu, 03 August 2006 08:48 Go to next message
Uwe
Messages: 260
Registered: February 2003
Location: Zürich, Switzerland
Senior Member
Hi all,

We have an builded up replication running. Now I have a job in status hanging. EM shows jobs okay, No broken jobs.
How could I get rid of this hanging job ?
I tried to stop the session - it went in status killed, but job is stil in the dba_jobs_runnig.
If I try to start the job once again, it bring out that this job is not in the schedule by now. dba_jobs shows this job with a actual date from yesterday evening and a nex date also yesterday. The job normally runs every 10 mins, I guess

Any hints welcome
regards
Uwe
Re: Hanging Job - How to solve [message #189351 is a reply to message #185771] Thu, 24 August 2006 04:32 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
It you cannot kill the session you will have to bounce the database.

Please check the following:

1) database locks on all the master sites; and

2) value for "delay_seconds" (parameter to push function):
Quote:

Do not return before the specified number of seconds have elapsed, even if the queue is empty. Useful for reducing execution overhead if PUSH is called from a tight loop.
Previous Topic: Basic Replication Setup - HOW?
Next Topic: refresh rate of materialized view
Goto Forum:
  


Current Time: Thu Mar 28 14:36:19 CDT 2024