Home » RDBMS Server » Server Administration » Oracle dbms_job hangs for Long time (Oracle 10g,10.2.0.5,Microsoft windows 2003)
Oracle dbms_job hangs for Long time [message #576387] Mon, 04 February 2013 07:12 Go to next message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

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 #576389 is a reply to message #576387] Mon, 04 February 2013 07:41 Go to previous messageGo to next message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because it is waiting for TCP-sockets.

Regards
Michel
Re: Oracle dbms_job hangs for Long time [message #576391 is a reply to message #576389] Mon, 04 February 2013 07:54 Go to previous messageGo to next message
AnilKampiri
Messages: 69
Registered: September 2012
Location: Chennai
Member

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 Go to previous messageGo to next message
cookiemonster
Messages: 10571
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 Go to previous message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: NLS date format in Oracle
Next Topic: How to clean corrupted dba_tables
Goto Forum:
  


Current Time: Wed Apr 16 15:40:11 CDT 2014

Total time taken to generate the page: 0.09574 seconds