Hi,
I have query something like this:
select * from emp where sal > ( select avg(sal) from emp ) for update
When ran multithreaded environment, i used to get this error
"Abnormal end unit of work condition occured" which is i think is due to deadlock condition.
I just wanted to know that What database lock ( share/update/exclusive) will be aquired for the above statement ? Is it that all txn will try to hold only U lock (since for update clause is present) ?? Or 1 txn holds U lock and other txn holds S lock ( for inner query)??
Thanks,
Jaideep.
I have query something like this:
select * from emp where sal > ( select avg(sal) from emp ) for update
When ran multithreaded environment, i used to get this error
"Abnormal end unit of work condition occured" which is i think is due to deadlock condition.
I just wanted to know that What database lock ( share/update/exclusive) will be aquired for the above statement ? Is it that all txn will try to hold only U lock (since for update clause is present) ?? Or 1 txn holds U lock and other txn holds S lock ( for inner query)??
Thanks,
Jaideep.
Comment