Oracle Database 11g Release 2 Performance Tuning Tips & Techniques

APPENDIX

C

The X$ Tables (DBA)

The X$ tables are usually not mentioned or talked about in many Oracle books or even in the Oracle user community. For this reason, I am including them in this book as one of the few references available (Chapter 13 contains many X$ queries). There are 945 X$ tables in 11gR2 (11.2.0.1.0). There were 613 X$ tables in 10gR2 (10.2.0.1) and only 394 in Oracle 9i Release 2 (9.2.0.1.0). The X$ tables vary in structure and number, depending on the database version and release used. Run the queries on your version of the ...