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
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
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: 4571
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):

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: Fri Mar 31 00:55:41 CDT 2023