这个表应该没有人在用,程序员提出来要删除的,
有没有强制删除的方法。
令我从v$session中得到一些线索:
SQL> select username,lockwait from v$session;
USERNAME LOCKWAIT
------------------------------------------------------------ -----------------------
ZHK2
ZHK1
ZHK1
ZHK4 C000000004199A00
ZHK4 C0000000041998C8
ZHK2
ZHK4 C00000000419A220
ZHK4
ZHK4 C0000000041997F8
ZHK1
ZHK2
ZHK1
ZHK4
ZHK2
USERNAME LOCKWAIT
------------------------------------------------------------ -----------------------
ZHK4
ZHK1
ZHK1
ZHK3
ZHK1
ZHK2
ZHK4 C000000004199B38
ZHK1
ZHK2
ZHK1
ZHK1
ZHK4 C00000000419A0E8
ZHK4 C000000004199A68
ZHK4
ZHK4
ZHK1
ZHK2
ZHK1
ZHK2
ZHK4 C000000004199860
ZHK1
USERNAME LOCKWAIT
------------------------------------------------------------ -----------------------
ZHK4
ZHK1
ZHK1
ZHK4 C000000004199C70
ZHK2
ZHK2
ZHK1
ZHK4 C000000004199AD0
ZHK4 C000000004199930
ZHK1
ZHK4 C000000004199BA0
ZHK4 C000000004199C08
ZHK4 C000000004199998
ZHK1
ZHK4
ZHK2
ZHK1
ZHK2
ZHK1
--------------------------------------------------
有什么办法,去除lock?