TABLE GETS LOCKED
Posted: Mon Mar 28, 2005 3:44 am
I ran a batch job which had 3 update statements on a table A.
The execution of this job took more time than expected and so i i tried to stop th execution,but it did'nt stop and so i used clean up resources option.
then the status of the job was shown as compiled. but when i opened the log for that batch job, i could not see the job aborted or anything
I can only see
Batch::UpdateKey: Set NLS locale to US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH
When i try to run those update statements manually again, i colud not see it get completed. i think the table is locked.
I have faced this type of problems many times. De to this my development time is increasing.
Pls suggest me what to do in such cases
The execution of this job took more time than expected and so i i tried to stop th execution,but it did'nt stop and so i used clean up resources option.
then the status of the job was shown as compiled. but when i opened the log for that batch job, i could not see the job aborted or anything
I can only see
Batch::UpdateKey: Set NLS locale to US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH,US-ENGLISH
When i try to run those update statements manually again, i colud not see it get completed. i think the table is locked.
I have faced this type of problems many times. De to this my development time is increasing.
Pls suggest me what to do in such cases