View the lock table process in Oracle and kill the lock table process.

View the lock table process SQL statement 1:
Select sess. Sid,
Sess. Serial #,
Lo. oracle_username,
Lo. OS _user_name,
AO. object_name,
Lo. locked_mode
From v $ locked_object Lo,
Dba_objects AO,
V $ session sess
Where ao. object_id = Lo. object_id and Lo. session_id = sess. Sid;

View the lock table process SQL statement 2:
Select * from V $ session T1, V $ locked_object T2 where t1.sid = t2.session _ id;

Kill the lock table process:
If there is a record, it indicates that there is a lock. Remember the SID and serial # Under the record, and replace the ID of the record with the values and below to unlock the lock.
Alter system kill session '2017 9 ';

Oracle has its own process management policy. In many cases, Kill processes cannot take effect even if they take effect. You can add alter system kill... immediately to try it.

From: http://www.javaeye.com/topic/571315