Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_TAB_PARTITIONS

Columns
   ___________________________
 
   USER_STATS
   PCT_INCREASE
   MIN_EXTENT
   MAX_EXTENT
   MAX_TRANS
   TABLESPACE_NAME
   PCT_FREE
   PCT_USED
   HIGH_VALUE_LENGTH
   INITIAL_EXTENT
   FREELISTS
   INI_TRANS
   NEXT_EXTENT
   HIGH_VALUE
   TABLE_NAME
   COMPOSITE
   PARTITION_POSITION
   SUBPARTITION_COUNT
   GLOBAL_STATS
   BUFFER_POOL
   LAST_ANALYZED
   SAMPLE_SIZE
   AVG_ROW_LEN
   CHAIN_CNT
   AVG_SPACE
   EMPTY_BLOCKS
   BLOCKS
   NUM_ROWS
   LOGGING
   FREELIST_GROUPS
   PARTITION_NAME

Related Commands:

DBA_IND_PARTITIONS    ALL_IND_PARTITIONS USER_IND_PARTITIONS



Back to the Top

Simon Sheppard
SS64.com