oracle 表解锁sql

Select p.Spid,
c.Object_Name,
b.Session_Id,
b.Oracle_Username,
b.Os_User_Name
From V$process p, V$session a, V$locked_Object b, All_Objects c
Where p.Addr = a.Paddr
And a.Process = b.Process
And c.Object_Id = b.Object_Id
And c.object_name = ‘’；

kill掉Session_Id即可

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8069778/viewspace-1050256/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8069778/viewspace-1050256/