The following list attempts to describe some x$ tables. The list 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