首页 > 应用开发 > IT综合 > What is in all those X$ tables?

What is in all those X$ tables?

原创 IT综合 作者:hzh_hu 时间:2005-04-08 14:04:07 0 删除 编辑
may not be complete or accurate, but represents an attempt to figure out what information they contain. One should generally not write queries against these tables as they are internal to Oracle, and Oracle may change them without any prior notification.
    X$K2GTE2 Kernel 2 Phase Commit Global Transaction Entry Fixed Table
    X$K2GTE Kernel 2 Phase Commit Global Transaction Entry Fixed Table
    X$BH Buffer headers contain information describing the current contents of a piece of the buffer cache.
    X$KCBCBH Cache Buffer Current Buffer Header Fixed Table. It can predict the potential loss of decreasing the number of database buffers. The db_block_lru_statistics parameter has to be set to true to gather information in this table.
    X$KCVFH File Header Fixed Table
    X$KDNCE SGA Cache Entry Fixed Table
    X$KDNST Sequence Cache Statistics Fixed Table
    X$KDXHS Histogram structure Fixed Table
    X$KDXST Statistics collection Fixed Table
    X$KGHLU One-row summary of LRU statistics for the shared pool
    X$KGLBODY Derived from X$KGLOB (col kglhdnsp = 2)
    X$KGLCLUSTER Derived from X$KGLOB (col kglhdnsp = 5)
    X$KGLINDEX Derived from X$KGLOB (col kglhdnsp = 4)
    X$KGLLC Latch Clean-up state for library cache objects Fixed Table
    X$KGLPN Library cache pin Fixed Table
    X$KGLTABLE Derived from X$KGLOB (col kglhdnsp = 1)
    X$KGLTR Library Cache Translation Table entry Fixed Table
    X$KGLTRIGGER Derived from X$KGLOB (col kglhdnsp = 3)
    X$KGLXS Library Cache Access Table
    X$KKMMD Fixed table to look at what databases are mounted and their status
    X$KKSBV Cursor Cache Bind Variables
    X$KSMSP Each row represents a piece of memory in the shared pool
    X$KSQDN Global database name
    X$KSQST Enqueue statistics by type
    X$KSUCF Cost function for each Kernel Profile (join to X$KSUPL)
    X$KSUPL Resource Limit for each Kernel Profile
    X$KSURU Resource Usage for each Kernel Profile (join with X$KSUPL)
    X$KSQST Gets and waits for different types of enqueues
    X$KTTVS indicate tablespace that has valid save undo segments
    X$KVII Internal instance parameters set at instance initialization
    X$KVIS Oracle Data Block (size_t type) variables
    X$KVIT Instance internal flags, variables and parameters that can change during the life of an instance
    X$KXFPCDS Client Dequeue Statistics
    X$KXFPCMS Client Messages Statistics
    X$KZDOS Represent an os role as defined by the operating system
    X$KZSRO Security state Role: List of enabled roles
    X$LE Lock Element : each PCM lock that is used by the buffer cache (gc_db_locks)
    X$MESSAGES Displays all the different messages that can be sent to the Background processes
    X$NLS_PARAMETERS NLS database parameters

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: Oracle x$table介紹
下一篇: 性能參數範例
请登录后发表评论 登录


  • 博文量
  • 访问量