Hi Tamil,

you are saying that "It was due to transaction layer lock.
You can see the TX locks on both sessions.". But I have seen a deadlock trace file which contains TX lock and that deadlock was due to row level locking.

If TX is meant for Transaction layer locking , then what indicates in the trace file that the deadlock is due to row level locking.

Deba