X$系列之一：常用x$表介绍

Oracle 11g Kernal Database Layers

KS: Kernel Services
KX: Kernel Execution
K2: Kernel Distributed Transactions
KK: Kernel Compilation
KZ: Kernel Security
KQ: Kernel Query
KA: Kernel Access
KD: Kernel Data
KT: Kernel Transactions
KC: Kernel Cache
KJ: Kernel Locking
KG: Kernel Generic

X$ks – Kernel Services
x$ksmfs            kernel services, memory fixed SGA          
x$ksmfsv           kernel services, memory fixed SGA vectors         
x$ksmjs            kernel services, memory java_pool summary        
x$ksmlru           kernel services, memory LRU         
x$ksmls            kernel services, memory large_pool summary      
x$ksmmem           kernel services, memory     
x$ksmpp            kernel services, memory process pool      
x$ksmsd            kernel services, memory SGA definition    
x$ksmsp            kernel services, memory shared pool         
x$ksmspr           kernel services, memory shared pool reserved    
x$ksmss            kernel services, memory shared_pool summary   
x$ksmup            kernel services, memory user pool
x$ksqst            kernel services, enqueue status      
x$ksulop           kernel services, user long operation           
x$ksulv            kernel services, user locale value   
x$ksupr            kernel services, user process 

X$kc – kernel cache
x$kcbfwait         kernel cache, block file wait
x$kcbwait          kernel cache, block wait       
x$kcccp            kernel cache, controlfile checkpoint progress       
x$kcfio            kernel cache, file I/O 
x$kclfh            kernel cache, lock file header          
x$kclfi            kernel cache, lock file index 
x$kcluh            kernel cache, lock undo header      
x$kclui            kernel cache, lock undo index         

X$kq – kernel query
x$kqfco            kernel query, fixed table columns    
x$kqfdt            kernel query, fixed table       
x$kqfp             kernel query, fixed procedure         
x$kqfsz            kernel query, fixed size         
x$kqfta            kernel query, fixed table       
x$kqfvi            kernel query, fixed view        
x$kqfvt            kernel query, fixed view table           

X$kg – kernel generic
x$kghlu            kernel generic, heap LRUs  
x$kgllk            kernel generic, library cache lock   
x$kglob            kernel generic, library cache object            
x$kglpn            kernel generic, library cache pin    
x$kglst            kernel generic, library cache status 

X$kz – Kernel security
x$kzsro            kernel security, system role