Oracle Advanced Performance Tuning Scripts

Scripts for Learning about the X$ Tables

fixed_table_columns.sql

This script generates a description of all the X$ tables, listing all their columns and their datatypes. We use this whenever we are exposed to a new version of Oracle to see what has changed at the level of the X$ tables.

Download script for: 7.3, 8.0 or 8.1

fixed_view_text.sql

This script extracts the SQL statement text for all the V$ views. The V$ views are based on the X$ tables, and reading the SQL statements for these views is the best way to develop an initial understanding of the X$ tables.

Download script for: 7.3, 8.0 or 8.1


Ixora Pty Ltd.   All rights reserved.
12-Oct-2007 22:22
Search   Questions   Feedback   Up   Home