|
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 |
