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  

  uffer Management  

    Buffer [H]ash  

      X$BH - Hash Table  

  

Buffer LRU Statistics  

  X$KCBCBH - [C]urrent uffers (buckets) - lru_statistics  

  X$KCBRBH - [R]ecent 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 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  

  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+  

  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+  

  

[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+  

  

[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 Oject  

  

  [S]or[T] Segments - 7.3 or higher  

    X$KTSTSSD - [S]ort [S]egment [D]escriptor - per tablespace stats  

  

  [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 - 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  

  Network [CO]nnections  

    X$UGANCO - Current [N]etwork [CO]nnections