Oracle 视图 ALL_IND_PARTITIONS 官方解释，作用，如何使用详细说明
本站中文解释
ALL_IND_PARTITIONS视图用于描述当前用户或指定用户拥有的索引类型分区的信息，包括索引名称、索引类型、分区名称、分区子分区名称和分区子分区的值的范围。
使用ALL_IND_PARTITIONS视图的方法类似SELECT * FROM DBA_IND_PARTITIONS，不过此处使用的是ALL_IND_PARTITIONS视图，此处查询的是当前用户或者指定用户的索引类型分区信息，而不是所有用户的索引类型分区信息。
例如：一个根据索引值进行查询的例子：
SELECT * FROM ALL_IND_PARTITIONS WHERE index_name=’TEST_INDEX’ AND partition_name=’TEST_PARTITION’ AND lower_bound=’51’ AND upper bound=’60’;
官方英文解释
ALL_IND_PARTITIONS displays, for each index partition accessible to the current user, the partition-level partitioning information, the storage parameters for the partition, and various partition statistics generated by the DBMS_STATS package.
Related Views
DBA_IND_PARTITIONSdescribes all index partitions in the database.USER_IND_PARTITIONSdescribes the index partitions owned by the current user. This view does not display theINDEX_OWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
| Owner of the index | |
|
| Name of the index | |
|
| Indicates whether the partition belongs to a local index on a composite-partitioned table ( | |
|
| Name of the partition | |
|
| If a local index on a composite-partitioned table, the number of subpartitions in the partition | |
|
| Partition bound value expression | |
|
| Length of the partition bound value expression | |
|
| Position of the partition within the index | |
|
| 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 partition:
| |
|
| 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 partition | |
|
| 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 returned | |
|
| Sample size used in analyzing this partition | |
|
| Date on which this partition was most recently analyzed | |
|
| Actual buffer pool for the partition:
| |
|
| Database Smart Flash Cache hint to be used for partition blocks:
Solaris and Oracle Linux functionality only. | |
|
| Cell flash cache hint to be used for partition blocks:
See Also: Oracle Exadata Storage Server Software documentation for more information | |
|
| Indicates whether statistics were entered directly by the user ( | |
|
| If a secondary index on index-organized table, the percentage of rows with | |
|
|
| |
|
| Status of the operation on a domain index:
| |
|
| For a domain index, the parameter string | |
|
| Indicates whether the partition is in the interval section of an interval partitioned table ( | |
|
| Indicates whether the index partition segment has been created ( | |
|
| Indicates whether a global index partition contains stale entries because of deferred index maintenance during Possible values:
|
See Also:
“DBA_IND_PARTITIONS”
“USER_IND_PARTITIONS”
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_STATSpackage
