Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_TAB_PARTITIONS

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.

Related Views

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
COMPRESSION VARCHAR2(8)
Indicates whether this partition is compressed (ENABLED) or not (DISABLED)
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)