3.123 ALL_TAB_SUBPARTITIONS
ALL_TAB_SUBPARTITIONS
displays, for each table subpartition accessible to the current user, the subpartition name, name of the table and partition to which it belongs, its storage attributes, and statistics generated by the DBMS_STATS
package.
Related Views
-
DBA_TAB_SUBPARTITIONS
displays such information for all subpartitions in the database. -
USER_TAB_SUBPARTITIONS
displays such information for subpartitions of all partitioned objects owned by the current user. This view does not display theTABLE_OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the table |
|
|
|
Name of the table |
|
|
|
Name of the partition |
|
|
|
Name of the subpartition |
|
|
|
Subpartition bound value expression |
|
|
|
Length of the subpartition bound value expression |
|
|
|
Position of the partition within the table This column is available starting with Oracle Database 12c Release 2 (12.2.0.1). |
|
|
|
Position of the subpartition within the partition |
|
|
|
Name of the tablespace containing the subpartition |
|
|
|
Minimum percentage of free space in a block |
|
|
|
Minimum percentage of used space in a block |
|
|
|
Initial number of transactions |
|
|
|
Maximum number of transactions |
|
|
|
Size of the initial extent in bytes (for a range partition); size of the initial extent in blocks (for a composite partition) |
|
|
|
Size of secondary extents in bytes (for a range partition); size of secondary extents in blocks (for a composite partition) |
|
|
|
Minimum number of extents allowed in the segment |
|
|
|
Maximum number of extents allowed in the segment |
|
|
|
Maximum number of blocks allowed in the segment |
|
|
|
Percentage increase in extent size |
|
|
|
Number of freelist groups allocated in this segment |
|
|
|
Number of freelist groups allocated in this segment |
|
|
|
Indicates whether or not changes to the table are logged:
|
|
|
|
Indicates whether this subpartition is compressed ( |
|
|
|
Default compression for what kind of operations:
The |
|
|
|
Number of rows in the subpartition |
|
|
|
Number of blocks in the subpartition |
|
|
|
Number of empty blocks in the subpartition |
|
|
|
Average space in the subpartition |
|
|
|
Chain count |
|
|
|
Average row length |
|
|
|
Sample size |
|
|
|
Date on which this table was most recently analyzed |
|
|
|
Buffer pool for this subpartition:
|
|
|
|
Database Smart Flash Cache hint to be used for subpartition blocks:
Solaris and Oracle Linux functionality only. |
|
|
|
Cell flash cache hint to be used for subpartition blocks:
See Also: Oracle Exadata Storage Server Software documentation for more information |
|
|
|
|
|
|
|
Indicates whether statistics were entered directly by the user ( |
|
|
|
Indicates whether the partition is in the interval section of an interval partitioned table ( |
|
|
|
Indicates whether the table subpartition segment has been created ( |
|
|
|
Indicates the indexing property. Possible values:
|
|
|
|
Indicates whether a subpartition is read-only or read/write:
This column is available starting with Oracle Database 12c Release 2 (12.2.0.1). |
|
|
|
Indicates whether the In-Memory Column Store (IM column store) is enabled ( |
|
|
|
Indicates the priority for In-Memory Column Store (IM column store) population. Possible values:
|
|
|
|
Indicates how the IM column store is distributed in an Oracle Real Application Clusters (Oracle RAC) environment:
|
|
|
|
Indicates the compression level for the IM column store in an Oracle RAC environment:
This column has a value based on where the segments lie for a table. For example, if the table is partitioned and is enabled for IM column store, the value is |
|
|
|
Indicates the duplicate setting for the IM column store in an Oracle RAC environment:
|
|
|
|
Indicates how the IM column store is populated on various instances. The possible values are:
This column is available starting with Oracle Database 12c Release 2 (12.2.0.1). |
|
|
|
Indicates the service name for the service on which the IM column store should be populated. This column has a value only when the corresponding This column is available starting with Oracle Database 12c Release 2 (12.2.0.1). |
|
|
|
The value for columnar compression in the storage cell flash cache. Possible values:
This column is intended for use with Oracle Exadata. This column is available starting with Oracle Database 12c Release 2 (12.2.0.1). |
See Also:
-
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_STATS
package