ALL_TAB_PARTITIONS

ALL_TAB_PARTITIONS provides partition-level partitioning information, partition storage parameters, and partition statistics collected by ANALYZE statements for partitions accessible to the current user.

Related views:

• DBA_TAB_PARTITIONS provides such information for all partitions in the database.

• USER_TAB_PARTITIONS provides such information for partitions of all partitioned objects owned by the current user. This view does not display the OWNER column.

  Column	Datatype	NULL	Description
  TABLE_OWNER	VARCHAR2(30)	NOT NULL	Table owner
  TABLE_NAME	VARCHAR2(30)	NOT NULL	Table name
  COMPOSITE	VARCHAR2(3)		YES if the partition belongs to a Local index on a table partitioned using Composite method; NO otherwise
  PARTITION_NAME	VARCHAR2(30)		Partition name
  SUBPARTITION_COUNT	NUMBER		If this is a Local index on a table partitioned using a Composite method, the number of subpartitions in the partition
  HIGH_VALUE	LONG		Partition bound value expression
  HIGH_VALUE_LENGTH	NUMBER	NOT NULL	Length of partition bound value expression
  PARTITION_POSITION	NUMBER	NOT NULL	Position of the partition within the table
  TABLESPACE_NAME	VARCHAR2(30)	NOT NULL	Name of the tablespace containing the partition
  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 process freelists allocated in this segment
  FREELIST_GROUPS	NUMBER		Number of freelist groups allocated in this segment
  LOGGING	VARCHAR2(3)		Logging attribute of partition
  NUM_ROWS	NUMBER		Number of rows in the partition
  BLOCKS	NUMBER		Number of used blocks in the partition
  EMPTY_BLOCKS	NUMBER		Number of empty (never used) blocks in the partition
  AVG_SPACE	NUMBER		Average available free space in the partition
  CHAIN_CNT	NUMBER		Number of chained rows in the partition
  AVG_ROW_LEN	NUMBER		Average row length, including row overhead
  SAMPLE_SIZE	NUMBER		Sample size used in analyzing this partition
  LAST_ANALYZED	DATE		Date on which this partition was most recently analyzed
  BUFFER_POOL	VARCHAR2(7)		The default buffer pool to be used for the partition blocks
  GLOBAL_STATS	VARCHAR2(3)		Indicates whether statistics were collected for the partition as a whole (YES) or were estimated from statistics on underlying subpartitions (NO).
  USER_STATS	VARCHAR2(3)		User statistics