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