> Christianto Tjahyadi wrote:
> > Btw, how to know the current (active) isolation level used? Also, how to set
> > the deadlock time out?
>

Aage Johansen wrote:

>
> ...Don't know a thing about "deadlock time out".
>

The deadlock timeout is 10 seconds, by default, and you probably don't
want to change that. A deadlock scan is expensive. But that's probably
not what you want. You probably want a blocked update or delete (i.e.
Update Conflict) to time out. That's a V2 feature. For earlier
versions the choice is an immediate error (no wait) or waiting until the
blocking transaction completes.


Regards,


Ann