--查询锁表
select
b.SID,
b.SERIAL#,
b.USERNAME,
b.MACHINE,
c.object_name
from v$lock a, v$session b , dba_objects c
where a.SID = b.SID
and a.ID1 = c.object_id
and b.USERNAME = 'JSUSER'
b.SID,
b.SERIAL#,
b.USERNAME,
b.MACHINE,
c.object_name
from v$lock a, v$session b , dba_objects c
where a.SID = b.SID
and a.ID1 = c.object_id
and b.USERNAME = 'JSUSER'
--删除锁表
alter system kill session 'sid,serial#'