Oracle Internal X$Tables
- x$bh Buffer Hash
- 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
