日期:2014-05-16 浏览次数:20567 次
oracle查找锁定表信息
?
--查找锁定表信息 
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;