Issue with a multithreading tool
Hi,
Earlier I posted some issues with this tool on which I'm working. Well the main objective of this tool is to process large volume of records in shorter batch time. And here multiple cursors in multiple sessions are working as threads which are processing records in order to reduce the batch time of processing. Earlier there were some problem with the FD and so for multiple sessions it was taking more time in comparing to single session. But now a new problem has been aroused. Like I'm executing scripts in order to process the records from the inout table. Well in some sessions they are quiting. Means they are not processing records after some time. And they are showing errors like the following:
multithread_control_pkg.update_control_status::-54ORA-00054: resource busy and acquire with NOWAIT s false in update control status
No 5 counter
------processing unsuccessful
Well update control status is a function in the tool, which updates the status of the records while they are going thru the processing. And in the intermediate stages they have different status like 'N', 'W', 'P', 'R' etc. N stands for new, working, processed. errorenous etc..
So pls ppl give a feedback so that I can get a soln with this problem.
Thanks & Regards,
Debabrata