查询锁
SELECT
/*+ rule */
s.username,
decode(l.type,
'TM'
,
'TABLE LOCK'
,
'TX'
,
'ROW LOCK'
,
NULL
) LOCK_LEVEL,
o.owner,o.object_name,o.object_type,
s.sid,s.serial#,s.terminal,s.machine,s.program,s.osuser
FROM
v$session s,v$lock l,dba_objects o
WHERE
l.sid = s.sid
AND
l.id1 = o.object_id(+)
AND
s.username
is
NOT
NULL
and
object_name
like
'%P2002%'
|
kill掉持有锁的会话
alter system kill session '74,1620'
|
在kill会话的时候可能会出现:session marked for kill;
处理方式如下:
查询相关进程
select
spid, osuser, s.program
from
v$session s,v$process p
where
s.paddr=p.addr
and
s.sid=
74
|
然后kill掉对应的进程