APPENDIX CThe 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. There are 613 X$ tables in 10gR2 (10.2.0.1) compared to 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 database to get the number of views and structure for your specific version. Areas covered in this appendix include

Image A list of all Oracle 10g (10.2.0.1) X$ tables (613 total)

A list ...

Get Oracle Database 10g Performance Tuning Tips & Techniques now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.