oracle X$表命名约定(二)
e
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+
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 us