SQL> SELECT TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS')
  2  || ' User '||s1.username || '@' || s1.machine
  3  || ' ( SID= ' || s1.sid || ' ) with the statement: ' || sqlt2.sql_text
||' is blocking the SQL statement on '|| s2.username || '@'
  4    5  || s2.machine || ' ( SID=' || s2.sid || ' ) blocked SQL -> '
  6  ||sqlt1.sql_text AS blocking_status FROM v$lock l1, v$session s1, v$lock l2 ,
  7  v$session s2,v$sql sqlt1, v$sql sqlt2
  8  WHERE s1.sid =l1.sid
  9  AND s2.sid =l2.sid AND sqlt1.sql_id= s2.sql_id 
AND sqlt2.sql_id= s1.prev_sql_id AND l1.BLOCK =1
10  AND l2.request > 0 AND l1.id1 = l2.id1 AND l2.id2 = l2.id2;

BLOCKING_STATUS
--------------------------------------------------------------------------------
10-JAN-2012 08:53:51 User LTERTIO@TERTIO-SRV ( SID= 138 ) with the statement: SE
LECT a.ID,a.FILENAME FROM OTABATCHFILETABLE a , OTABATCHEPTTABLE b WHERE a.ID =
b.FILE_ID AND a.STATE IN ('P','C','E') AND b.LINK_ID='SmarttrustDP71_link1' is b
locking the SQL statement on LTERTIO@TERTIO-SRV ( SID=187 ) blocked SQL -> DELET
E FROM OTABATCHEPTTABLE WHERE EPT_ID=0001569738120000001

SELECT a.ID,a.FILENAME 
FROM OTABATCHFILETABLE a , OTABATCHEPTTABLE b 
WHERE a.ID =b.FILE_ID 
AND a.STATE IN ('P','C','E') 
AND b.LINK_ID='SmarttrustDP71_link1'

DELETE FROM OTABATCHEPTTABLE 
WHERE EPT_ID=0001569738120000001

 try {
			 connection = dbPool.getAvailableDBConnection();
			 if(connection!=null){
			 String query="DELETE FROM " + get_batchEptTable() + " WHERE EPT_ID=" + eptId;
			 smt=connection.createStatement();
			 result = smt.executeUpdate(query);
			 if(result > 0)				
				 connection.commit();
			 }
		 } catch (SQLException e) {			 
			 connection.rollback();
			 Tome.trace("DbConnection::deleteEpt", Tome.MW_VERBOSE_TRACE,
			 "An SQL Exception occured while deleting records");
			 throw e;
}

SELECT TO_CHAR(sysdate, 'DD-MON-YYYY HH24:MI:SS')
|| ' User '
||s1.username
|| '@'
|| s1.machine
|| ' ( SID= '
|| s1.sid
|| ' ) with the current statement: '
|| sql1cur.sql_text
||' and prev statement: '
|| sqlt1.sql_text
||' is blocking the SQL statement on '
|| s2.username
|| '@'
|| s2.machine
|| ' ( SID='
|| s2.sid
|| ' ) blocked SQL -> '
||sqlt2.sql_text AS blocking_status
FROM v$lock l1, v$session s1, v$lock l2 ,
v$session s2,v$sql sqlt1, v$sql sqlt2,
v$sql sql1cur
WHERE s1.sid =l1.sid
AND s2.sid =l2.sid 
AND sqlt2.sql_id= s2.sql_id 
AND sqlt1.sql_id= s1.prev_sql_id 
AND sql1cur.sql_id(+) = s1.sql_id
AND l1.BLOCK =1
AND l2.request > 0 
AND l1.id1 = l2.id1 
AND l2.id2 = l2.id2