X$表-数据库专栏,SQL Server

  [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