Oracle 视图 ALL_IND_SUBPARTITIONS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图ALL_IND_SUBPARTITIONS显示全部在当前数据库中实例内定义的指定表的所有分区下的所有分段属性(Subpartition) 。
该视图用于查询一个表的全部分区下的所有分段的相关信息，例如定义的类型、属性、分段名，对对对应的分段号等。
使用方法：
SELECT *
FROM ALL_IND_SUBPARTITIONS
WHERE TABLE_NAME=”;
官方英文解释
ALL_IND_SUBPARTITIONS displays, for each index subpartition accessible to the current user, the subpartition-level partitioning information, the storage parameters for the subpartition, and various subpartition statistics generated by the DBMS_STATS package.
Related Views
DBA_IND_SUBPARTITIONSdescribes all index subpartitions in the database.USER_IND_SUBPARTITIONSdescribes the index subpartitions owned by the current user. This view does not display theINDEX_OWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
| Owner of the index |
|
|
| Name of the index |
|
| 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 index | |
|
| Position of a subpartition within a partition | |
|
| Indicates whether the index partition is usable ( | |
|
|
| Name of the tablespace containing the partition |
|
|
| Minimum percentage of free space in a block |
|
|
| Initial number of transactions |
|
|
| Maximum number of transactions |
|
| Size of the initial extent in bytes | |
|
| Size of secondary extents in bytes | |
|
| 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 process freelists allocated in this segment | |
|
| Number of process freelist groups allocated in this segment | |
|
| Indicates whether or not changes to the index are logged:
| |
|
| Type of compression being used for the subpartition:
| |
|
| B-Tree level (depth of the index from its root block to its leaf blocks). A depth of | |
|
| Number of leaf blocks in the index | |
|
| Number of distinct keys in the index partition | |
|
| Average number of leaf blocks in which each distinct value in the index appears, rounded to the nearest integer. For indexes that enforce | |
|
| Average number of data blocks in the table that are pointed to by a distinct value in the index rounded to the nearest integer. This statistic is the average number of data blocks that contain rows that contain a given value for the indexed columns. | |
|
| Indicates the amount of order of the rows in the table based on the values of the index.
| |
|
| Number of rows in this index subpartition | |
|
| Sample size used in analyzing this subpartition | |
|
| Date on which this partition was most recently analyzed | |
|
| Buffer pool for the 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 index subpartition segment has been created ( | |
|
| Status of the operation on the domain index:
| |
|
| For a domain index, the parameter string |
See Also:
“DBA_IND_SUBPARTITIONS”
“USER_IND_SUBPARTITIONS”
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_STATSpackage
编辑：广州明生医药有限公司
标签：视图,分区,属性,定义,英文