title: Error while trying to delete rows from table
body: <p>I have a <code>DELETE</code> statement <code>delete from test where id = :a</code> in a package which is being called from Java. Each and every session trying to delete different set of rows from same table <code>test</code> but still I am getting error <code>ORA-00060: deadlock detected while waiting for resource</code>.</p>
  
  <p>Any help that what could have gone wrong here.</p>
  
  <p>I can see the below in trace file but still I couldn't understand why exactly I am getting the deadlock.</p>
  
  <pre class="lang-none prettyprint-override"><code>*** 2018-08-28 06:55:08.128
  DEADLOCK DETECTED ( ORA-00060 )
  See Note 60.1 at My Oracle Support for Troubleshooting ORA-60 Errors
  [Transaction Deadlock]
  
  The following deadlock is not an ORACLE error. It is a
  deadlock due to user error in the design of an application
  or from issuing incorrect ad-hoc SQL. The following
  information may aid in determining the deadlock:
  
  Deadlock graph:
                                            ---------Blocker(s)--------  ---------Waiter(s)---------
  Resource Name                             process session holds waits  process session holds waits
  TM-00049B33-00000000-00000000-00000000        288    2274    SX   SSX      320    2566    SX   SSX
  TM-00049B46-00000000-00000000-00000000        320    2566    SX            142    1851    SX   SSX
  TM-00049B33-00000000-00000000-00000000        142    1851    SX            288    2274    SX   SSX
  
  session 2274: DID 0001-0120-00000406    session 2566: DID 0001-0140-00000019 
  session 2566: DID 0001-0140-00000019    session 1851: DID 0001-008E-0001311B 
  session 1851: DID 0001-008E-0001311B    session 2274: DID 0001-0120-00000406
  
  Rows waited on:
    Session 2274: no row
    Session 2566: no row
    Session 1851: no row
  </code></pre>
  
  <p>is there any reason for not showing <code>ROWID</code> in the trace file?</p>