ORACLE X$表命名约定

X$表命名约定

[K]ernel Layer
  [2]-Phase Commit
  [G]lobal [T]ransaction [E]ntry
    X$K2GTE - Current 2PC tx
    X$K2GTE2 - Current 2PC tx

[C]ache Layer
  [B]uffer Management
    Buffer [H]ash
      X$BH - Hash Table

Buffer LRU Statistics
  X$KCBCBH - [C]urrent [B]uffers (buckets) - lru_statistics
  X$KCBRBH - [R]ecent [B]uffers (buckets) - lru_extended

Buffer [WAIT]s
  X$KCBWAIT - Waits by block class
  X$KCBFWAIT - Waits by File

[W]orking Sets - 7.3 or higher
  X$KCBWDS - Set [D]escriptors

[C]ontrol File Management
  [C]ontrol [F]ile List - 7.0.16 or higher
    X$KCCCF - Control File Names & status

[D]atabase [I]nformation
  X$KCCDI - Database Information

Data [F]iles
  X$KCCFE - File [E]ntries ( from control file )
  X$KCCFN - [F]ile [N]ames

[L]og Files
  X$KCCLE - Log File [E]ntries
  X$KCCLH - Log [H]istory ( archive entries )

Thread Information
  X$KCCRT - [R]edo [T]hread Information
  [F]ile Management
  X$KCFIO - File [IO] Statistics

[L]ock Manager Component ( LCK )
  [H]ash and Bucket Tables - 7.0.15 to 7.1.1, and 7.2.0 or higher
    X$KCLFH - File [H]ash Table
    X$KCLFI - File Bucket Table

X$LE - Lock [E]lements
X$LE_STAT - Lock Conversion [STAT]istics
X$KCLFX - Lock Element [F]ree list statistics - 7.3 or higher
X$KCLLS - Per LCK free list statistics - 7.3 or higher
X$KCLQN - [N]ame (hash) table statistics - 7.3 or higher

[R]edo Component
  [M]edia recovery - kcra.h - 7.3 or higher
    X$KCRMF - [F]ile context
    X$KCRMT - [T]hread context
    X$KCRMX - Recovery Conte[X]t

[F]ile read
  X$KCRFX - File Read Conte[X]t - 7.3 or higher

Reco[V]ery Component
  [F]ile [H]eaders
    X$KCVFH - All file headers
    X$KCVFHMRR - Files with [M]edia [R]ecovery [R]equired
    X$KCVFHONL - [ONL]ine File headers

[K]ompatibility Management - 7.1.1 or higher
  X$KCKCE - [C]ompatibility Segment [E]ntries
  X$KCKTY - Compatibility [TY]