Oracle重要视图及含义

X$KSMSP:[K]ernal [S]torage [M]emory Management [S]GA Hea[P]
可以通过这个视图查看Shared Pool的空间分配和使用情况

X$KGLOB:[K]ernal [G]eneric [L]ibrary Cache Manager [O][B]ject
根据library cache pin 等待事件中的p1(library cache handle address) 地址，可以查询对象的具体信息
col KGLNAOWN for a10
col KGLNAOBJ for a20
select ADDR,KGLHDADR,KGLHDPAR,KGLNAOWN,KGLNAOBJ,KGLNAHSH,KGLHDOBJ
from X$KGLOB
where KGLHDADR ='52D6730C'


X$KGLPN:[K]ernal [G]eneric [L]ibrary Cache Manager object [P]i[N]s
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 = '52D6730C' and b.KGLPNMOD<>0

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26180719/viewspace-721666/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26180719/viewspace-721666/