<div>
Check the alert log which would point you to a trace file with all the details you require.<br />
<br />
R.
</div>


Check the alert log which would point you to a trace file with all the details you require.

R.

<div>
<div class="content wysiwyg-content">
I am using Oracle 10g. Sometimes application got stuck due to deadlock. I want to find out from where it is got locked and other details of it. Is there any query for that to find it out?
</div>
</div>


I am using Oracle 10g. Sometimes application got stuck due to deadlock. I want to find out from where it is got locked and other details of it. Is there any query for that to find it out?

oracle session or table lock

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.