当前位置:数据库 > Oracle >>

oracle X$表命名约定

oracle X$表命名约定
 
[plain] 
X$表命名约定  
[plain] 
[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 Opti
CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,