Topic: 查看被锁定的数据库对象

  Print this page
1.查看被锁定的数据库对象 Copy to clipboard
Posted by: jeremy
Posted on: 2004-01-31 13:59

SELECT o.object_name,o.object_type,
s.SID,s.USERNAME,s.OSUSER,
s.MACHINE,s.TERMINAL,s.PROGRAM
FROM v$locked_object l,v$session s,all_objects o
WHERE l.SESSION_ID=s.SID
AND l.OBJECT_ID=o.object_id

   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923