Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_TAB_PARTITIONS

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

Related Commands:

DBA_IND_PARTITIONS  ALL_IND_PARTITIONS  USER_IND_PARTITIONS




Back to the Top

Simon Sheppard
SS64.com