Oracle 查看锁情况
时间：2021-07-01 10:21:17
帮助过：14人阅读
查看锁（lock）情况*/
SELECT ls.osuser os_user_name,
ls.username user_name,
decode(ls.type,
‘RW‘,
‘Row wait enqueue lock‘,
‘TM‘,
‘DML enqueue lock‘,
‘TX‘,
‘Transaction enqueue lock‘,
‘UL‘,
‘User supplied lock‘) lock_type,
o.object_name OBJECT,
decode(ls.lmode,
1,
NULL,
2,
‘Row Share‘,
3,
‘Row Exclusive‘,
4,
‘Share‘,
5,
‘Share Row Exclusive‘,
6,
‘Exclusive‘,
NULL) lock_mode,
o.owner,
ls.sid,
ls.serial# serial_num,
ls.id1,
ls.id2
FROM sys.dba_objects o,
(SELECT s.osuser,
s.username,
l.type,
l.lmode,
s.sid,
s.serial#,
l.id1,
l.id2
FROM v$session s, v$lock l
WHERE s.sid
= l.sid) ls
WHERE o.
object_id = ls.id1
AND o.owner
<> ‘SYS‘
AND o.
object_name = ‘CUX_CUX_PA_REVENUE_COST_TEMP‘
ORDER BY o.owner, o.
object_name
;
Oracle 查看锁情况
标签：objects use font share revenue action style mod from
