oracle 查询被锁住的会话的sid，serial#，pid
select s.sid, s.serial#, p.spid as 系统进程号
from v$locked_object l, dba_objects o, v$session s, v$process p
where l.object_id = o.object_id
and l.session_id = s.sid
and s.paddr = p.addr;
版权声明：本文为weeknd原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。