Viewing Information About Partitioned Tables and Indexes
You can display information about partitioned tables and indexes with Oracle Database views.
Table 4-4 lists the views that contain information specific to partitioned tables and indexes:
Table 4-4 Views With Information Specific to Partitioned Tables and Indexes
View | Description |
---|---|
|
|
|
Display partition-level partitioning information, partition storage parameters, and partition statistics generated by the |
|
Display subpartition-level partitioning information, subpartition storage parameters, and subpartition statistics generated by the |
|
Display the partitioning key columns for partitioned tables. |
|
Display the subpartitioning key columns for composite-partitioned tables (and local indexes on composite-partitioned tables). |
|
Display column statistics and histogram information for the partitions of tables. |
|
Display column statistics and histogram information for subpartitions of tables. |
|
Display the histogram data (end-points for each histogram) for histograms on table partitions. |
|
Display the histogram data (end-points for each histogram) for histograms on table subpartitions. |
|
Display partitioning information for partitioned indexes. |
|
Display the following for index partitions: partition-level partitioning information, storage parameters for the partition, statistics collected by the |
|
Display the following information for index subpartitions: partition-level partitioning information, storage parameters for the partition, statistics collected by the |
|
Display information about existing subpartition templates. |
See Also:
-
Oracle Database Reference for descriptions of database views
-
Oracle Database SQL Tuning Guide for information about histograms and generating statistics for tables
-
Oracle Database Administrator’s Guide for more information about analyzing tables, indexes, and clusters