一些X$表的小结

1.X$KTUXE——[K]ernel [T]ransaction [U]ndo Transa[x]tion [E]ntry

sys @ ORALOCAL ( 192.168.0.22 ) > desc X $ KTUXE ##主要用来查看scn和smon正在清理的undo block

Name Null ? Type
--------------------------------------------------- -- -------- ---------------------
ADDR RAW ( 4 )
INDX NUMBER
INST_ID NUMBER
KTUXEUSN NUMBER
KTUXESLT NUMBER
KTUXESQN NUMBER
KTUXERDBF NUMBER
KTUXERDBB NUMBER
KTUXESCNB NUMBER
KTUXESCNW NUMBER ##9i之前版本根据max(ktuxescnw * power(2, 32) + ktuxescnb) 算出当前scn

KTUXESTA VARCHAR2 ( 16 )
KTUXECFL VARCHAR2 ( 24 ) ## 如果值为'DEAD'，表示有事务在做回滚；NONE表示正常；

KTUXEUEL NUMBER
KTUXEDDBF NUMBER
KTUXEDDBB NUMBER
KTUXEPUSN NUMBER
KTUXEPSLT NUMBER
KTUXEPSQN NUMBER
KTUXESIZ NUMBER ##需要回滚的undo block大小

2.x$kglpn——[K]ernel [G]eneric [L]ibrary Cache Manager object [P]i[N]s

sys @ ORALOCAL ( 192.168.0.22 ) > desc x $ kglpn ##主要用来处理library cache pin holder

Name Null ? Type
--------------------------------------------------- -- -------- ------------
ADDR RAW ( 4 )
INDX NUMBER
INST_ID NUMBER
KGLPNADR RAW ( 4 )
KGLPNUSE RAW ( 4 )
KGLPNSES RAW ( 4 )
KGLPNHDL RAW ( 4 ) ##关联v$session_wait中event为library cache pin的P1RAW，再关联v$session，可以查出sid和serial#

KGLPNLCK RAW ( 4 )
KGLPNCNT NUMBER
KGLPNMOD NUMBER ##如果值为3，表示为library cache pin的holder；如果值为0，表示为waiter

KGLPNREQ NUMBER ##如果值为0，表示为library cache pin的holder；如果值为2，表示为waiter

KGLPNDMK NUMBER
KGLPNSPN NUMBER

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

sys @ ORALOCAL ( 192.168.0.22 ) > 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

4.X$KSMSP——[K]ernal [S]torage [M]emory Management [S]GA Hea[P]

sys @ ORALOCAL ( 192.168.0.22 ) > desc X $ KSMSP ## 主要用于查看shared pool中chunk的信息

Name Null ? Type
--------------------------------------------------- -- -------- ------------------
ADDR RAW ( 4 )
INDX NUMBER
INST_ID NUMBER
KSMCHIDX NUMBER
KSMCHDUR NUMBER
KSMCHCOM VARCHAR2 ( 16 )
KSMCHPTR RAW ( 4 )
KSMCHSIZ NUMBER
KSMCHCLS VARCHAR2 ( 8 ) ##shared pool 的chunk的类型，如R-free，R-freea，free，freeabl，perm，recr

KSMCHTYP NUMBER
KSMCHPAR RAW ( 4 )

5.X$KCCCP——[K]ernel [C]ache [C]ontrolfile management [c]heckpoint [p]rogress

sys @ ORALOCAL ( 192.168.0.22 ) > desc X $ KCCCP ##主要查看checkpoint的heartbeat

Name Null ? Type
--------------------------------------------------- -- -------- --------------
ADDR RAW ( 4 )
INDX NUMBER
INST_ID NUMBER
CPTNO NUMBER
CPSTA NUMBER
CPFLG NUMBER
CPDRT NUMBER
CPRDB NUMBER
CPLRBA_SEQ NUMBER
CPLRBA_BNO NUMBER
CPLRBA_BOF NUMBER
CPODR_SEQ NUMBER
CPODR_BNO NUMBER
CPODR_BOF NUMBER
CPODS VARCHAR2 ( 16 )
CPODT VARCHAR2 ( 20 )
CPODT_I NUMBER
CPHBT NUMBER ##checkpoint的心跳，每隔3秒变化一次，并且写入到控制文件中。

CPRLS VARCHAR2 ( 16 )
CPRLC NUMBER
CPMID NUMBER
CPSDR_SEQ NUMBER
CPSDR_BNO NUMBER
CPSDR_ADB NUMBER

6.X$KSMLRU——[K]ernal [S]torage [M]emory Management [LRU]

sys @ ORALOCAL ( 192.168.0.22 ) > desc X $ KSMLRU ##looking for the cause of memory allocations in the shared pool

