v$lock中的ADDR与KADDR区别是什么 - Oracle数据库管理 Oracle数据库数据恢复、性能优化

Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › v$lock中的ADDR与KADDR区别是什么

1^#

发表于 2013-8-29 13:30:14

GV$LOCK =>
select USERENV('Instance'),
   laddr,
   kaddr,
   saddr,
   raddr,
   lmode,
   request,
   ctime,
   block,
   con_id
  from v$_lock1
union all
select inst_id,
   addr,
   ksqlkadr,
   ksqlkses,
   ksqlkres,
   ksqlkmod,
   ksqlkreq,
   ksqlkctim,
   ksqlklblk,
   con_id
  from x$ktadm
where bitand(kssobflg, 1) != 0
and (ksqlkmod != 0 or ksqlkreq != 0)
union all
select inst_id,
   addr,
   ksqlkadr,
   ksqlkses,
   ksqlkres,
   ksqlkmod,
   ksqlkreq,
   ksqlkctim,
   ksqlklblk,
   con_id
  from x$ktatrfil
where bitand(kssobflg, 1) != 0
and (ksqlkmod != 0 or ksqlkreq != 0)
union all
select inst_id,
   addr,
   ksqlkadr,
   ksqlkses,
   ksqlkres,
   ksqlkmod,
   ksqlkreq,
   ksqlkctim,
   ksqlklblk,
   con_id
  from x$ktatrfsl
where bitand(kssobflg, 1) != 0
and (ksqlkmod != 0 or ksqlkreq != 0)
union all
select inst_id,
   addr,
   ksqlkadr,
   ksqlkses,
   ksqlkres,
   ksqlkmod,
   ksqlkreq,
   ksqlkctim,
   ksqlklblk,
   con_id
  from x$ktatl
where bitand(kssobflg, 1) != 0
and (ksqlkmod != 0 or ksqlkreq != 0)
union all
select inst_id,
   addr,
   ksqlkadr,
   ksqlkses,
   ksqlkres,
   ksqlkmod,
   ksqlkreq,
   ksqlkctim,
   ksqlklblk,
   con_id
  from x$ktstusc
where bitand(kssobflg, 1) != 0
and (ksqlkmod != 0 or ksqlkreq != 0)
union all
select inst_id,
   addr,
   ksqlkadr,
   ksqlkses,
   ksqlkres,
   ksqlkmod,
   ksqlkreq,
   ksqlkctim,
   ksqlklblk,
   con_id
  from x$ktstuss
where bitand(kssobflg, 1) != 0
and (ksqlkmod != 0 or ksqlkreq != 0)
union all
select inst_id,
   addr,
   ksqlkadr,
   ksqlkses,
   ksqlkres,
   ksqlkmod,
   ksqlkreq,
   ksqlkctim,
   ksqlklblk,
   con_id
  from x$ktstusg
where bitand(kssobflg, 1) != 0
and (ksqlkmod != 0 or ksqlkreq != 0)
union all
select inst_id,
   ktcxbxba,
   ktcxblkp,
   ksqlkses,
   ksqlkres,
   ksqlkmod,
   ksqlkreq,
   ksqlkctim,
   ksqlklblk,
   con_id
  from x$ktcxb
where bitand(ksspaflg, 1) != 0
and (ksqlkmod != 0 or ksqlkreq != 0)

回复显示全部楼层道具举报

Maclean Liu(刘相兵

2^#

发表于 2013-8-29 13:31:37

ADDR RAW(4 | 8) Address of lock state object ==> 一个enqueue lock对应一个session state object 和一个process state object

KADDR ==>lock本身的地址

回复显示全部楼层道具举报

返回列表

		自动登录	找回密码
密码			注册