x$kglpn
x$kglpn基表﹕
X$KGLPN--[K]ernel [G]eneric [L]ibrary Cache Manager object
[P]i[N]s
它是与x$kgllk相对应的表﹐是关于pin的相关信息
引用该表的相关视图﹕
DBA_KGLLOCK
表相关字段的描述﹕
SQL> desc
x$kglpn;
名称
类型
------------
----------------------------
ADDR
RAW(4)
INDX
NUMBER
INST_ID
NUMBER
KGLPNADR
RAW(4)
KGLPNUSE
RAW(4)
---会话地址
KGLPNSES
RAW(4)
---owner地址
KGLPNHDL
RAW(4)
---句柄
KGLPNLCK
RAW(4)
KGLPNCNT
NUMBER
KGLPNMOD
NUMBER ---pin的当前模式(0为no
lock/pin
held﹐1为null,2为share﹐3为exclusive)
KGLPNREQ
NUMBER ---pin当前需求的模式(0为no
lock/pin
held﹐1为null,2为share﹐3为exclusive)
KGLPNDMK
NUMBER
KGLPNSPN
NUMBER
---对应跟踪文件的savepoint的值
select
a.sid,a.username,a.program,b.addr,b.KGLPNADR,b.KGLPNUSE,b.KGLPNSES,b.KGLPNHDL,
b.kGLPNLCK,
b.KGLPNMOD, b.KGLPNREQ
from v$session a,x$kglpn b
where
a.saddr=b.kglpnuse
and b.kglpnhdl = '0700000461731FF8'
and
b.KGLPNMOD0;