daniele.barzotti wrote:

>
> So my question are:
> 1. Why there is an open transaction? I do not open one explicitly

All statements are done in the context of a transaction.

> 2. How can I detect if a particular table/query belong to a pending transaction?

Tables don't belong to transactions. Queries do as do record
versions.

> 3. Or..How can avoid deadlock?

By choosing a more reasonable set of transaction options. For example,
if you are using read-committed transactions, use the "record version"
option.

>

What transaction options are you using - other than wait or no wait?

Best regards,

Ann