Home » RDBMS Server » Server Administration » Database Jobs getting halted. (Oracle 9i.)
Database Jobs getting halted. [message #349663] Mon, 22 September 2008 10:11
amit_kiran
Messages: 50
Registered: July 2006
Location: UK
Member
We have set a job in oracle to do processing which involves call to many procedure.


The code was working fine till now. Suddenly jobs were getting halted. We tried to debug the issue by checking the job queue and the query it is trying to access currently. The session browser showed the whole process where in we expected to see a query. We checked the session browser and only found that it is idle with wait in db sequential read.


Please could anyone help us how to debug the issue.


I am looking for answer where in I need to find out which object it is accessing at this moment so as to find the resolution.


Please note: We had isolated the procedure within the package and found that the individual jobs when isolated are working fine.
Previous Topic: issue creating pfile from spfile
Next Topic: ORA-00600: internal error code
Goto Forum:
  


Current Time: Sun Nov 03 01:20:12 CDT 2024