DBA_IND_PARTITIONS

Data Dictionary View

Columns
   ___________________________
 
   INDEX_OWNER
   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:

DBA_IND_SUBPARTITIONS


© Copyright SS64.com 1999-2014
Some rights reserved