| Hanging Job - How to solve [message #185771] |
Thu, 03 August 2006 08:48  |
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  |
Frank Naude
Messages: 4581
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.
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
