Oracle X $ table naming conventions

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.