文章分类
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2012-11-20 15:03:17
select a.sid, b.serial#, 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, c.object_name,
---b.username,
---b.osuser,
decode(a.lmode,
0,
'none',
1,
'null',
2,
'row-s',
3,
'row-x',
4,
'share',
5,
's/row-x',
6,
'exclusive',
'unknown') lockmode, b.machine, d.spid
from v$lock a, v$session b, all_objects c, v$process d
where a.sid = b.sid and a.type in ('tm', 'tx') and c.object_id = a.id1 and
b.paddr = d.addr
给主人留下些什么吧！~~