Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_IND_PARTITIONS

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

Related Commands:

 DBA_TAB_PARTITIONS    ALL_TAB_PARTITIONS   USER_TAB_PARTITIONS   




Back to the Top

Simon Sheppard
SS64.com