Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_IND_PARTITIONS

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

Related Commands:

 DBA_TAB_PARTITIONS    ALL_TAB_PARTITIONS   USER_TAB_PARTITIONS    
   
   
   



Back to the Top

Simon Sheppard
SS64.com