Re: TX deadlock - ora060

If you mean to ask if it is possible to trap a deadlock and avoid transaction failure, yes it is. Create an exception handler in your applications code for the error 60 and make a design decision about how you want the application to behave. Do you wait for the competing session to complete or do you fail gracefully?

You can also use the "Select blah blah for update NOWAIT" syntax, which will result in a select error if the row lock cannot be obtained immediately, avoiding the deadlock situation altogether.

• ricky

"Michael Schäfer" wrote:
>
> Hi there,
> is there a possibility to ask Oracle processes if a deadlock has occured
> before is goes to trace-file?
> Thanks,
> Michael
Received on Mon Sep 03 2001 - 19:35:26 CDT