ALL_TAB_SUBPARTITIONS

ALL_TAB_SUBPARTITIONS describes, for each table subpartition accessible to the current user, the subpartition name, name of the table and partition to which it belongs, and its storage attributes.

Related Views

• DBA_TAB_SUBPARTITIONS provides such information for all subpartitions in the database.
• USER_TAB_SUBPARTITIONS provides such information for subpartitions of all partitioned objects owned by the current user. This view does not display the TABLE_OWNER column.

  Note: Statistics are not collected on a per-subpartition basis.

  Column	Datatype	NULL	Description
  TABLE_OWNER	VARCHAR2(30)	NOT NULL	Table owner
  TABLE_NAME	VARCHAR2(30)	NOT NULL	Table name
  PARTITION_NAME	VARCHAR2(30)		Partition name
  SUBPARTITION_NAME	VARCHAR2(30)		Subpartition name
  SUBPARTITION_POSITION	NUMBER	NOT NULL	Position of a subpartition within a partition
  TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the subpartition
  PCT_FREE	NUMBER	NOT NULL	Minimum percentage of free space in a block
  PCT_USED	NUMBER	NOT NULL	Minimum percentage of used space in a block
  INI_TRANS	NUMBER	NOT NULL	Initial number of transactions
  MAX_TRANS	NUMBER	NOT NULL	Maximum number of transactions
  INITIAL_EXTENT	NUMBER		Size of the initial extent in bytes
  NEXT_EXTENT	NUMBER		Size of secondary extents in bytes
  MIN_EXTENT	NUMBER	NOT NULL	Minimum number of extents allowed in the segment
  MAX_EXTENT	NUMBER	NOT NULL	Maximum number of extents allowed in the segment
  PCT_INCREASE	NUMBER	NOT NULL	Percentage increase in extent size
  FREELISTS	NUMBER		Number of freelist groups allocated in this segment
  FREELIST_GROUPS	NUMBER		Number of freelist groups allocated in this segment
  LOGGING	VARCHAR2(3)		Logging attribute of subpartition
  NUM_ROWS	NUMBER		The number of rows
  BLOCKS	NUMBER		The number of blocks
  EMPTY_BLOCKS	NUMBER		The number of empty blocks
  AVG_SPACE	NUMBER		The average space
  CHAIN_CNT	NUMBER		The chain count
  AVG_ROW_LEN	NUMBER		The average row length
  SAMPLE_SIZE	NUMBER		The sample size
  LAST_ANALYZED	DATE		The date on which this table was most recently analyzed
  BUFFER_POOL	VARCHAR2(7)		The default buffer pool for this subpartition
  GLOBAL_STATS	VARCHAR2(3)		Indicates whether column statistics for the subpartition were collected by analyzing the table as a whole (YES) or estimated from statistics collected for partitions and subpartitions (NO)
  USER_STATS	VARCHAR2(3)		Were the statistics entered directly by the user?