Oracle X $ table naming conventions [plain] X $ table naming conventions [plain] [K] ernel Layer [2]-Phase Commit [G] lobal [T] ransaction [E] ntry X $ K2GTE-Current 2 PC tx X $ K2GTE2-Current 2 PC 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 [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 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 $ kmeanco-Table [CO] lumn definitions X $ kmeandt-[D] erived [T] ables X $ kmeansz-Kernel Data structure type [S] I [Z] es X $ KQFTA -Fixed [TA] bles X $ k1_vi-Fixed [VI] ews X $ k1_vt-[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 abve X $ KSMUP-[U] GA Hea [P]-7.3.2 and abve 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 abve 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 $ ksum-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 O [B] ject [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-[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 Network [CO] nnections X $ UGANCO-Current [N] etwork [CO] nnections