Name Null ? Type
--------------------------------------------------- -- -------- ---------------
ADDR RAW ( 4 )
INDX NUMBER
INST_ID NUMBER
KSMLRIDX NUMBER
KSMLRDUR NUMBER
KSMLRCOM VARCHAR2 ( 20 )
KSMLRSIZ NUMBER
KSMLRNUM NUMBER ##Number of items flushed from the shared pool

KSMLRHON VARCHAR2 ( 32 )
KSMLROHV NUMBER
KSMLRSES RAW ( 4 ) ##Session performing the allocation.Join to V$SESSION.SADDR

7.X$KSQRS——[K]ernel [S]ervice en[Q]ueue [R]e[S]ource

sys @ ORALOCAL ( 192.168.0.22 ) > desc X $ KSQRS ##查找由于受到enqueue lock的数据库资源
sys @ ORALOCAL ( 10.1.19.13 ) > desc X $ KSQRS
名称 是否为空? 类型
--------------------------------------------------- -- -------- ----------------
ADDR RAW ( 4 )
INDX NUMBER
INST_ID NUMBER
KSQRSID1 NUMBER
KSQRSID2 NUMBER
KSQRSIDT VARCHAR2 ( 2 )
KSQRSFLG NUMBER

8.X$KGLLK——[K]ernel [G]eneric [L]ibrary Cache Manager object [L]oc[K]s

SQL > desc X $ KGLLK ##主要用来查看library cache 的对象的锁

名称 是否为空? 类型
--------------------------------------- -- -------- ----------------------------
ADDR RAW ( 4 )
INDX NUMBER
INST_ID NUMBER
KGLLKADR RAW ( 4 )
KGLLKUSE RAW ( 4 ) ##关联v$session的saddr这一列，即session的地址。

KGLLKSES RAW ( 4 )
KGLLKSNM NUMBER ##关联v$session的sid

KGLLKHDL RAW ( 4 ) ##关联v$session_wait的p1raw列，表明library cache lock的锁地址。也对应于x$kglob的kglhdadr这一列。

KGLLKPNC RAW ( 4 )
KGLLKPNS RAW ( 4 )
KGLLKCNT NUMBER
KGLLKMOD NUMBER ##代表的锁”占用”模式，0-> ‘None’, 1->’Null’, 2-> ‘Share’, 3-> ‘Exclusive’,其它值->’Unknown’

KGLLKREQ NUMBER ##代表”请求”模式,0-> ‘None’, 1->’Null’, 2-> ‘Share’, 3-> ‘Exclusive’,其它值->’Unknown’,另一个角度说明0->lock的占有者,其它->锁的请求者。

KGLLKFLG NUMBER
KGLLKSPN NUMBER
KGLLKHTB RAW ( 4 )
KGLNAHSH NUMBER
KGLLKSQLID VARCHAR2 ( 13 )
KGLHDPAR RAW ( 4 )
KGLHDNSP NUMBER
USER_NAME VARCHAR2 ( 30 )
KGLNAOBJ VARCHAR2 ( 60 ) ##包含了在librarky cache中的对象上执行命令的语句的前80个字符。

9.X$KTSSO——[K]ernal [T]ransaction [S]ort [S]egment

SQL > desc X $ KTSSO ##主要用来查看占据temp表空间的session sid
-- 9 i 的： Name Null ? Type
--------------------------------------------------- -- -------- ------
ADDR RAW ( 8 )
INDX NUMBER
INST_ID NUMBER
KTSSOSES RAW ( 8 ) ##对应v$session的saddr

KTSSOSNO NUMBER
KTSSOTSN VARCHAR2 ( 31 )
KTSSOCNT NUMBER
KTSSOSEGT NUMBER ##表示占据temp段的类型:1,SORT/2,HASH/ 3,DATA,/4,INDEX/5, LOB_DATA/6, LOB_INDEX/UNDEFINED

KTSSOFNO NUMBER
KTSSOBNO NUMBER
KTSSOEXTS NUMBER
KTSSOBLKS NUMBER ##占据的temp段的block数，注意如果是temporary table，也在此显示，显示结果也为TEMP

KTSSORFNO NUMBER

-- 10 g 的：
名称 是否为空? 类型
--------------------------------------- -- -------- ----------------------------
ADDR RAW ( 4 )
INDX NUMBER
INST_ID NUMBER
KTSSOSES RAW ( 4 )
KTSSOSNO NUMBER
KTSSOTSN VARCHAR2 ( 31 )
KTSSOCNT NUMBER
KTSSOSEGT NUMBER
KTSSOFNO NUMBER
KTSSOBNO NUMBER
KTSSOEXTS NUMBER
KTSSOBLKS NUMBER
KTSSORFNO NUMBER
KTSSOOBJD NUMBER
KTSSOOBJN NUMBER ##对应的dba_objects中的object id

KTSSOTSNUM NUMBER

附：X$表命名规则：

** INTERNAL ONLY **

