select session_id from v$locked_object;
4491
SET LINESIZE 100
SET PAGESIZE 50000
COL USERNAME FOR A10
COL machine FOR A15
COL sql_text FOR A50
select
substr(s.username,1,18) username,
s.sid,s.serial#,s.machine,y.sql_text
from v$session s,v$process p,v$transaction t,v$rollstat r,v$rollname n,v$sql y
where s.paddr = p.addr
and s.taddr = t.addr (+)
and t.xidusn = r.usn (+)
and r.usn = n.usn (+)
and 2 3 4 5 6 7 8 9 s.username is not null
and s.sql_address=y.address
and s.sid=4491
order by s.sid,s.serial#,s.username,s.status;
https://www.cndba.cn/hbhe0316/article/5028
https://www.cndba.cn/hbhe0316/article/5028
https://www.cndba.cn/hbhe0316/article/5028
https://www.cndba.cn/hbhe0316/article/5028
https://www.cndba.cn/hbhe0316/article/5028
https://www.cndba.cn/hbhe0316/article/5028
https://www.cndba.cn/hbhe0316/article/5028
https://www.cndba.cn/hbhe0316/article/5028 https://www.cndba.cn/hbhe0316/article/5028
版权声明：本文为博主原创文章，未经博主允许不得转载。
oracle,linux