ORACLE几个常用的X$表

Table Name

Acronym Explained

Comments

x$bh

buffer header

James Morle says it's buffer hash

x$kcbwait

kernel cache, block wait

 

x$kcbfwait

kernel cache, block file wait

A commonly used query tells you more than v$waitstat does

x$kcccp

kernel cache, controlfile checkpoint progress

 

x$kccle

kernel cache, controlfile logfile entry

lebsz usually used to show log block size

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$kdxst

kernel data, index status

used in catalog.sql to create index_stats

x$kdxhs

kernel data, index histogram

used in catalog.sql to create index_histogram

x$kghlu

kernel generic, heap LRUs

 

x$kgllk

kernel generic, librarycache lock

used in catblock.sql to build dba_kgllock

x$kglob

kernel generic, librarycache object

 

x$kglpn

kernel generic, librarycache pin

used in catblock.sql to build dba_kgllock

x$kglst

kernel generic, librarycache status

 

x$kqfco

kernel query, fixed table columns

 

x$kqfta

kernel query, fixed table

 

x$kqfdt

kernel query, fixed table

 

x$kqfp

kernel query, fixed procedure

used in catprc.sql to build disk_and_fixed_objects view

x$kqfsz

kernel query, fixed size (size of fixed objects in current version of Oracle)

 

x$kqfvi

kernel query, fixed view

 

x$kqfvt

kernel query, fixed view table (how fixed view is built on fixed tables)

 

x$ksled, x$kslei, x$ksles

kernel service, event definition, events for instance, events for session, respectively (not sure about "l")

 

x$ksmfs

kernel service, memory fixed SGA

also contains db_block_buffers and log_buffer sizes for some reason

x$ksmfsv

kernel service, memory fixed SGA vectors

detailing fixed SGA

x$ksmjs

kernel service, memory java_pool summary

 

x$ksmlru

kernel service, memory LRU

 

x$ksmls

kernel service, memory large_pool summary

 

x$ksmmem

kernel service, memory

entire memory map

x$ksmpp

kernel service, memory process pool

PGA

x$ksmsd

kernel service, memory SGA definition

 

x$ksmsp

kernel service, memory shared pool

 

x$ksmspr

kernel service, memory shared pool reserved

 

x$ksmss

kernel service, memory shared_pool summary

 

x$ksmup

kernel service, memory user pool

UGA

x$ksqst

kernel service, enqueue status

 

x$ksulv

kernel service, user locale value

 

x$ksulop

kernel service, user long operation

 

x$ksupr

kernel service, user process

 

x$kzsro

kernel security, system role

used in many SQL scripts in ?/rdbms/admin

x$le

lock element

 

x$le_stat

lock element status