Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_IND_PARTITIONS

Data Dictionary View

Columns
   ___________________________
 
   INDEX_NAME
      --
   COMPOSITE
      --
   PARTITION_NAME
      --
   SUBPARTITION_COUNT
      --
   HIGH_VALUE
      --
   HIGH_VALUE_LENGTH
      --
   PARTITION_POSITION
      --
   STATUS
      --
   TABLESPACE_NAME
      --
   PCT_FREE
      --
   INI_TRANS
      --
   MAX_TRANS
      --
   INITIAL_EXTENT
      --
   NEXT_EXTENT
      --
   MIN_EXTENT
      --
   MAX_EXTENT
      --
   PCT_INCREASE
      --
   FREELISTS
      --
   FREELIST_GROUPS
      --
   LOGGING
      --
   COMPRESSION
      --
   BLEVEL
      --
   LEAF_BLOCKS
      --
   DISTINCT_KEYS
      --
   AVG_LEAF_BLOCKS_PER_KEY
      --
   AVG_DATA_BLOCKS_PER_KEY
      --
   CLUSTERING_FACTOR
      --
   NUM_ROWS
      --
   SAMPLE_SIZE
      --
   LAST_ANALYZED
      --
   BUFFER_POOL
      --
   USER_STATS
      --
   PCT_DIRECT_ACCESS
      --
   GLOBAL_STATS
      --
   DOMIDX_OPSTATUS
      --
   PARAMETERS
      --

Related:



Simon Sheppard
SS64.com