VOS.VirtTipsAndTricksGuideFindDeadlockTables

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?


SELECT TOP 10 * 
FROM SYS_L_STAT
ORDER BY deadlocks DESC

Related