How to identify and unlock table locks

/* Identify locked objects */

SELECT

object_name, v.session_id SID, v.oracle_username, TYPE, lmode, request

FROM v$locked_object v, v$lock l, dba_objects o

WHERE l.SID = v.session_id AND v.object_id = o.object_id AND l.BLOCK > 0;

　

/* Identify who locks whom */
SELECT

(SELECT osuser

FROM v$session

WHERE SID = a.SID) blocker, a.SID, (SELECT serial#

FROM v$session

WHERE SID = a.SID) serial#,

' blocks ', (SELECT osuser

FROM v$session

WHERE SID = b.SID) blockee, b.SID, c.username username

FROM v$lock a, v$lock b, v$session c

WHERE a.BLOCK = 1

AND b.request > 0

AND a.id1 = b.id1

AND a.id2 = b.id2

AND b.SID = c.SID

　

/* login as SYSDBA and kill blocking session */
alter
system kill session 'sid,serial#';