Oracle X$ table 参考手册

最新推荐文章于 2021-04-13 13:39:16 发布

甲骨灰

最新推荐文章于 2021-04-13 13:39:16 发布

阅读量922

点赞数

分类专栏： ORACLE 文章标签： x视图 X

ORACLE 专栏收录该内容

45 篇文章 0 订阅

订阅专栏

Doc ID:   Note:22241.1
Subject: List of X$ Tables and how the names are derived
Type: REFERENCE
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 14-MAR-1995
Last Revision Date: 23-SEP-1999
Language: USAENG

** INTERNAL ONLY **

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

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