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.
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 table is composite-partitioned, NO if it is not composite-partitioned |
|
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 (for a range partition); size of the initial extent in blocks (for a composite partition) | |
NEXT_EXTENT |
NUMBER |
Size of secondary extents in bytes (for a range partition); size of secondary extents in blocks (for a composite partition) | |
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) |
Indicates whether statistics were entered directly by the user (YES) or not (NO) |