lock
emcs
94次下载
752次浏览
2019-07-24
4.5

脚本内容

set linesize 180 col username for a15 col owner for a15 col OBJECT_NAME for a30 col SPID for a10 --查询某个会话的锁 select /*+rule*/SESSION_ID,OBJECT_ID,ORACLE_USERNAME,OS_USER_NAME,PROCESS,LOCKED_MODE from gv$locked_object where session_id=&sid; --查询TMTX锁 select /*+rule*/* from v$lock where ctime >100 and type in ('TX','TM') order by 3,9; --查询数据库中的锁 select /*+rule*/s.sid,p.spid,l.type,round(max(l.ctime)/60,0) lock_min,s.sql_id,s.USERNAME,b.owner,b.object_type,b.object_name from v$session s, v$process p,v$lock l,v$locked_object o,dba_objects b where o.SESSION_ID=s.sid and s.sid=l.sid and o.OBJECT_ID=b.OBJECT_ID and s.paddr = p.addr and l.ctime >100 and l.type in ('TX','TM','FB') group by s.sid,p.spid,l.type,s.sql_id,s.USERNAME,b.owner,b.object_type,b.object_name order by 9,1,3,4;

评论

贡献排行榜