死锁ora-60诊断

set wrap off

set  line 132

col USERNAME for a7

col MACHINE for a10

col PROGRAM for a20

select username,sid,serial#,lockwait,status,machine,program from v$session where sid in

(select session_id from v$locked_object)

 

USERNAME          SID    SERIAL# LOCKWAIT         STATUS   MACHINE    PROGRAM

---------- ------- ---------- ---------------- -------- ---------- --------------------

FWBZ               18      61108                  ACTIVE   ctbjoss    JDBC Thin Client

FWBZ              219        109                  ACTIVE   ctbjoss    JDBC Thin Client

FWBZ              221      54948                  ACTIVE   ctbjoss    JDBC Thin Client

 

set wrap off

set  line 132

col OWNER  for a15

col OBJECT_NAME for a20

col ORACLE_USERNAME for a15

col OS_USER_NAME for a12

select l.xidusn, l.object_id, o.owner, o.object_name,o.object_type,

l.session_id, l.oracle_username, l.os_user_name, l.process,

decode(l.locked_mode,

0, '',

1, 'NULL',

2, '(SS)',

3, '(SX)',

4, '(S)',

5, '(SSX)',

6, '(X)',

'???') locked_mode

from v$locked_object l, dba_objects o

where l.object_id= o.object_id

 

v$locked_object视图列出当前系统中哪些对象正被锁定，其主要字段说明如下：

 

字段名称	类型	说明
XIDUSN	NUMBER	回滚段号；
XIDSLOT	NUMBER	事物槽号；
XIDSQN	NUMBER	序列号；
OBJECT_ID	NUMBER	被锁对象标识；