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
