Abstract
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
The manual shows how to access X$KGLLK for resolving the error “ORA-04021 timeout occurred while waiting to lock object.“
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2009 Norbert Debes
About this chapter
Cite this chapter
Debes, N. (2009). Introduction to X$ Fixed Tables. In: Secrets of the Oracle Database. Apress. https://doi.org/10.1007/978-1-4302-1953-8_9
Download citation
DOI: https://doi.org/10.1007/978-1-4302-1953-8_9
Publisher Name: Apress
Print ISBN: 978-1-4302-1952-1
Online ISBN: 978-1-4302-1953-8
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books