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