Introduction to X$ Fixed Tables

  • Norbert Debes


A few X$ tables are mentioned in the documentation, but the vast majority are undocumented. For example X$BH is mentioned in the Oracle9i Performance Tuning Guide as well as the Oracle10g Performance Tuning Guide. The Oracle10g Warehouse Builder Installation and Administration Guide contains a procedure for resolving locking issues pertaining to the library cache by accessing X$KGLLK.1


Execution Plan Control File True View Fixed View Password Hash 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Norbert Debes 2009

Authors and Affiliations

  • Norbert Debes

There are no affiliations available

Personalised recommendations