oracle怎么查看锁,Oracle 查看锁情况

查看锁(lock)情况*/

SELECTls.osuser os_user_name,

ls.usernameuser_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_nameOBJECT,

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.id2FROMsys.dba_objects o,

(SELECTs.osuser,

s.username,

l.type,

l.lmode,

s.sid,

s.serial#,

l.id1,

l.id2FROMv$session s, v$lock lWHERE s.sid =l.sid) lsWHERE o.object_id =ls.id1AND 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

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：https://www.cnblogs.com/jenrry/p/10006774.html