查看 Oracle 数据库锁和解锁的方法
查看 Oracle 数据库锁和解锁的方法
查看 Oracle 数据库锁和解锁的方法- -- 查看数据库锁明细
- select a.sid, b.serial#, b.username, b.oSUSEr, b.machine, b.program, c.object_name,d.spid,
- 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,
- decode(a.lmode,
- 0, 'none',
- 1, 'null',
- 2, 'row-s',
- 3, 'row-x',
- 4, 'share',
- 5, 's/row-x',
- 6, 'exclusive', 'unknown') lockmode
- 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;
- -- 杀掉进程
- -- alter system kill session 'sid,serial#';
评论暂时关闭