X$BH and Latch Contention
Norbert Debes · Apress eBooks · 2009
The X$ fixed table X$BH is partially documented in Oracle Database Performance Tuning Guide 10g Release 2. This chapter provides additional information on X$BH. Contrary to what you might expect, I will show that scrutinizing undocumented X$ tables such as X$BH is not necessarily the royal road to optimum system performance.