List of X$ Tables and how the names are derived

导读：

　　X$表名太不容易记忆了，记录一下备查

　　[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

　　X$KGLCLUSTER - Filter for [CLUSTER]s

　　X$KGLCURSOR - Filter for [CURSOR]s

　　Cache Dependency

　　X$KGLDP - Object [D]e[P]endency table

　　X$KGLRD - [R]ead only [D]ependency table - 7.3 or higher

　　Object Locks

　　X$KGLLK - Object [L]oc[K]s

　　Object Names

　　X$KGLNA - Object [NA]mes (sql text)

　　X$KGLNA1 - Object [NA]mes (sql text) with newlines - 7.2.0 or higher

　　Object Pins

　　X$KGLPN - Object [P]i[N]s

　　Cache Statistics

　　X$KGLST - Library cache [ST]atistics

　　Translation Table

　　X$KGLTR - Address [TR]anslation

　　Access Table

　　X$KGLXS - Object Access Table

　　Authorization Table - 7.1.5 or higher

　　X$KGLAU - Object Authorization table

　　Latch Cleanup - 7.0.15 or higher

　　X$KGLLC - [L]atch [C]leanup for Cache/Pin Latches

　　[K]ompile Layer

　　[S]hared Objects

　　X$KKSAI - Cursor [A]llocation [I]nformation - 7.3.2 or higher

　　[L]oader

　　[L]ibrary

　　X$KLLCNT - [C]o[NT]rol Statistics

　　X$KLLTAB - [TAB]le Statistics

　　[M]ulti-Threaded Layer

　　[C]ircuit component

　　X$KMCQS - Current [Q]ueue [S]tate

　　X$KMCVC - [V]irtual [C]ircuit state

　　[M]onitor Server/dispatcher

　　[D]ispatcher

　　X$KMMDI - [D]ispatcher [I]nfo (status)

　　X$KMMDP - [D]ispatcher Config ( [P]rotocol info )

　　[S]erver

　　X$KMMSI - [S]erver [I]nfo ( status )

　　X$KMMSG - [SG]a info ( global statistics)

　　X$KMMRD - [R]equest timing [D]istributions

　　s[Q]l Version and Option Layer

　　Kernel [V]ersions

　　X$VERSION - Library versions

　　Kernel [O]ptions - 7.1.3 or higher

　　X$OPTION - Server Options

　　[Q]uery Layer

　　[D]ictionary Cache Management

　　X$KQDPG - [PG]a row cache cursor statistics

　　[F]ixed Tables/views Management

　　X$KQFCO - Table [CO]lumn definitions

　　X$KQFDT - [D]erived [T]ables

　　X$KQFSZ - Kernel Data structure type [S]i[Z]es

　　X$KQFTA - Fixed [TA]bles

　　X$KQFVI - Fixed [VI]ews

　　X$KQFVT - [V]iew [T]ext definition - 7.2.0 or higher

　　[R]ow Cache Management

　　X$KQRST - Cache [ST]atistics

　　X$KQRPD - [P]arent Cache [D]efinition - 7.1.5 or higher

　　X$KQRSD - [S]ubordinate Cache [D]efinition - 7.1.5 or higher

　　[S]ervice Layer

　　[B]ackground Management

　　[D]etached Process

　　X$KSBDD - Detached Process [D]efinition (info)

　　X$KSBDP - Detached [P]rocess Descriptor (name)

　　X$MESSAGES - Background Message table

　　[I]nstance [M]anagement - 7.3 or higher

　　X$KSIMAT - Instance [AT]tributes

　　X$KSIMAV - [A]ttribute [V]alues for all instances

　　X$KSIMSI - [S]erial and [I]nstance numbers

　　[L]ock Management

　　[E]vent Waits

　　X$KSLED - Event [D]escriptors

　　X$KSLEI - [I]nstance wide statistics since startup

　　X$KSLES - Current [S]ession statistics

　　[L]atches

　　X$KSLLD - Latch [D]escriptor (name)

　　X$KSLLT - Latch statistics [ + Child latches @ 7.3 or higher ]

　　X$KSLLW - Latch context ( [W]here ) descriptors - 7.3 or higher

　　X$KSLPO - Latch [PO]st statistics - 7.3 or higher

　　X$KSLWSC- No[W]ait and [S]leep [C]ount stats by Context -7.3 or higher

　　[M]emory Management

　　[C]ontext areas

　　X$KSMCX - E[X]tended statistics on usage - 7.3.1 or lower

　　Heap Areas

　　X$KSMSP - SGA Hea[P]

　　X$KSMPP - [P]GA Hea[P] - 7.3.2 and above

　　X$KSMUP - [U]GA Hea[P] - 7.3.2 and above

　　X$KSMHP - Any [H]ea[P] - 7.3.2 and above

　　X$KSMSPR- [S]hared [P]ool [R]eserved List - 7.1.5 or higher

　　[L]east recently used shared pool chunks

　　X$KSMLRU - LR[U] flushes from the shared pool

　　[S]GA Objects

　　X$KSMSD - Size [D]efinition for Fixed/Variable summary

　　X$KSMSS - Statistics (lengths) of SGA objects

　　SGA [MEM]ory

　　X$KSMMEM - map of the entire SGA - 7.2.0 or higher

　　X$KSMFSV - Addresses of [F]ixed [S]GA [V]ariables - 7.2.1 or higher

　　[P]arameter Component

　　X$KSPPI - [P]arameter [I]nfo ( Names )

　　X$KSPPCV - [C]urrent Session [V]alues - 7.3.2 or above

　　X$KSPPSV - [S]ystem [V]alues - 7.3.2 or above

　　En[Q]ueue Management

　　X$KSQDN - Global [D]atabase [N]ame

　　X$KSQEQ - [E]n[Q]ueue Object

　　X$KSQRS - Enqueue [R]e[S]ource

　　X$KSQST - Enqueue [S]tatistics by [T]ype

　　[U]ser Management

　　[C]ost

　　X$KSUCF - Cost [F]unction (resource limit)

　　[L]icence

　　X$KSULL - Licence [L]imits

　　[L]anguage Manager

　　X$NLS_PARAMETERS - NLS parameters

　　X$KSULV - NLS [V]alid Values - 7.1.2 or higher

　　[MY] [ST]atistics

　　X$KSUMYSTA - [MY] [ST]atisics (current session)

　　[P]rocess Info

　　X$KSUPL - Process (resource) [L]imits

　　X$KSUPRLAT - [LAT]ch Holder

　　X$KSUPR - Process object

　　[R]esource

　　X$KSURU - Resource [U]sage

　　[S]tatistics

　　X$KSUSD - [D]escriptors (statistic names)

　　X$KSUSGSTA - [G]lobal [ST]atistics

　　[SE]ssions

　　X$KSUSECST - Session status for events

　　X$KSUSESTA - Session [STA]tistics

　　X$KSUSECON - [CON]nection Authentication - 7.2.1 or higher

　　X$KSUSE - [SE]ssion Info

　　X$KSUSIO - [S]ystem [IO] statistics per session

　　[T]imer

　　X$KSUTM - Ti[M]e in 1/100th seconds

　　Instance [X]

　　X$KSUXSINST - [INST]ance state

　　[T]race management

　　X$TRACE - Current traced events

　　X$TRACES - All possible traces

　　X$KSTEX - Code [EX]ecution - 7.2.1 or higher

　　E[X]ecution Management

　　Device/Node [A]ffinity - 7.3.2 and above

　　X$KSXAFA - Current File/Node Affinity

　　[T]ransaction Layer

　　Table [A]ccess [D]efinition

　　X$KTADM - D[M]L lock

　　[C]ontrol Component

　　X$KTCXB - Transaction O[B]ject

　　[S]or[T] Segments - 7.3 or higher

　　X$KTSTSSD - [S]ort [S]egment [D]escriptor - per tablespace statistics

　　[T]ablespace

　　X$KTTVS - [V]alid [S]aveundo

　　[U]ndo

　　X$KTURD - Inuse [D]escriptors

　　X$KTUXE - Transaction [E]ntry (table) - 7.3.2 or above

　　Performance Layer [V] - 7.0.16 or higher

　　[I]nformation tables

　　X$KVII - [I]nitialisation Instance parameters

　　X$KVIS - [S]izes of structure elements

　　X$KVIT - [T]ransitory Instance parameters

　　Security Layer [Z]

　　[D]ictionary Component

　　X$KZDOS - [OS] roles

　　[S]ecurity State

　　X$KZSPR - Enabled [PR]ivileges

　　X$KZSRO - Enabled [RO]les

　　[R]emote Logins - 7.1.1 or higher

　　X$KZSRT - [R]emote Password File [T]able entries

　　E[X]ecution Layer

　　Parallel Query (Execute [F]ast) - 7.1.1 or higher

　　[P]rocess and Queue Manager

　　Statistics - 7.1.3 or higher

　　X$KXFPYS - S[YS]tem Statistics

　　X$KXFPDP - [D]etached [P]rocess (slave) statistics

　　X$KXFQSROW - Table [Q]ueue Statistics - 7.3.2 or higher

　　[C]oordinator Component

　　X$KXFPCST - Query [ST]atistics

　　X$KXFPCMS - [M]essage [S]tatistics

　　X$KXFPCDS - [D]equeue [S]tatistics

　　[S]lave Component

　　X$KXFPSST - Query [ST]atistics

　　X$KXFPSMS - [M]essage [S]tatistics

　　[S]hared Cursor

　　X$KXSBD - [B]ind [D]ata - 7.3.2 and above

　　X$KXSCC - SQL [C]ursor [C]ache Data - 7.3.2 and above

　　[N]etwork Layer - 7.0.15 or higher

　　Network [CO]nnections

　　X$UGANCO - Current [N]etwork [CO]nnections

本文转自

<a href="http://woodnan.itpub.net/post/37055/457769">http://woodnan.itpub.net/post/37055/457769</a>