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