[K] Ernel Layer
[2] -phase commit
[G] Lobal [T] raansaction [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] URRRENT [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] NTRIESX $ 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] Equency 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] 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
Ulti-Threaded Layer
[C] Ircuit Component
X $ kmcqs - current [q] UEUE [S] Tate
X $ kmcvc - [v] rtual [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] Ury 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] Aables
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 Startupx $ 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] harned [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] URRRENT 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] urce
X $ ksqst - enqueue [s] tatistics by [t] ype
[U] ser management
[C] OST
X $ KSUCF - COST [F] UNCTION (Resource Limit)
[L] Icence
X $ Ksull - License [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] sason
X $ KSUSECST - Session Status for Events
X $ ksuseesta - 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 $ traction - 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] rasaction 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] AableSpace
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] ORDINATOR 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] harned 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