X$ Table

http://www.orafaq.com/wiki/X$_Table_Definitions

http://yong321.freeshell.org/computer/x$table.html

 

 [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

           X$KXFPCDS - [D]equeue [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