Oracle Internal X$Tables

Oracle Internal X$Tables

  • x$kcbsw kernel cache, buffer statistics why

Note:34405.1 (select kcbwhdes, why0+why1+why2 "Gets", "OTHER_WAIT" from x$kcbsw s, x$kcbwh w where s.indx=w.indx and s."OTHER_WAIT">0 order by 3), Ref1 ("statistics about the way these [x$kcbwh] functions have been used")

  • x$k2gte Kernel 2-phase commit, Global Transaction Entry

Mark Bobak's query (originally in Metalink forum thread 524821.994, where he further attributed authorship) uses this table to find sessions coming from or going to a remote database; in short, x$k2gte.k2gtdses matches v$session.saddr, .k2gtdxcb matches v$transaction.addr. It's more robust than this query, and better than checking for DX locks for outgoing sessions (since a DX lock only shows up in v$lock for the current distributed transaction session).

  • x$kcbbf Kernel Cache, Buffer ?? Ref1 ("_db_handles")
  • x$kcbfwait kernel cache, buffer file wait

A commonly used query breaks down the contents of v$waitstat into per-datafile statistics: select count, time, name from v$datafile df, x$kcbfwait fw where fw.indx+1 = df.file#

  • x$kcbwait kernel cache, buffer wait
  • x$kcbwds kernel cache, buffer working descriptors
  • x$kcbwh kernel cache, buffer ??

See x$kcbsw for SQL. Ref1 ("different functions that may be used to perform different types of logical I/O"), Ref2

  • x$kcccf kernel cache, controlfilemanagement control file

In 10gR1, to find controlfile size as viewed at OS level but from inside Oracle, select cfnam, (cffsz+1)*cfbsz from x$kcccf. cfbsz is the controlfile log block size; should report the same as the command dbfsize controlfile ($ORACLE_HOME/bin/dbfsize is available on UNIX, regardless Oracle version.) In 10gR2, block size and file size are both in v$controlfile although Reference manual misses them.

  • x$kcccp kernel cache, controlfile checkpoint progress

S. Adams and K Gopalakrishnan use this view to find how much the current redo log is filled.

  • x$kccdi kernel cache, controlfilemanagement database information
  • x$kccle kernel cache, controlfile logfile entry

lebsz may be used to show redo logfile block size, usually 512; should report the same as the command dbfsize redologfile ($ORACLE_HOME/bin/dbfsize is available on UNIX only)

  • x$kcfio kernel cache, file I/O
  • x$kclcrst kernel cache, lock, consistent read statistics

