| Oracle dbms_job hangs for Long time [message #576387] |
Mon, 04 February 2013 07:12  |
|
|
Dear All,
Today we have noticed one issue that my oracle dba_jobs has been hanged for more than two days,This job is scheduled to send email to customers,This was scheduled every 10mins.We noticed this and found the job is waiting for TCP-Sockets status network wait,But same procedure is running when we run manually,Please advice why dba_jobs was hanging such a long time.
Regards,
Anil
|
|
|
|
|
|
| Re: Oracle dbms_job hangs for Long time [message #576391 is a reply to message #576389] |
Mon, 04 February 2013 07:54  |
|
|
Dear Michel,
Yes,same must have to be hanged for TCP-Sockets if we run same procdure manually,But mails are sending if we run procedure manually, The issue is in DBA_JOB since it getting hanged for two days and jobs are running or hanged even there is no issues in network.It showing as waiting for TCP-Sockets
Regards,
Anil
|
|
|
|
| Re: Oracle dbms_job hangs for Long time [message #576393 is a reply to message #576391] |
Mon, 04 February 2013 08:01 |
cookiemonster
Messages: 13962
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
dba_jobs is just a view that shows what jobs currently exist and what their status is. So I see no reason to think it's got anything to do with the problem. If you mean the problem only happens when the procedure is run as a job, well maybe, but maybe not - could be something else happened to block the procedure while it was running as a job that hasn't happened since.
If you want more helpful answers than that you're going to have to supply more information - like the procedure code.
|
|
|
|
| Re: Oracle dbms_job hangs for Long time [message #576395 is a reply to message #576391] |
Mon, 04 February 2013 08:04 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
If it is REALLY waiting for TCP sockets then the problem has nothing to do with Oracle.
Oracle is just the victim here, I suggest you to investigate at OS or network side to know why there are these waits.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
