select b.owner TABLEOWNER,
c.MACHINE MACHINE,
b.object_name TABLENAME,
c.OSUSER LOCKBY,
c.USERNAME LOGINID,
c.sid SID,
c.SERIAL# SERIAL
from v$locked_object a, dba_objects b, v$session c
where b.object_id = a.object_id
AND a.SESSION_ID = c.sid; --哇哦,再也不用担心锁表了。
alter system kill session 'SID, SERIAL;