Statistics on tables, indexes, and columns are stored in the data dictionary. To view statistics in the data dictionary, query the appropriate data dictionary view (USER, ALL, or DBA). These DBA_* views include the following:
* DBA_TABLES
* DBA_OBJECT_TABLES
* DBA_TAB_STATISTICS
* DBA_TAB_COL_STATISTICS
* DBA_TAB_HISTOGRAMS
* DBA_INDEXES
* DBA_IND_STATISTICS
* DBA_CLUSTERS
* DBA_TAB_PARTITIONS
* DBA_TAB_SUBPARTITIONS
* DBA_IND_PARTITIONS
* DBA_IND_SUBPARTITIONS
* DBA_PART_COL_STATISTICS
* DBA_PART_HISTOGRAMS
* DBA_SUBPART_COL_STATISTICS
* DBA_SUBPART_HISTOGRAMS
Showing posts with label Indexes and Columns. Show all posts
Showing posts with label Indexes and Columns. Show all posts
Wednesday, May 20, 2009
Subscribe to:
Posts (Atom)