%META:TOPICPARENT{name="VirtTipsAndTricksGuide"}%

---++How can I find on which table deadlocks occur?

---+++What?

How to understand lock contention situation for your Virtuoso instance.

---+++ Why?

There are time where clients make assumptions about locking that contradict the default isolation level of a Virtuoso instance (typically: read committed). Being able to view lock content information can be helpful in diagnosing such conditions.

---+++ How?

<verbatim>
SELECT TOP 10 * 
FROM SYS_L_STAT
ORDER BY deadlocks DESC
</verbatim>


---+++Related
   
   * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]]
   * [[http://docs.openlinksw.com/virtuoso/][Virtuoso documentation]]