oracle查锁

select   V$SESSION.sid,v$session.SERIAL#,v$process.spid,  
  rtrim(object_type)   object_type,rtrim(owner)   ||   '.'   ||   object_name   object_name,  
  decode(lmode,       0,   'None',  
  1,   'Null',  
  2,   'Row-S',  
  3,   'Row-X',  
  4,   'Share',  
  5,   'S/Row-X',  
  6,   'Exclusive', 'Unknown')   LockMode,  
  decode(request,   0,   'None',  
  1,   'Null',  
  2,   'Row-S',  
  3,   'Row-X',  
  4,   'Share',  
  5,   'S/Row-X',  
  6,   'Exclusive',   'Unknown')   RequestMode  
  ,ctime,   block   b,  
  v$session.username,MACHINE,MODULE,ACTION,  
  decode(A.type,  
  'MR',   'Media   Recovery',  
  'RT','Redo   Thread',  
  'UN','User   Name',  
  'TX',   'Transaction',  
  'TM',   'DML',  
  'UL',   'PL/SQL   User   Lock',  
  'DX',   'Distributed   Xaction',  
  'CF',   'Control   File',  
  'IS',   'Instance   State',  
  'FS',   'File   Set',  
  'IR',   'Instance   Recovery',  
  'ST',   'Disk   Space   Transaction',  
  'TS',   'Temp   Segment',  
  'IV',   'Library   Cache   Invalida-tion',  
  'LS',   'Log   Start   or   Switch',  
  'RW',   'Row   Wait',  
  'SQ',   'Sequence   Number',  
  'TE',   'Extend   Table',  
  'TT',   'Temp   Table',  
  'Unknown')   LockType  
  from   (SELECT   *   FROM   V$LOCK)   A,   all_objects,V$SESSION,v$process  
  where   A.sid   >   6  
  and   object_name<>'OBJ$'  
  and   A.id1   =   all_objects.object_id  
  and   A.sid=v$session.sid  
  and   v$process.addr=v$session.paddr;

转载于:https://www.cnblogs.com/t-bag/archive/2009/03/02/1401567.html