二、oracle查看锁表进程

oracle查看锁表进程，杀掉锁表进程2008-10-22 16:01查看锁表进程SQL语句1：ITPUB个人空间+Af

---

e l-`3KF/i z
select sess.sid,ITPUB个人空间^n3]1U q
   sess.serial#,ITPUB个人空间1sR!Z1}:E G;sO(x
   lo.oracle_username,
zF
Gk:O-i
t /0   lo.os_user_name,
I }9u:dysi0  ao.object_name,
H&Y;YI:S x-/0   lo.locked_mode

---

O
A)A#u‑w0   from v$locked_object lo,ITPUB个人空间M(X3Z,b'Q+|'ZW4[
y
   dba_objects ao,
c
[6G ~hj WD0   v$session sessITPUB个人空间J#E.K_7N I%L9u
where ao.object_id = lo.object_id and lo.session_id = sess.sid;

--查看锁表进程SQL语句2：ITPUB个人空间‑wBj,^$/
P%M
select * from v$session t1, v$locked_object t2 where t1.sid = t2.SESSION_ID;

--杀掉锁表进程：ITPUB个人空间t:P;dv i*r;k
--如有記錄則表示有lock，記錄下SID和serial# ，將記錄的ID替換下面的738,1429，即可解除LOCKITPUB个人空间&Tz

---

D/|A|s(]
alter system kill session '738,1429';

 

例如（20100927用到的）：
select * from v$session t1, v$locked_object t2 wheret1.sid = t2.SESSION_ID;
159 77
1308 1308

alter system kill session '77,1308';