<docbook><section><title>VirtTipsAndTricksGuideFindDeadlockTables</title><bridgehead class="http://www.w3.org/1999/xhtml:h2">How can I find on which table deadlocks occur?</bridgehead>
<bridgehead class="http://www.w3.org/1999/xhtml:h3">What?</bridgehead>
<para>How to understand lock contention situation for your Virtuoso instance.</para>
<bridgehead class="http://www.w3.org/1999/xhtml:h3"> Why?</bridgehead>
<para>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.</para>
<bridgehead class="http://www.w3.org/1999/xhtml:h3"> How?</bridgehead>
<programlisting>SELECT TOP 10 * 
FROM SYS_L_STAT
ORDER BY deadlocks DESC
</programlisting><bridgehead class="http://www.w3.org/1999/xhtml:h3">Related</bridgehead>
<itemizedlist mark="bullet" spacing="compact"><listitem><ulink url="VirtTipsAndTricksGuide">Virtuoso Tips and Tricks Collection</ulink> </listitem>
<listitem><ulink url="http://docs.openlinksw.com/virtuoso/">Virtuoso documentation</ulink> </listitem>
</itemizedlist></section></docbook>