One possible way to find on which table deadlocks occur is to execute the following statement:
SELECT TOP 10 * FROM SYS_L_STAT ORDER BY deadlocks DESC
| Prev | Up | Next |
| 1.5.2. How Can I execute SPARQL queries containing '$' character using ISQL? | Home | 1.5.4. How Can I configure parameters to avoid out of memory error? |
© OpenLink Software 2016 .
This HTML5 document contains 16 embedded RDF statements represented using HTML+Microdata notation.
The embedded RDF content will be recognized by any processor of HTML5 Microdata.
| Prefix | IRI |
|---|---|
| schema | http://schema.org/ |
| n5 | http://creativecommons.org/licenses/by/4.0/ |
| n2 | http://docs.openlinksw.com/virtuoso/virtuosotipsandtricksfinddeadlockstables/ |
| rdf | http://www.w3.org/1999/02/22-rdf-syntax-ns# |
| n4 | http://www.openlinksw.com/# |
| xsdh | http://www.w3.org/2001/XMLSchema# |
This HTML document contains 16 embedded RDF statements represented using (X)HTML+RDFa notation.
The embedded RDF content will be recognized by any processor of (X)HTML+RDFa.
| Prefix | URI |
|---|---|
| xmlns:schema | http://schema.org/ |
| xmlns:n5 | http://creativecommons.org/licenses/by/4.0/ |
| xmlns:n2 | http://docs.openlinksw.com/virtuoso/virtuosotipsandtricksfinddeadlockstables/ |
| xmlns:rdf | http://www.w3.org/1999/02/22-rdf-syntax-ns# |
| xmlns:n4 | http://www.openlinksw.com/# |
| xmlns:xsdh | http://www.w3.org/2001/XMLSchema# |
| Subject | Predicate | Object |
|---|---|---|
| n2: | rdf:type | schema:APIReference |
| n2: | rdf:type | schema:TechArticle |
| n2: | schema:name | 1.5.3.ÃÂ How can I find on which table deadlocks occur? |
| n2: | schema:copyrightHolder | _:vb82478 |
| n2: | schema:datePublished | 2016-09-09 16:16:54 |
| n2: | schema:headline | 1.5.3.ÃÂ How can I find on which table deadlocks occur? |
| n2: | schema:keywords | OpenLink,Virtuoso,database,RDBMS,relational,SQL,RDF,triple store,linked data,linked open data,Big Data,SPARQL |
| n2: | schema:license | n5:deed.en_US |
| n2: | schema:publisher | _:vb82477 |
| n2: | schema:url | n2: |
| _:vb82477 | rdf:type | schema:Organization |
| _:vb82477 | schema:name | OpenLink Software |
| _:vb82477 | schema:url | n4:this |
| _:vb82478 | rdf:type | schema:Organization |
| _:vb82478 | schema:name | OpenLink Software |
| _:vb82478 | schema:url | n4:this |
