Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
ALL_TAB_SUBPARTITIONS
describes, for each table subpartition accessible to the current user, the subpartition name, name of the table and partition to which it belongs, and its storage attributes.
DBA_TAB_SUBPARTITIONS
provides such information for all subpartitions in the database.
USER_TAB_SUBPARTITIONS
provides such information for subpartitions of all partitioned objects owned by the current user. This view does not display the TABLE_OWNER
column.
Note: Statistics are not collected on a per-subpartition basis. |
Column | Datatype | NULL | Description |
---|---|---|---|
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) |
Indicates whether statistics were entered directly by the user (YES ) or not (NO ) |