INDEX LEVEL PARTITIONING NOTES:
  • Index Owner - Owner of the partitioned table
  • Index Name - Name of the partitioned table
  • Partition Name - Partition name
  • High Value Length - Length of the partition bound value expression
  • Partition Position - Position of the partition within the table
  • Status - Indicates whether the partition is usable or not
  • Tablespace Name - Name of the tablespace containing the partition
  • Pctfree - Minimum percentage of free space in a block
  • Initrans - Initial number of transactions
  • Maxtrans - Maximum number of transactions
  • Initial Extent - Size of the initial extent in bytes
  • Next Extent - Size of secondary extents in bytes
  • Min Extents - Minimum number of extents allowed in the segments
  • Max Extents - Maximum number of extents allowed in the segments
  • Pct Increase - Percentage increase in extent size
  • Freelists - Number of process freelists allocated in this segment
  • Freelist Groups - Number of freelist groups allocated in this segment
  • Logging - Logging attribute of partition
  • Blevel * - B-Tree level
  • Leaf Blocks * - Number of leaf blocks in the index partition
  • Distinct Keys * - Number of distinct keys in the index partition
  • Avg Leaf Blocks Per Key * - Average number of leaf blocks per key
  • Avg Data Blocks Per Key * - Average number of data blocks per key
  • Clustering Factor * - Measurement of the amount of (dis)order of the table this index partition is for
  • Num Rows * - Number of rows in the partition
  • Sample Size * - Sample size used in analyzing this partition
  • Last Analyzed * - Date of the most recent time this parition was analyzed
  • Buffer Pool - The buffer pool for the partition

    * - Populated when table has been analyzed