x$表

3.x$kglob--[K]ernel [G]eneric [L]ibrary Cache Manager [OB]ject

SYS@ orcl> desc x$kglob
 -- ##主要用来查看library cache 的对象
 Name                                                  Null?    Type
 ----------------------------------------------------- -------- ------------------------
 ADDR                                                           RAW(4)
 INDX                                                           NUMBER
 INST_ID                                                        NUMBER
 KGLHDADR                                                       RAW(4)
 ##关联v$session_wait中event为library cache pin的P1RAW

 KGLHDPAR                                                       RAW(4)
 KGLHDCLT                                                       NUMBER
 KGLNAOWN                                                       VARCHAR2(64)
 ##当前处于library cache pin的owner
 
 KGLNAOBJ                                                       VARCHAR2(1000)
 ##当前处于library cache pin的对象
 
 KGLNADLK                                                       VARCHAR2(64)
 KGLNAHSH                                                       NUMBER
 KGLNATIM                                                       DATE
 KGLNAPTM                                                       DATE
 KGLHDNSP                                                       NUMBER
 KGLHDLMD                                                       NUMBER
 KGLHDPMD                                                       NUMBER
 KGLHDFLG                                                       NUMBER
 KGLHDOBJ                                                       RAW(4)
 KGLHDLDC                                                       NUMBER
 KGLHDIVC                                                       NUMBER
 KGLHDEXC                                                       NUMBER
 KGLHDLKC                                                       NUMBER
 KGLHDKMK                                                       NUMBER
 KGLHDDMK                                                       NUMBER
 KGLHDAMK                                                       NUMBER
 KGLOBFLG                                                       NUMBER
 KGLOBSTA                                                       NUMBER
 KGLOBTYP                                                       NUMBER
 KGLOBHS0                                                       NUMBER
 KGLOBHS1                                                       NUMBER
 KGLOBHS2                                                       NUMBER
 KGLOBHS3                                                       NUMBER
 KGLOBHS4                                                       NUMBER
 KGLOBHS5                                                       NUMBER
 KGLOBHS6                                                       NUMBER
 KGLOBHS7                                                       NUMBER
 KGLOBHD0                                                       RAW(4)
 KGLOBHD1                                                       RAW(4)
 KGLOBHD2                                                       RAW(4)
 KGLOBHD3                                                       RAW(4)
 KGLOBHD4                                                       RAW(4)
 KGLOBHD5                                                       RAW(4)
 KGLOBHD6                                                       RAW(4)
 KGLOBHD7                                                       RAW(4)
 KGLOBPC0                                                       NUMBER
 KGLOBPC6                                                       NUMBER
 KGLOBTP0                                                       RAW(4)
 KGLOBT00                                                       NUMBER
 KGLOBT01                                                       NUMBER
 KGLOBT02                                                       NUMBER
 KGLOBT04                                                       NUMBER
 KGLOBT05                                                       NUMBER
 KGLOBT06                                                       NUMBER
 KGLOBT07                                                       NUMBER
 KGLOBT08                                                       NUMBER
 KGLOBT09                                                       NUMBER
 KGLOBT10                                                       NUMBER
 KGLOBT11                                                       NUMBER
 KGLOBT12                                                       NUMBER
 KGLOBT13                                                       NUMBER
 KGLOBT14                                                       NUMBER
 KGLOBT15                                                       NUMBER
 KGLOBT16                                                       NUMBER
 KGLOBT17                                                       NUMBER
 KGLOBT18                                                       NUMBER
 KGLOBT19                                                       NUMBER
 KGLOBT20                                                       NUMBER
 KGLOBT21                                                       NUMBER
 KGLOBT22                                                       NUMBER
 KGLOBT23                                                       NUMBER
 KGLOBT24                                                       NUMBER
 KGLOBT25                                                       NUMBER
 KGLOBT26                                                       NUMBER
 KGLOBT28                                                       NUMBER
 KGLOBT29                                                       NUMBER
 KGLOBT30                                                       NUMBER
 KGLOBT31                                                       NUMBER
 KGLOBT27                                                       NUMBER
 KGLOBT32                                                       NUMBER
 KGLOBT33                                                       NUMBER
 KGLOBTL0                                                       NUMBER
 KGLOBTL1                                                       NUMBER
 KGLOBTS0                                                       VARCHAR2(64)
 KGLOBTS1                                                       VARCHAR2(64)
 KGLOBTN0                                                       NUMBER
 KGLOBTN1                                                       NUMBER
 KGLOBTN2                                                       NUMBER
 KGLOBTN3                                                       NUMBER
 KGLOBTN4                                                       NUMBER
 KGLOBTN5                                                       NUMBER
 KGLOBTS2                                                       VARCHAR2(64)
 KGLOBTT0                                                       DATE