The below SQL gives the list of locks on the Database Objects and the corresponding Terminal
select nvl(S.USERNAME,'Internal') username,
nvl(S.TERMINAL,'None') terminal,
L.SID||','||S.SERIAL# Kill,
U1.NAME||'.'||substr(T1.NAME,1,20) tab,
decode(L.LMODE,1,'No Lock',
2,'Row Share',
3,'Row Exclusive',
4,'Share',
5,'Share Row Exclusive',
6,'Exclusive',null) lmode,
decode(L.REQUEST,1,'No Lock',
2,'Row Share',
3,'Row Exclusive',
4,'Share',
5,'Share Row Exclusive',
6,'Exclusive',null) request
from V$LOCK L,
V$SESSION S,
SYS.USER$ U1,
SYS.OBJ$ T1
where L.SID = S.SID
and T1.OBJ# = decode(L.ID2,0,L.ID1,L.ID2)
and U1.USER# = T1.OWNER#
and S.TYPE != 'BACKGROUND'
and S.sid in(select blocking_session from v$session where blocking_session is not null)
order by 1,2,5
Print This Post
select nvl(S.USERNAME,'Internal') username,
nvl(S.TERMINAL,'None') terminal,
L.SID||','||S.SERIAL# Kill,
U1.NAME||'.'||substr(T1.NAME,1,20) tab,
decode(L.LMODE,1,'No Lock',
2,'Row Share',
3,'Row Exclusive',
4,'Share',
5,'Share Row Exclusive',
6,'Exclusive',null) lmode,
decode(L.REQUEST,1,'No Lock',
2,'Row Share',
3,'Row Exclusive',
4,'Share',
5,'Share Row Exclusive',
6,'Exclusive',null) request
from V$LOCK L,
V$SESSION S,
SYS.USER$ U1,
SYS.OBJ$ T1
where L.SID = S.SID
and T1.OBJ# = decode(L.ID2,0,L.ID1,L.ID2)
and U1.USER# = T1.OWNER#
and S.TYPE != 'BACKGROUND'
and S.sid in(select blocking_session from v$session where blocking_session is not null)
order by 1,2,5
Print This Post
Did you know there is a 12 word phrase you can say to your crush... that will induce intense emotions of love and instinctual attraction for you deep inside his chest?
ReplyDeleteBecause deep inside these 12 words is a "secret signal" that fuels a man's impulse to love, admire and look after you with all his heart...
=====> 12 Words Who Trigger A Man's Desire Impulse
This impulse is so built-in to a man's brain that it will drive him to work harder than ever before to take care of you.
Matter-of-fact, triggering this dominant impulse is absolutely important to having the best ever relationship with your man that the instance you send your man one of the "Secret Signals"...
...You'll instantly find him expose his mind and heart to you in a way he never expressed before and he will perceive you as the only woman in the universe who has ever truly attracted him.