| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
