Locks in Database
SELECT DECODE(request,0,'Holder: ',' Waiter: ')||sid sess,id1,id2, lmode,inst_id, request, type
FROM GV$LOCK WHERE (id1, id2, type)
IN
(SELECT id1, id2, type FROM GV$LOCK WHERE request>0) ORDER BY id1, request
select sid,serial#,module,status,action,to_char(logon_time,'dd-mon-yyyy hh24:mi:ss') logon_time from v$session where sid=&sid;
SELECT DECODE(request,0,'Holder: ',' Waiter: ')||sid sess,id1,id2, lmode,inst_id, request, type
FROM GV$LOCK WHERE (id1, id2, type)
IN
(SELECT id1, id2, type FROM GV$LOCK WHERE request>0) ORDER BY id1, request
select sid,serial#,module,status,action,to_char(logon_time,'dd-mon-yyyy hh24:mi:ss') logon_time from v$session where sid=&sid;
No comments:
Post a Comment