base table of v$cr_block_server or v$bsp, used to troubleshoot global cache cr requests

  • x$kclfh kernel cache, lock file header
  • x$kclfi kernel cache, lock file index
  • x$kcluh kernel cache, lock undo header
  • x$kclui kernel cache, lock undo index
  • x$kcrfx kernel cache, redo file context "columns bfs (buffer size) and bsz (block size). Dividing bfs by bsz gives mxr (the maximum number of blocks to read size)" (from Anjo Kolk's paper)
  • x$kdxst kernel data, index status used in catalog.sql to create index_stats
  • x$kdxhs kernel data, index histogram used in catalog.sql to create index_histogram
  • x$kghlu kernel generic, heap LRUs
  • x$kglcursor kernel generic, librarycache cursor

Base table for v$sql, v$sqlarea. Fixed view based on x$kglob according to x$kqfdt. See Note 1 or x$kglob for more details. One use of this table is for finding partially parsed SQLs because they cause parse failures (viewable in v$sysstat or v$sesstat). Their kglobt02 (command type) is 0, kglobt09 (child number) is 65535 for the child, SQL text length is cut to 20 chars, kglobt17 and kglobt18 (parsing and user schema) are 0 or 2147483644 (for 32-bit Oracle) depending on if it's parent or child, and obviously miss heap 6 (cursor body). Find them by select kglnaobj, kglnatim, kglobts0, kglnahsh from x$kglcursor where kglobt02 = 0 (kglobts0 is module; you can further restrict by kglnatim i.e. first_load_time).

  • x$kgllk kernel generic, librarycache lock

Used in catblock.sql to build dba_kgllock. If you get library cache lock or pin wait, kgllkhdl matches v$session_wait.p1raw (handle address), and kglnaobj is the first 80 characters of the object name. Note:122793.1 has this SQL for our convenience: select * from x$kgllk lock_a where kgllkreq = 0 and exists (select lock_b. kgllkhdl from x$kgllk lock_b where kgllkses = '&saddr_from_v$session' /* blocked session */ and lock_a.kgllkhdl = lock_b.kgllkhdl and kgllkreq > 0). Kgllkadr column is shown in event 10270 trace files to find SQLs in session cursor cache (Ref)

  • x$kglob kernel generic, librarycache object

To find library cache object for wait events library cache pin or lock and pipe get or put, match kglhdadr with v$session_wait.p1raw. kglhdflg is partially explained in Note:311689.1 (for permanent keeping). kglhddmk may be data object load mask; can be used to identify the number of the loaded heap, counted from 0 (see comment of 06/12/01 in Bug:1164709). Steve Adams' objects_on_hot_latches.sql finds the way Oracle links a library cache object (based on kglnahsh) to a specific library cache child latch. x$kglob, and in case of cursors x$kglcursor too, can be used to find library cache objects that are partially built therefore not visible in v$sql(XXX), v$open_cursor, v$object_dependency. (Try typing select *; and enter, then check these views!)

  • x$kglpn kernel generic, librarycache pin

used in catblock.sql to build dba_kgllock

  • x$kglrd kernel generic, librarycache readonly dependency

kglnacnm is PL/SQL program unit or anonymous block while kglnadnm is the individual SQLs inside the PL/SQL unit. (see Ref; see also v$object_dependency, but that doesn't show relation between PL/SQL block and its contents)

  • x$kglst kernel generic, librarycache status
  • x$kqfco kernel query, fixed table columns x$kqfco.kqfcotab=x$kqfta.indx
  • x$kqfta kernel query, fixed table
  • x$kqfdt kernel query, fixed derived table

acronym explained by Julian Dyke: it contains x$kglcursor, x$kgltable etc. which are based on

  • x$kglob; effectively these are views of other x$ tables, but Oracle couldn't call them views because they already had x$kqfvi
  • x$kqfp kernel query, fixed procedure used in catprc.sql to build disk_and_fixed_objects view
  • x$kqfsz kernel query, fixed size (size of fixed objects in current version of Oracle)
  • x$kqfvi kernel query, fixed view
  • x$kqfvt kernel query, fixed view table (how fixed view is built on fixed tables)
  • x$ksled, x$kslei, x$ksles kernel service, event definition, events for instance, events for session, respectively ("l" probably means "lock")
  • x$kslpo kernel service, latch posting

Note:653299 says it "tracks which function is posting smon". Ksllwnam column (the part before semicolon if it exists) can match v$latch_misses.location to identify the latch that uses this function.

  • x$ksmfs kernel service, memory fixed SGA

also contains db_block_buffers and log_buffer sizes for some reason

  • x$ksmfsv kernel service, memory fixed SGA variables

detailing fixed SGA: select a.ksmfsnam, a.ksmfstyp, a.ksmfssiz, b.ksmmmval from x$ksmfsv a, x$ksmmem b where a.ksmfsadr = b.addr and a.ksmfsnam like… (Ref. p.82, Oracle Internal Services). For a latch, get ksmfsnam by matching x$ksmfsv.ksmfadr with x$kslld.kslldadr. You can see SGA parameters in ksmfsnam column and get their values with oradebug dumpvar varname or all values with oradebug dumpsga

  • x$ksmhp kernel service, memory heap

S. Adams, "What it returns depends on which heap descriptor you join to it. It is effectively a function returning the contents of an arbitrary heap that takes the heap descriptor as its argument."

  • x$ksmjs kernel service, memory java_pool summary
  • x$ksmlru kernel service, memory LRU

Refer to Metalink Notes 61623.1 and 43600.1 for details. Note that query on this table can only be done once; subsequent query returns no rows unless large chunk shared pool allocations happened in the interim.

  • x$ksmls kernel service, memory large_pool summary
  • x$ksmmem kernel service, memory

Entire SGA memory map. You can find your database version by select ksmmmval from x$ksmmem where indx = 2 (if it's 64-bit Oracle, try 1), regardless machine architecture endian-ness. Note that the 4 bytes containing the version are delimited as XX.X.XX.X.XX so 09200300 is 9.2.0.3.0. Due to memory guard pages, you can only select from x$ksmmem specifying rownum < some number or indx = some value; otherwise the session may hang or throws ORA-3113 (Windows doesn't seem to have this problem). indx is SGA index, i.e. SGA address minus sgabeg (which is x$ksmmem.addr where indx = 0) divided by 4 (or whatever the gap is between two addr's), possibly plus some offset.

  • x$ksmpp kernel service, memory pga heap

PGA heap (variable area)

  • x$ksmsd kernel service, memory sga definition
  • x$ksmsp kernel service, memory sga heap

The 3rd argument of ORA-4031 tells you which section of shared (or java or large) pool is short of memory. It matches x$ksmsp.ksmchcom (or v$sgastat.name).

  • x$ksmspr kernel service, memory shared pool reserved
  • x$ksmss kernel service, memory shared_pool summary

The 3rd argument of ORA-4031 tells you which section of shared (or java or large) pool is short of memory. It matches x$ksmss.ksmssnam (or v$sgastat.name).

  • x$ksmup kernel service, memory uga heap

UGA heap (variable area)

  • x$ksppcv kernel service, parameter, current (session) value

Base table of v$parameter and v$parameter2. See comments on x$ksppi.

  • x$ksppi kernel service, parameter, parameter info

Base table of v$parameter, v$system_parameter and v$system_parameter2. Often used to see undocumented parameters: select a.ksppinm Parameter, a.ksppdesc Description, b.ksppstvl "Session Value", c.ksppstvl "Instance Value" from x$ksppi a, x$ksppcv b, x$ksppsv c where a.indx = b.indx and a.indx = c.indx and a.ksppinm like '\_%' escape '\' order by 1

  • x$ksppsv kernel service, parameter, system value

Base table of v$system_parameter and v$system_parameter2. See comments on x$ksppi.

  • x$ksqeq kernel service, enqueue en-queue
  • x$ksqrs kernel service, enqueue resource

"shows all outstanding enqueues with an additional flag. It basically shows the same information as the v$lock table." from Note1, which also gives the meanings of the flags.

  • x$ksqst kernel service, enqueue_management statistics types

Acronym explained by K Gopalakrishnan. You can find how many times each type of enqueue lock has been taken since instance startup by select * from x$ksqst where ksqstget > 0 or in 9i select * from x$ksqst where ksqstsgt > 0 or ksqstfgt > 0. But v$enqueue_stat in 9i can also be used instead.

  • x$ksulv kernel service, user locale value
  • x$ksulop kernel service, user long operation
  • x$ksupr kernel service, user process
  • x$ksuse kernel service, user session
  • x$ktcxb kernel transaction, control object

Base table of v$transaction. 4 bits of ktcxbflg column, exposed as v$transaction.flag, are explained in v$fixed_view_definition. Metalink 238763.996 explains the bit for isolation level. Since v$transaction is empty without a transaction, you can directly query x$ktcxb to find sessions with serializable isolation level: select * from v$session where taddr in (select ktcxbxba from x$ktcxb where bitand(ktcxbflg,268435456) <> 0). Other flags not shown in v$fixed_view_definition are: 1 read write and read committed, 4 read only.

  • x$ktfbfe kernel transaction, file bitmap free extent

Free extent bitmap in file header for LMT (equivalent to fet$ in DMT); check dba_free_space view definition

  • x$ktfbhc kernel transaction, file bitmap ? ?

Summarizes free space with one row per datafile (Ref); check dba_data_files or dba_temp_files view definition

  • x$ktfbue kernel transaction, file bitmap used extent

Used extent bitmap in file header for LMT (equivalent to uet$ in DMT)

  • x$ktuxe kernel transaction, undo transaction entry

Steve Adams says, you "get the SCN of the most recently committed (local) transaction" with select max(ktuxescnw * power(2, 32) + ktuxescnb) from x$ktuxe

  • x$kxfpsds kernel execution, fast process slave dequeue statistics

Current list of reasons for parallel execution dequeuing, as explained for wait event "parallel query dequeue wait" in Anjo Kolk's paper.

  • x$kzsprv kernel security, session privilege

Session-specific. Base table for v$enabledprivilege, which is base table of session_privs

  • x$kzsro kernel security, session role

used in many SQL scripts in ?/rdbms/admin

  • x$le lock element To find the buffer header in the cache, select a.* from x$bh a, x$le b where a.le_addr = b.addr (from Anjo Kolk's paper)
  • x$le_stat lock element status
  • x$message (background process) messages

This records (possibly) all actions each background process can do.

  • x$trace Beginning with 9i, x$trace records event tracing info.

select event, count(*) from x$trace group by event shows what events are enabled internally (not shown in v$parameter). oerr ora eventID on UNIX shows the event name. RAC databases should have GES and GCS related events set. select pid, count(*) from x$trace group by pid shows how many events have been trapped by each oracle process (including those that exited). select sid, pid, count(*) from x$trace where (sid, pid) in (select sid, pid from v$session s, v$process p where s.paddr = p.addr) group by sid, pid order by 1, 2 shows the numbers for each currently existing session (I think without the where clause, exited sessions would be included). select event, op, time, seq#, data from x$trace where sid = &sid and pid = &pid order by time shows traced events for a session in question.

  • x$uganco user global area, network connection Base table of v$dblink.

Since it's about UGA, each session has different content. After you end your distributed transactions (which includes distributed queries) and close database links, v$dblink no longer shows the entries. But x$uganco still has them, with ncoflg set to 8320 and hstflg set to 0. These entries linger even after shared pool flush (or global context flush in 10g).

The format is shown as following:
Table Name Acronym Expanded
Comments

X$Table Name Meaning

Creation Date: 14-MAR-1995
Last Revision Date: 23-SEP-1999

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 (KGL = Kernel General Library 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

X$ Tables List

SQL> select * from v$fixed_table where name like 'X%' order by name;
 
NAME                            OBJECT_ID TYPE   TABLE_NUM
------------------------------ ---------- ----- ----------
X$ABSTRACT_LOB                 4294952581 TABLE        488
X$ACTIVECKPT                   4294951387 TABLE        221
X$ASH                          4294952043 TABLE        561
X$BH                           4294950954 TABLE        225
X$BUFFER                       4294952073 TABLE        505
X$BUFFER2                      4294952679 TABLE        504
X$BUFFERED_PUBLISHERS          4294952072 TABLE        503
X$BUFFERED_QUEUES              4294952070 TABLE        501
X$BUFFERED_SUBSCRIBERS         4294952071 TABLE        502
X$CKPTBUF                      4294951388 TABLE        222
X$CONTEXT                      4294951495 TABLE        425
X$DUAL                         4294951241 TABLE        418
X$ESTIMATED_MTTR               4294951668 TABLE        277
X$GLOBALCONTEXT                4294951685 TABLE        427
X$HOFP                         4294951606 TABLE        508
X$HS_SESSION                   4294951479 TABLE        507
X$INSTANCE_CACHE_TRANSFER      4294952150 TABLE        270
X$JOXFC                        4294951598 TABLE      65537
X$JOXFD                        4294951621 TABLE      65537
X$JOXFM                        4294951780 TABLE        441
X$JOXFR                        4294951599 TABLE      65537
X$JOXFS                        4294951597 TABLE      65537
X$JOXFT                        4294951596 TABLE        440
X$JSKJOBQ                      4294952128 TABLE        595
X$JSKSLV                       4294952116 TABLE        596
X$K2GTE                        4294951032 TABLE        430
X$K2GTE2                       4294951052 TABLE        429
X$KAUVRSTAT                    4294952130 TABLE        467
X$KCBBES                       4294951503 TABLE        220
X$KCBBF                        4294951246 TABLE        226
X$KCBBHS                       4294951429 TABLE        219
X$KCBFWAIT                     4294951081 TABLE        230
X$KCBKPFS                      4294951775 TABLE        224
X$KCBKWRL                      4294951613 TABLE        223
X$KCBLDRHIST                   4294951707 TABLE        274
X$KCBLSC                       4294951612 TABLE        275
X$KCBMMAV                      4294951824 TABLE        234
X$KCBOBH                       4294952086 TABLE        235
X$KCBOQH                       4294952087 TABLE        236
X$KCBSC                        4294951626 TABLE        231
X$KCBSDS                       4294951630 TABLE        233
X$KCBSH                        4294951629 TABLE        232
X$KCBSW                        4294951248 TABLE        228
X$KCBVBL                       4294951931 TABLE        330
X$KCBWAIT                      4294950955 TABLE        229
X$KCBWBPD                      4294951394 TABLE        218
X$KCBWDS                       4294951172 TABLE        217
X$KCBWH                        4294951247 TABLE        227
X$KCCAGF                       4294952049 TABLE        211
X$KCCAL                        4294951208 TABLE        196
X$KCCBF                        4294951211 TABLE        199
X$KCCBI                        4294951810 TABLE        207
X$KCCBL                        4294951212 TABLE        200
X$KCCBP                        4294951210 TABLE        198
X$KCCBS                        4294951209 TABLE        197
X$KCCCC                        4294951215 TABLE        203
X$KCCCF                        4294951110 TABLE        181
X$KCCCP                        4294951392 TABLE        276
X$KCCDC                        4294951213 TABLE        201
X$KCCDFHIST                    4294952133 TABLE        216
X$KCCDI                        4294951038 TABLE        183
X$KCCDI2                       4294951840 TABLE        184
X$KCCDL                        4294951216 TABLE        204
X$KCCFC                        4294951214 TABLE        202
X$KCCFE                        4294951039 TABLE        189
X$KCCFLE                       4294952037 TABLE        212
X$KCCFN                        4294951037 TABLE        191
X$KCCIC                        4294951906 TABLE        208
X$KCCIRT                       4294952048 TABLE        210
X$KCCLE                        4294951040 TABLE        187
X$KCCLH                        4294951042 TABLE        194
X$KCCNRS                       4294952659 TABLE        214
X$KCCOR                        4294951207 TABLE        195
X$KCCPA                        4294951560 TABLE        206
X$KCCPD                        4294951557 TABLE        205
X$KCCRDI                       4294952047 TABLE        209
X$KCCRM                        4294951669 TABLE        193
X$KCCRS                        4294951217 TABLE        182
X$KCCRSP                       4294952655 TABLE        213
X$KCCRSR                       4294952064 TABLE        215
X$KCCRT                        4294951041 TABLE        185
X$KCCSL                        4294951665 TABLE        188
X$KCCTF                        4294951460 TABLE        190
X$KCCTIR                       4294952471 TABLE        186
X$KCCTS                        4294951206 TABLE        192
X$KCFIO                        4294950957 TABLE        261
X$KCFIOHIST                    4294951974 TABLE        259
X$KCFTIO                       4294951521 TABLE        262
X$KCFTIOHIST                   4294952121 TABLE        260
X$KCKCE                        4294951122 TABLE        237
X$KCKFM                        4294951124 TABLE        239
X$KCKTY                        4294951123 TABLE        238
X$KCLCRST                      4294951504 TABLE        269
X$KCLCURST                     4294951774 TABLE        271
X$KCLFH                        4294951141 TABLE        265
X$KCLFI                        4294951142 TABLE        266
X$KCLFX                        4294951174 TABLE        263
X$KCLLS                        4294951173 TABLE        268
X$KCLQN                        4294951175 TABLE        264
X$KCLRCVST                     4294952020 TABLE        272
X$KCPXPL                       4294951988 TABLE        322
X$KCRFDEBUG                    4294952088 TABLE        257
X$KCRFSTRAND                   4294952164 TABLE        256
X$KCRFWS                       4294951809 TABLE        255
X$KCRFX                        4294951162 TABLE        258
X$KCRMF                        4294951160 TABLE        240
X$KCRMT                        4294951161 TABLE        241
X$KCRMX                        4294951163 TABLE        242
X$KCRRALG                      4294951814 TABLE        246
X$KCRRARCH                     4294951556 TABLE        248
X$KCRRASTATS                   4294952210 TABLE        251
X$KCRRDEST                     4294951242 TABLE        245
X$KCRRDGC                      4294951963 TABLE        244
X$KCRRDSTAT                    4294951650 TABLE        243
X$KCRRLNS                      4294951903 TABLE        249
X$KCRRMS                       4294951618 TABLE        247
X$KCRRNHG                      4294952209 TABLE        250
X$KCRRPTDGSTATS                4294952206 TABLE        254
X$KCRRPVRS                     4294952201 TABLE        253
X$KCTICW                       4294952476 TABLE        279
X$KCTLAX                       4294952474 TABLE        278
X$KCVFH                        4294951072 TABLE        281
X$KCVFHALL                     4294951440 TABLE      65537
X$KCVFHMRR                     4294951074 TABLE      65537
X$KCVFHONL                     4294951073 TABLE      65537
X$KCVFHTMP                     4294951522 TABLE        282
X$KDLT                         4294951512 TABLE        385
X$KDNSSF                       4294950965 TABLE        382
X$KDXHS                        4294950967 TABLE        384
X$KDXST                        4294950966 TABLE        383
X$KEACMDN                      4294952022 TABLE        565
X$KEAOBJT                      4294952021 TABLE        564
X$KEHECLMAP                    4294952517 TABLE        590
X$KEHEVTMAP                    4294952516 TABLE        589
X$KEHF                         4294952515 TABLE        587
X$KEHOSMAP                     4294952522 TABLE        592
X$KEHPRMMAP                    4294952520 TABLE        594
X$KEHR                         4294952512 TABLE        584
X$KEHRP                        4294952514 TABLE        586
X$KEHR_CHILD                   4294952513 TABLE        585
X$KEHSQT                       4294952521 TABLE        588
X$KEHSYSMAP                    4294952518 TABLE        591
X$KEHTIMMAP                    4294952519 TABLE        593
X$KELRSGA                      4294952703 TABLE        583
X$KELRTD                       4294952602 TABLE        581
X$KELRXMR                      4294952702 TABLE        582
X$KELTGSD                      4294952099 TABLE        544
X$KELTOSD                      4294952097 TABLE        542
X$KELTSD                       4294952098 TABLE        543
X$KEWAM                        4294952045 TABLE        563
X$KEWASH                       4294952044 TABLE        562
X$KEWECLS                      4294952568 TABLE        546
X$KEWEFXT                      4294952100 TABLE        545
X$KEWESMAS                     4294952572 TABLE        548
X$KEWESMS                      4294952569 TABLE        547
X$KEWMAFMV                     4294952422 TABLE        579
X$KEWMDRMV                     4294952413 TABLE        571
X$KEWMDSM                      4294952417 TABLE        577
X$KEWMEVMV                     4294952421 TABLE        575
X$KEWMFLMV                     4294952420 TABLE        574
X$KEWMGSM                      4294952418 TABLE        578
X$KEWMRSM                      4294952416 TABLE        576
X$KEWMRWMV                     4294952412 TABLE        570
X$KEWMSEMV                     4294952419 TABLE        572
X$KEWMSMDV                     4294952423 TABLE        580
X$KEWMSVCMV                    4294952425 TABLE        573
X$KEWRATTRNEW                  4294952426 TABLE        557
X$KEWRATTRSTALE                4294952427 TABLE        558
X$KEWRSQLCRIT                  4294952431 TABLE        556
X$KEWRSQLIDTAB                 4294951981 TABLE        553
X$KEWRTB                       4294951956 TABLE        549
X$KEWRTOPTENV                  4294952430 TABLE        555
X$KEWRTSEGSTAT                 4294952424 TABLE        560
X$KEWRTSQLPLAN                 4294952429 TABLE        554
X$KEWRTSQLTEXT                 4294952428 TABLE        559
X$KEWSSESV                     4294952566 TABLE        568
X$KEWSSMAP                     4294952564 TABLE        566
X$KEWSSVCV                     4294952567 TABLE        569
X$KEWSSYSV                     4294952565 TABLE        567
X$KEWXOCF                      4294951957 TABLE        550
X$KEWX_LOBS                    4294952147 TABLE        552
X$KEWX_SEGMENTS                4294952146 TABLE        551
X$KFALS                        4294951863 TABLE        524
X$KFBH                         4294952611 TABLE        527
X$KFCBH                        4294952608 TABLE        525
X$KFCCE                        4294952610 TABLE        526
X$KFCLLE                       4294952609 TABLE        541
X$KFDAT                        4294951859 TABLE        530
X$KFDPARTNER                   4294951979 TABLE        540
X$KFDSK                        4294951879 TABLE        528
X$KFDSK_STAT                   4294952649 TABLE        529
X$KFFIL                        4294951866 TABLE        538
X$KFFXP                        4294951869 TABLE        539
X$KFGMG                        4294951966 TABLE        533
X$KFGRP                        4294951876 TABLE        531
X$KFGRP_STAT                   4294952650 TABLE        532
X$KFKID                        4294951870 TABLE        534
X$KFKLIB                       4294952168 TABLE        535
X$KFNCL                        4294951871 TABLE        536
X$KFTMTA                       4294951860 TABLE        537
X$KGHLU                        4294951105 TABLE         64
X$KGICC                        4294951086 TABLE        406
X$KGICS                        4294951087 TABLE        408
X$KGLAU                        4294951112 TABLE        396
X$KGLBODY                      4294951057 TABLE      65537
X$KGLCLUSTER                   4294951060 TABLE      65537
X$KGLCURSOR                    4294951061 TABLE      65537
X$KGLCURSOR_CHILD              4294952683 TABLE      65537
X$KGLCURSOR_CHILD_SQLID        4294952684 TABLE      65537
X$KGLCURSOR_CHILD_SQLIDPH      4294952680 TABLE      65537
X$KGLDP                        4294951035 TABLE        401
X$KGLINDEX                     4294951059 TABLE      65537
X$KGLJMEM                      4294951997 TABLE         77
X$KGLJSIM                      4294951994 TABLE         75
X$KGLLC                        4294951108 TABLE        409
X$KGLLK                        4294950986 TABLE        393
X$KGLMEM                       4294951885 TABLE         76
X$KGLNA                        4294951064 TABLE        402
X$KGLNA1                       4294951150 TABLE        403
X$KGLOB                        4294950985 TABLE        392
X$KGLPN                        4294950987 TABLE        394
X$KGLRD                        4294951187 TABLE        400
X$KGLSIM                       4294951882 TABLE         74
X$KGLSN                        4294951379 TABLE        397
X$KGLST                        4294950988 TABLE        395
X$KGLTABLE                     4294951056 TABLE      65537
X$KGLTR                        4294951033 TABLE        398
X$KGLTRIGGER                   4294951058 TABLE      65537
X$KGLXS                        4294951034 TABLE        399
X$KGSKASP                      4294951571 TABLE        115
X$KGSKCFT                      4294951469 TABLE        119
X$KGSKCP                       4294951467 TABLE        113
X$KGSKDOPP                     4294951572 TABLE        116
X$KGSKPFT                      4294951470 TABLE        120
X$KGSKPP                       4294951468 TABLE        114
X$KGSKQUEP                     4294951701 TABLE        117
X$KGSKSCS                      4294952189 TABLE        122
X$KGSKTE                       4294951465 TABLE        111
X$KGSKTO                       4294951466 TABLE        112
X$KGSKVFT                      4294952667 TABLE        118
X$KJBL                         4294951614 TABLE        167
X$KJBLFX                       4294951615 TABLE        168
X$KJBR                         4294951616 TABLE        165
X$KJBRFX                       4294951617 TABLE        166
X$KJCTFR                       4294951928 TABLE        163
X$KJCTFRI                      4294951929 TABLE        164
X$KJCTFS                       4294951927 TABLE        162
X$KJDRHV                       4294951781 TABLE        171
X$KJDRMAFNSTATS                4294952142 TABLE        174
X$KJDRMHVSTATS                 4294952143 TABLE        175
X$KJDRMREQ                     4294952144 TABLE        176
X$KJDRPCMHV                    4294951784 TABLE        172
X$KJDRPCMPF                    4294951787 TABLE        173
X$KJICVT                       4294951421 TABLE        157
X$KJILFT                       4294951416 TABLE        156
X$KJILKFT                      4294951430 TABLE        158
X$KJIRFT                       4294951433 TABLE        159
X$KJISFT                       4294951415 TABLE        155
X$KJITRFT                      4294951603 TABLE        160
X$KJLEQFP                      4294952612 TABLE        154
X$KJMDDP                       4294951694 TABLE        170
X$KJMSDP                       4294951693 TABLE        169
X$KJREQFP                      4294952613 TABLE        153
X$KJXM                         4294951770 TABLE        161
X$KKSAI                        4294951197 TABLE        438
X$KKSBV                        4294951063 TABLE        404
X$KKSCS                        4294951623 TABLE        439
X$KKSSQLSTAT                   4294952660 TABLE        419
X$KKSSRD                       4294951776 TABLE        405
X$KLCIE                        4294951600 TABLE        470
X$KLPT                         4294951232 TABLE        469
X$KMCQS                        4294950970 TABLE        436
X$KMCVC                        4294950971 TABLE        437
X$KMGSBSADV                    4294952614 TABLE        180
X$KMGSCT                       4294951662 TABLE        177
X$KMGSOP                       4294951663 TABLE        179
X$KMGSTFR                      4294952192 TABLE        178
X$KMMDI                        4294950973 TABLE        432
X$KMMDP                        4294950975 TABLE        434
X$KMMRD                        4294950976 TABLE        435
X$KMMSG                        4294950974 TABLE        433
X$KMMSI                        4294950972 TABLE        431
X$KNGFL                        4294952119 TABLE        482
X$KNGFLE                       4294952668 TABLE        483
X$KNLAROW                      4294951991 TABLE        485
X$KNLASG                       4294952701 TABLE        486
X$KNSTACR                      4294951653 TABLE        476
X$KNSTASL                      4294951656 TABLE        477
X$KNSTCAP                      4294951837 TABLE        480
X$KNSTMVR                      4294951715 TABLE        479
X$KNSTRPP                      4294951721 TABLE        478
X$KNSTRQU                      4294951718 TABLE        481
X$KNSTTXN                      4294952698 TABLE        484
X$KOCST                        4294951374 TABLE        489
X$KQDPG                        4294951098 TABLE        391
X$KQFCO                        4294951036 TABLE          4
X$KQFDT                        4294950914 TABLE          3
X$KQFOPT                       4294952712 TABLE          5
X$KQFP                         4294951240 TABLE        417
X$KQFSZ                        4294951069 TABLE        416
X$KQFTA                        4294950912 TABLE          0
X$KQFVI                        4294950913 TABLE          1
X$KQFVT                        4294951149 TABLE          2
X$KQLFBC                       4294952034 TABLE        412
X$KQLFSQCE                     4294952031 TABLE        411
X$KQLFXPL                      4294951672 TABLE        410
X$KQLSET                       4294951230 TABLE        407
X$KQRFP                        4294951449 TABLE        389
X$KQRFS                        4294951450 TABLE        390
X$KQRPD                        4294951155 TABLE        387
X$KQRSD                        4294951156 TABLE        388
X$KQRST                        4294950989 TABLE        386
X$KRBAFF                       4294951455 TABLE        283
X$KRBMROT                      4294952067 TABLE        286
X$KRBMRST                      4294952063 TABLE        285
X$KRBMSFT                      4294952008 TABLE        284
X$KRBZA                        4294952709 TABLE        343
X$KRCBIT                       4294952016 TABLE        339
X$KRCCDE                       4294952011 TABLE        333
X$KRCCDR                       4294952131 TABLE        335
X$KRCCDS                       4294952012 TABLE        334
X$KRCEXT                       4294952010 TABLE        332
X$KRCFBH                       4294952015 TABLE        338
X$KRCFDE                       4294952014 TABLE        337
X$KRCFH                        4294952009 TABLE        331
X$KRCGFE                       4294952013 TABLE        336
X$KRCSTAT                      4294952109 TABLE        340
X$KRFBLOG                      4294952040 TABLE        341
X$KRFGSTAT                     4294952106 TABLE        342
X$KRFSTHRD                     4294952193 TABLE        252
X$KRVSLV                       4294951709 TABLE        323
X$KRVSLVAS                     4294952200 TABLE        327
X$KRVSLVPG                     4294952172 TABLE        325
X$KRVSLVS                      4294951712 TABLE        324
X$KRVSLVST                     4294952175 TABLE        326
X$KRVSLVTHRD                   4294952205 TABLE        328
X$KRVXDKA                      4294952132 TABLE        308
X$KRVXSV                       4294951832 TABLE        318
X$KRVXTHRD                     4294952195 TABLE        319
X$KRVXTX                       4294951647 TABLE        314
X$KRVXWNMESG                   4294952203 TABLE        321
X$KSBDD                        4294950991 TABLE         92
X$KSBDP                        4294950990 TABLE         91
X$KSBFT                        4294952690 TABLE         94
X$KSBTABACT                    4294952582 TABLE         95
X$KSFMCOMPL                    4294951823 TABLE        146
X$KSFMELEM                     4294951821 TABLE        144
X$KSFMEXTELEM                  4294951822 TABLE        145
X$KSFMFILE                     4294951818 TABLE        141
X$KSFMFILEEXT                  4294951819 TABLE        142
X$KSFMIOST                     4294951817 TABLE        140
X$KSFMLIB                      4294951910 TABLE        139
X$KSFMSUBELEM                  4294951820 TABLE        143
X$KSFQDVNT                     4294951380 TABLE        107
X$KSFQP                        4294951563 TABLE        106
X$KSFVQST                      4294951441 TABLE        108
X$KSFVSL                       4294951426 TABLE        110
X$KSFVSTA                      4294951427 TABLE        109
X$KSIMAT                       4294951180 TABLE         52
X$KSIMAV                       4294951179 TABLE         51
X$KSIMSI                       4294951178 TABLE         50
X$KSIRESTYP                    4294951982 TABLE         49
X$KSIRGD                       4294952708 TABLE        152
X$KSKPLW                       4294952188 TABLE        121
X$KSLCS                        4294952078 TABLE         13
X$KSLECLASS                    4294951830 TABLE          9
X$KSLED                        4294951094 TABLE         12
X$KSLEI                        4294951102 TABLE         17
X$KSLEMAP                      4294951831 TABLE         10
X$KSLES                        4294951095 TABLE         15
X$KSLHOT                       4294952169 TABLE          7
X$KSLLCLASS                    4294951813 TABLE          8
X$KSLLD                        4294950994 TABLE         11
X$KSLLT                        4294950993 TABLE          6
X$KSLLW                        4294951183 TABLE         18
X$KSLPO                        4294951184 TABLE         19
X$KSLSCS                       4294952079 TABLE         14
X$KSLSESHIST                   4294951973 TABLE         16
X$KSLWSC                       4294951185 TABLE         20
X$KSMDD                        4294951622 TABLE        131
X$KSMDUT1                      4294952607 TABLE        132
X$KSMFS                        4294951384 TABLE         58
X$KSMFSV                       4294951146 TABLE         62
X$KSMGE                        4294951733 TABLE        133
X$KSMHP                        4294951193 TABLE         69
X$KSMJCH                       4294951609 TABLE         70
X$KSMJS                        4294951595 TABLE         59
X$KSMLRU                       4294951099 TABLE         63
X$KSMLS                        4294951383 TABLE         57
X$KSMMEM                       4294951147 TABLE         61
X$KSMNIM                       4294951494 TABLE         56
X$KSMNS                        4294951493 TABLE         55
X$KSMPGDP                      4294952674 TABLE         81
X$KSMPGDST                     4294952673 TABLE         80
X$KSMPGST                      4294952646 TABLE         79
X$KSMPP                        4294951191 TABLE         67
X$KSMSD                        4294950995 TABLE         53
X$KSMSGMEM                     4294952475 TABLE         78
X$KSMSP                        4294951100 TABLE         65
X$KSMSPR                       4294951170 TABLE         66
X$KSMSP_DSNEW                  4294951768 TABLE         72
X$KSMSP_NWEX                   4294951769 TABLE         73
X$KSMSS                        4294950997 TABLE         54
X$KSMSST                       4294952688 TABLE         71
X$KSMSTRS                      4294952000 TABLE         60
X$KSMUP                        4294951192 TABLE         68
X$KSOLSFTS                     4294951841 TABLE        148
X$KSOLSSTAT                    4294951842 TABLE        147
X$KSPPCV                       4294951198 TABLE         83
X$KSPPCV2                      4294951587 TABLE         85
X$KSPPI                        4294950998 TABLE         82
X$KSPPO                        4294951486 TABLE         90
X$KSPPSV                       4294951199 TABLE         84
X$KSPPSV2                      4294951588 TABLE         86
X$KSPSPFH                      4294951933 TABLE         88
X$KSPSPFILE                    4294951746 TABLE         87
X$KSPVLD_VALUES                4294952694 TABLE         89
X$KSQDN                        4294951001 TABLE         23
X$KSQEQ                        4294951000 TABLE         96
X$KSQEQTYP                     4294951983 TABLE         21
X$KSQRS                        4294950999 TABLE         22
X$KSQST                        4294951085 TABLE         24
X$KSRCCTX                      4294951580 TABLE        124
X$KSRCDES                      4294951579 TABLE        123
X$KSRCHDL                      4294951583 TABLE        127
X$KSRMPCTX                     4294951582 TABLE        126
X$KSRMSGDES                    4294951581 TABLE        125
X$KSRMSGO                      4294951584 TABLE        128
X$KSTEX                        4294951145 TABLE         99
X$KSUCF                        4294951012 TABLE         44
X$KSUCPUSTAT                   4294952112 TABLE         46
X$KSULL                        4294951082 TABLE         45
X$KSULOP                       4294951244 TABLE         39
X$KSULV                        4294951130 TABLE        101
X$KSUMYSTA                     4294951106 TABLE         35
X$KSUPGP                       4294951577 TABLE         40
X$KSUPGS                       4294951578 TABLE         41
X$KSUPL                        4294951011 TABLE         43
X$KSUPR                        4294951005 TABLE         27
X$KSUPRLAT                     4294951006 TABLE         28
X$KSURLMT                      4294951396 TABLE         29
X$KSURU                        4294951010 TABLE         42
X$KSUSD                        4294951007 TABLE         30
X$KSUSE                        4294951004 TABLE         25
X$KSUSECON                     4294951158 TABLE        105
X$KSUSECST                     4294951096 TABLE         38
X$KSUSEH                       4294952007 TABLE         37
X$KSUSESTA                     4294951009 TABLE         34
X$KSUSEX                       4294951428 TABLE         26
X$KSUSGIF                      4294951930 TABLE         33
X$KSUSGSTA                     4294951008 TABLE         31
X$KSUSIO                       4294951079 TABLE         36
X$KSUSM                        4294952182 TABLE         48
X$KSUTM                        4294951067 TABLE         32
X$KSUVMSTAT                    4294952113 TABLE         47
X$KSUXSINST                    4294951046 TABLE        104
X$KSWSASTAB                    4294952091 TABLE        151
X$KSWSCLSTAB                   4294952155 TABLE        149
X$KSWSEVTAB                    4294952154 TABLE        150
X$KSXAFA                       4294951204 TABLE        456
X$KSXPIA                       4294952165 TABLE        129
X$KSXRCH                       4294951731 TABLE        137
X$KSXRCONQ                     4294951730 TABLE        136
X$KSXRMSG                      4294951728 TABLE        134
X$KSXRREPQ                     4294951729 TABLE        135
X$KSXRSG                       4294951732 TABLE        138
X$KTADM                        4294951013 TABLE        344
X$KTATL                        4294952594 TABLE        347
X$KTATRFIL                     4294952592 TABLE        345
X$KTATRFSL                     4294952593 TABLE        346
X$KTCNREG                      4294952202 TABLE        381
X$KTCSP                        4294951984 TABLE        349
X$KTCXB                        4294951014 TABLE        348
X$KTFBFE                       4294951515 TABLE        370
X$KTFBHC                       4294951516 TABLE        371
X$KTFBUE                       4294951517 TABLE        372
X$KTFTHC                       4294951518 TABLE        373
X$KTFTME                       4294951519 TABLE        374
X$KTIFB                        4294952162 TABLE        378
X$KTIFF                        4294952161 TABLE        377
X$KTIFP                        4294952160 TABLE        376
X$KTIFV                        4294952163 TABLE        379
X$KTPRHIST                     4294951987 TABLE        369
X$KTPRXRS                      4294951457 TABLE        367
X$KTPRXRT                      4294951459 TABLE        368
X$KTRSO                        4294951688 TABLE        375
X$KTSKSTAT                     4294951985 TABLE        357
X$KTSPSTAT                     4294951779 TABLE        356
X$KTSSO                        4294951251 TABLE        351
X$KTSTFC                       4294951520 TABLE        352
X$KTSTSSD                      4294951176 TABLE        350
X$KTSTUSC                      4294952595 TABLE        353
X$KTSTUSG                      4294952597 TABLE        355
X$KTSTUSS                      4294952596 TABLE        354
X$KTTEFINFO                    4294952465 TABLE        358
X$KTTVS                        4294951062 TABLE        366
X$KTUGD                        4294951683 TABLE        359
X$KTUQQRY                      4294952094 TABLE        380
X$KTURD                        4294951022 TABLE        360
X$KTURHIST                     4294951986 TABLE        365
X$KTUSMST                      4294951684 TABLE        362
X$KTUSMST2                     4294952111 TABLE        363
X$KTUSUS                       4294952619 TABLE        364
X$KTUXE                        4294951205 TABLE        361
X$KUPVA                        4294951946 TABLE        475
X$KUPVJ                        4294951945 TABLE        474
X$KVII                         4294951127 TABLE        471
X$KVIS                         4294951128 TABLE        472
X$KVIT                         4294951129 TABLE        473
X$KWDDEF                       4294951568 TABLE        493
X$KWQBPMT                      4294952159 TABLE        506
X$KWQPD                        4294951908 TABLE        496
X$KWQPS                        4294951907 TABLE        495
X$KWQSI                        4294951434 TABLE        497
X$KWRSNV                       4294951953 TABLE        498
X$KXFPBS                       4294952167 TABLE        454
X$KXFPCDS                      4294951119 TABLE        447
X$KXFPCMS                      4294951117 TABLE        445
X$KXFPCST                      4294951113 TABLE        444
X$KXFPDP                       4294951134 TABLE        449
X$KXFPNS                       4294951497 TABLE        452
X$KXFPPFT                      4294951661 TABLE        453
X$KXFPSDS                      4294951120 TABLE        448
X$KXFPSMS                      4294951118 TABLE        446
X$KXFPSST                      4294951114 TABLE        450
X$KXFPYS                       4294951135 TABLE        451
X$KXFQSROW                     4294951189 TABLE        455
X$KXSBD                        4294951196 TABLE        443
X$KXSCC                        4294951188 TABLE        442
X$KZDOS                        4294951023 TABLE        420
X$KZEKMFVW                     4294952685 TABLE        426
X$KZRTPD                       4294951771 TABLE        424
X$KZSPR                        4294951025 TABLE        422
X$KZSRO                        4294951024 TABLE        421
X$KZSRT                        4294951115 TABLE        423
X$LCR                          4294951637 TABLE        317
X$LE                           4294950958 TABLE        267
X$LOGMNR_ATTRIBUTE$            4294951765 TABLE        305
X$LOGMNR_CALLBACK              4294951634 TABLE        316
X$LOGMNR_COL$                  4294951752 TABLE        292
X$LOGMNR_COLTYPE$              4294951764 TABLE        304
X$LOGMNR_CONTENTS              4294951535 TABLE        290
X$LOGMNR_DICT$                 4294951755 TABLE        295
X$LOGMNR_DICTIONARY            4294951537 TABLE        289
X$LOGMNR_DICTIONARY_LOAD       4294952586 TABLE        311
X$LOGMNR_ENCRYPTED_OBJ$        4294951767 TABLE        307
X$LOGMNR_ENCRYPTION_PROFILE$   4294951766 TABLE        306
X$LOGMNR_IND$                  4294951757 TABLE        297
X$LOGMNR_INDPART$              4294951762 TABLE        302
X$LOGMNR_LATCH                 4294952583 TABLE        310
X$LOGMNR_LOG                   4294952199 TABLE        320
X$LOGMNR_LOGFILE               4294951641 TABLE        312
X$LOGMNR_LOGS                  4294951536 TABLE        287
X$LOGMNR_OBJ$                  4294951754 TABLE        294
X$LOGMNR_PARAMETERS            4294951538 TABLE        288
X$LOGMNR_PROCESS               4294951644 TABLE        313
X$LOGMNR_REGION                4294951631 TABLE        315
X$LOGMNR_ROOT$                 4294951751 TABLE        291
X$LOGMNR_SESSION               4294951638 TABLE        309
X$LOGMNR_TAB$                  4294951753 TABLE        293
X$LOGMNR_TABCOMPART$           4294951761 TABLE        301
X$LOGMNR_TABPART$              4294951759 TABLE        299
X$LOGMNR_TABSUBPART$           4294951760 TABLE        300
X$LOGMNR_TS$                   4294951756 TABLE        296
X$LOGMNR_TYPE$                 4294951763 TABLE        303
X$LOGMNR_USER$                 4294951758 TABLE        298
X$MESSAGES                     4294950992 TABLE         93
X$MUTEX_SLEEP                  4294952692 TABLE        414
X$MUTEX_SLEEP_HISTORY          4294952691 TABLE        413
X$NLS_PARAMETERS               4294951043 TABLE        100
X$NSV                          4294951808 TABLE        512
X$OBJECT_AFFINITY_STATISTICS   4294952185 TABLE        273
X$OPERATORS                    4294952697 TABLE        494
X$OPTION                       4294951132 TABLE        492
X$PRMSLTYX                     4294951900 TABLE        491
X$QESBLSTAT                    4294952620 TABLE        468
X$QESMMAHIST                   4294951847 TABLE        461
X$QESMMAPADV                   4294951850 TABLE        462
X$QESMMIWH                     4294951829 TABLE        459
X$QESMMIWT                     4294951738 TABLE        458
X$QESMMSGA                     4294951737 TABLE        457
X$QESRSTAT                     4294951853 TABLE        463
X$QESRSTATALL                  4294951856 TABLE        464
X$QKSCESES                     4294952030 TABLE        466
X$QKSCESYS                     4294952029 TABLE        465
X$QKSMMWDS                     4294951739 TABLE        460
X$QUIESCE                      4294951708 TABLE        329
X$RFMP                         4294951679 TABLE        509
X$RFMTE                        4294951680 TABLE        510
X$RULE                         4294952208 TABLE        500
X$RULE_SET                     4294952207 TABLE        499
X$SKGXPIA                      4294952166 TABLE        130
X$TARGETRBA                    4294951551 TABLE        280
X$TEMPORARY_LOB_REFCNT         4294951961 TABLE        487
X$TIMEZONE_FILE                4294952589 TABLE        103
X$TIMEZONE_NAMES               4294951704 TABLE        102
X$TRACE                        4294951002 TABLE         97
X$TRACE_EVENTS                 4294951003 TABLE         98
X$UGANCO                       4294951109 TABLE        490
X$VERSION                      4294951029 TABLE        415
X$VINST                        4294951698 TABLE        511
X$XML_AUDIT_TRAIL              4294952598 TABLE        428
X$XSAGGR                       4294951891 TABLE        513
X$XSAGOP                       4294951888 TABLE        515
X$XSAWSO                       4294951897 TABLE        523
X$XSLONGOPS                    4294952060 TABLE        517
X$XSOBJECT                     4294951889 TABLE        516
X$XSOQMEHI                     4294952056 TABLE        521
X$XSOQOJHI                     4294952054 TABLE        519
X$XSOQOPHI                     4294952055 TABLE        520
X$XSOQOPLU                     4294952057 TABLE        522
X$XSOQSEHI                     4294952051 TABLE        518
X$XSSINFO                      4294951894 TABLE        514

Reference

English
http://www.stormloader.com/yonghuang/computer/x$table.html
http://www.ixora.com.au/ (lots of valuable documents are deleted …)
http://www.ixora.com.au/scripts/x$tables.htm
http://www.fors.com/velpuri2/X$/List%20of%20X$%20Tables
http://ordba.net/Ora10g/x$tab.htm
http://www.orafaq.com/faqdbain.htm#X$TAB
http://www.oracle-training.cc/oracle_tips_x$.htm
http://www.adp-gmbh.ch/ora/misc/x.html
http://www.petefinnigan.com/Storing_Data_Directly_From_Oracle_SGA.pdf
http://oraperf.sourceforge.net/presentations/SGA_access.ppt
http://www.eygle.com/refer/Oracle_x$table_list.htm
http://imergegroup.blogspot.com/2007/03/what-is-inside-xtables-in-oracle.html
http://www.oracle-internals.com/?p=11
http://www.jlcomp.demon.co.uk/faq/find_dist.html
https://twiki.cern.ch/twiki/bin/view/PSSGroup/ASM_Internals
22241.1 List of X$ Tables and how the names are derived

Chinese
http://www.dbanotes.net/X$tables.htm
http://www.eygle.com/archives/2004/11/oracle_x_table.html
http://ysjxjf.itpub.net/post/7246/68230
http://chrysie.itpub.net/post/20977/276884
http://soft.zdnet.com.cn/software_zone/2007/0811/452643.shtml
http://fantastechnol.blogspot.com/search/label/Oracle