注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

常在心

淡泊明志,人生自在

 
 
 

日志

 
 

oracle X$table list  

2011-12-01 09:49:37|  分类: 常用动态性能视图 |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |
Doc ID:  Note:22241.1   Subject:  List of X$ Tables and how the names are derived   Type:  REFERENCE                       Status:  PUBLISHED   Content Type:  TEXT/PLAIN   Creation Date:  14-MAR-1995   Last Revision Date:  23-SEP-1999   Language:  USAENG        ** INTERNAL ONLY **    This is a summary list of X$ Table Definitions - Last revision was 7.3.2  The main purpose of this note is to show the naming conventions.                                        [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  .  

  评论这张
 
阅读(398)| 评论(0)
推荐 转载

历史上的今天

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017