List of X$ Tables and how the names are derived

简介:
导读: 
  X$表名太不容易记忆了,记录一下备查 
  [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 
  [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 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 [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$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 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]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 or higher 
  [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 O[B]ject 
  [S]or[T] Segments - 7.3 or higher 
  X$KTSTSSD - [S]ort [S]egment [D]escriptor - per tablespace statistics 
  [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 









本文转自 牛海彬 51CTO博客,原文链接:http://blog.51cto.com/newhappy/76988,如需转载请自行联系原作者
目录
相关文章
|
SQL 数据库
Powerdesigner 16.5 从SQL Server 2012做逆向工程时提示:Unable to list tables问题
原文:Powerdesigner 16.5 从SQL Server 2012做逆向工程时提示:Unable to list tables问题 公司深圳团队开发有一套系统在华北区这边推向客户,在一次更新补丁时,由于发生了数据字典的变更,但深圳团队并未给出数据库的更新脚本,只给了新版本的数据库创建脚本,为了保证客户方系统中已有数据不丢失,只能自己想办法了:用Powerdesigner把新版本数据库逆向过来后,将此模型Apply到已有数据库中,此时Powerdesigner会比较两个版本的差异,只更新差异而不会丢失数据了。
1084 0
|
6月前
|
安全 Java
java线程之List集合并发安全问题及解决方案
java线程之List集合并发安全问题及解决方案
1046 1
|
5月前
|
Java API Apache
怎么在在 Java 中对List进行分区
本文介绍了如何将列表拆分为给定大小的子列表。尽管标准Java集合API未直接支持此功能,但Guava和Apache Commons Collections提供了相关API。
|
5月前
|
运维 关系型数据库 Java
PolarDB产品使用问题之使用List或Range分区表时,Java代码是否需要进行改动
PolarDB产品使用合集涵盖了从创建与管理、数据管理、性能优化与诊断、安全与合规到生态与集成、运维与支持等全方位的功能和服务,旨在帮助企业轻松构建高可用、高性能且易于管理的数据库环境,满足不同业务场景的需求。用户可以通过阿里云控制台、API、SDK等方式便捷地使用这些功能,实现数据库的高效运维与持续优化。
|
5月前
|
存储 安全 Java
详解Java中集合的List接口实现的ArrayList方法 | Set接口实现的HashSet方法
详解Java中集合的List接口实现的ArrayList方法 | Set接口实现的HashSet方法
|
6月前
|
Java API
使用 Java 来实现两个 List 的差集操作
使用 Java 来实现两个 List 的差集操作
218 3
|
5月前
|
存储 Java 索引
Java List接口实现原理与性能评估
Java List接口实现原理与性能评估
|
5月前
|
存储 缓存 安全
Java List操作详解及常用方法
Java List操作详解及常用方法
|
5月前
|
存储 Java 索引
Java List接口实现原理与性能评估
Java List接口实现原理与性能评估