This is a summary list of X$ Table Definitions - Last revision was 7.3.2
The main purpose of this note is to show the naming conventions.

[K]ernel Layer
[2]-Phase Commit
[G]lobal [T]ransaction [E]ntry
X$K2GTE - Current 2PC tx
X$K2GTE2 - Current 2PC tx
[C]ache Layer
[B]uffer Management
Buffer [H]ash
X$BH - Hash Table
Buffer LRU Statistics
X$KCBCBH - [C]urrent [B]uffers (buckets) - lru_statistics
X$KCBRBH - [R]ecent [B]uffers (buckets) - lru_extended
Buffer [WAIT]s
X$KCBWAIT - Waits by block class
X$KCBFWAIT - Waits by File
[W]orking Sets - 7.3 or higher
X$KCBWDS - Set [D]escriptors
[C]ontrol File Management
[C]ontrol [F]ile List - 7.0.16 or higher
X$KCCCF - Control File Names & status
[D]atabase [I]nformation
X$KCCDI - Database Information
Data [F]iles
X$KCCFE - File [E]ntries ( from control file )
X$KCCFN - [F]ile [N]ames
[L]og Files
X$KCCLE - Log File [E]ntries
X$KCCLH - Log [H]istory ( archive entries )
Thread Information
X$KCCRT - [R]edo [T]hread Information
[F]ile Management
X$KCFIO - File [IO] Statistics
[L]ock Manager Component ( LCK )
[H]ash and Bucket Tables - 7.0.15 to 7.1.1, and 7.2.0 or higher
X$KCLFH - File [H]ash Table
X$KCLFI - File Bucket Table
X$LE - Lock [E]lements
X$LE_STAT - Lock Conversion [STAT]istics
X$KCLFX - Lock Element [F]ree list statistics - 7.3 or higher
X$KCLLS - Per LCK free list statistics - 7.3 or higher
X$KCLQN - [N]ame (hash) table statistics - 7.3 or higher
[R]edo Component
[M]edia recovery - kcra.h - 7.3 or higher
X$KCRMF - [F]ile context
X$KCRMT - [T]hread context
X$KCRMX - Recovery Conte[X]t
[F]ile read
X$KCRFX - File Read Conte[X]t - 7.3 or higher
Reco[V]ery Component
[F]ile [H]eaders
X$KCVFH - All file headers
X$KCVFHMRR - Files with [M]edia [R]ecovery [R]equired
X$KCVFHONL - [ONL]ine File headers
[K]ompatibility Management - 7.1.1 or higher
X$KCKCE - [C]ompatibility Segment [E]ntries
X$KCKTY - Compatibility [TY]pes
X$KCKFM - Compatibility [F]or[M]ats ( index into X$KCKCE )
[D]ata Layer
Sequence [N]umber Component
X$KDNCE - Sequence [C]ache [E]ntries - 7.2 or lower
[S]equence Enqueues - common area for enqueue objects
X$KDNSSC - [C]ache Enqueue Objects - 7.2 or lower
X$KDNSSF - [F]lush Enqueue Objects - 7.2 or lower
X$KDNST - Cache [ST]atistics - 7.2 or lower
Inde[X] Block Component
X$KDXHS - Index [H]i[S]togram
X$KDXST - Index [ST]atistics
[G]eneric Layer
[H]eap Manager
X$KGHLU - State (summary) of [L]R[U] heap(s) - defined in ksmh.h
[I]nstantiation Manager
[C]ursor [C]ache
X$KGICC - Session statistics - defined in kqlf.h
X$KGICS - System wide statistics - defined in kqlf.h
[L]ibrary Cache Manager ( defined and mapped from kqlf )
Bind Variables
X$KKSBV - Library Object [B]ind [V]ariables
Object Cache
X$KGLOB - All [OB]jects
X$KGLTABLE - Filter for [TABLE]s
X$KGLBODY - Filter for [BODY] ( packages )
X$KGLTRIGGER - Filter for [TRIGGER]s
X$KGLINDEX - Filter for [INDEX]es

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

0

0

分享到：

上一篇： 坏块快速恢复

下一篇： dbms_session.free_unused_user_memory; 可以释放 部分的PGA内存

请登录后发表评论 登录

全部评论

<%=items[i].createtime%>

<%=items[i].content%>

<%if(items[i].items.items.length) { %>

<%for(var j=0;j

<%=items[i].items.items[j].createtime%> 回复

<%=items[i].items.items[j].username%>   回复   <%=items[i].items.items[j].tousername%>： <%=items[i].items.items[j].content%>

<%}%> <%if(items[i].items.total > 5) { %>

还有<%=items[i].items.total-5%>条评论 ) data-count=1 data-flag=true>点击查看

<%}%>

<%}%>

<%}%>

转载于:http://blog.itpub.net/9879835/viewspace-1050618/