摘自：
chinaunix
SELECT
??S.SID?SESSION_ID,?S.USERNAME,?DECODE(LMODE,?
0
,?
'
None
'
,?
1
,?
'
Null
'
,?
2
,?
'
Row-S?(SS)
'
,?
3
,?
'
Row-X?(SX)
'
,??
4
,?
'
Share
'
,?
5
,?
'
S/Row-X?(SSX)
'
,??
6
,?
'
Exclusive
'
,?TO_CHAR(LMODE))?MODE_HELD,?DECODE(REQUEST,?
0
,?
'
None
'
,?
1
,?
'
Null
'
,?
2
,?
'
Row-S?(SS)
'
,?
3
,?
'
Row-X?(SX)
'
,?
4
,?
'
Share
'
,?
5
,?
'
S/Row-X?(SSX)
'
,?
6
,?
'
Exclusive
'
,?TO_CHAR(REQUEST))?MODE_REQUESTED,?O.OWNER
||
'
.
'
||
O.
OBJECT_NAME
||
'
?(
'
||
O.OBJECT_TYPE
||
'
)
'
,?S.TYPE?LOCK_TYPE,?L.ID1?LOCK_ID1,?L.ID2?LOCK_ID2?
FROM
?V$LOCK?L,?SYS.DBA_OBJECTS?O,?V$SESSION?S?
WHERE
?L.SID?
=
?S.SID?
AND
??L.ID1?
=
?O.
OBJECT_ID
執行上記SQL語句,可以查尋到數據庫中的鎖的情報.
SESSION_ID, USERNAME,??MODE_HELD,??MODE_REQUESTED, OBJECT_NAME, LOCK_TYPE, LOCK_ID
分別是 擁有鎖的SESSION_ID,擁有鎖的USERNAME,鎖的執行模式MODE_HELD,鎖的請求MODE_REQUESTED,鎖所在的數據庫對象名
,鎖的類型,鎖的ID