Oracle 视图 ALL_IND_PENDING_STATS 官方解释，作用，如何使用详细说明
本站中文解释
_VIEW
ALL_IND_PENDING_STATS_VIEW（所有指示器待处理统计视图）是Oracle数据库中的系统视图。该视图可用于查看当前分析指示器统计数据，可帮助用户更好地监控和管理其索引状态和重建过程。
该视图包含有关每个索引和表空间中存储的分析和重建指示器的信息，这可以帮助DBAs和开发人员更好地管理索引。可以使用此视图查看应分析或重建的索引的列表，以定期进行优化。
使用该视图方法很简单：将其添加到具有要查看的分析指示器信息的查询中。 关键是，确保数据库中至少已收集了一些基础性能指标（例如缓冲池命中率），以识别需要重建的索引。
官方英文解释
ALL_IND_PENDING_STATS describes the pending statistics for tables, partitions, and subpartitions accessible to the current user collected using the DBMS_STATS package.
Related Views
-
DBA_IND_PENDING_STATSdescribes pending statistics for all tables, partitions, and subpartitions in the database. -
USER_IND_PENDING_STATSdescribes pending statistics for tables, partitions, and subpartitions owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Name of the index owner |
|
|
|
|
Index name |
|
|
|
|
Table owner name |
|
|
|
|
Name of the table |
|
|
|
|
Name of the partition |
|
|
|
|
Name of the subpartition |
|
|
|
|
Number of levels in the index |
|
|
|
|
Number of leaf blocks in the index |
|
|
|
|
Number of distinct keys in the index |
|
|
|
|
Average number of leaf blocks per key |
|
|
|
|
Average number of data blocks per key |
|
|
|
|
Clustering factor |
|
|
|
|
Number of rows in the index |
|
|
|
|
Sample size |
|
|
|
|
Time of the last analysis |
See Also:
-
“DBA_IND_PENDING_STATS”
-
“USER_IND_PENDING_STATS”
-
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_STATSpackage
