本站中文解释

_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_STATS describes pending statistics for all tables, partitions, and subpartitions in the database.

• USER_IND_PENDING_STATS describes pending statistics for tables, partitions, and subpartitions owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
OWNER	VARCHAR2(128)		Name of the index owner
INDEX_NAME	VARCHAR2(128)		Index name
TABLE_OWNER	VARCHAR2(128)		Table owner name
TABLE_NAME	VARCHAR2(128)		Name of the table
PARTITION_NAME	VARCHAR2(128)		Name of the partition
SUBPARTITION_NAME	VARCHAR2(128)		Name of the subpartition
BLEVEL	NUMBER		Number of levels in the index
LEAF_BLOCKS	NUMBER		Number of leaf blocks in the index
DISTINCT_KEYS	NUMBER		Number of distinct keys in the index
AVG_LEAF_BLOCKS_PER_KEY	NUMBER		Average number of leaf blocks per key
AVG_DATA_BLOCKS_PER_KEY	NUMBER		Average number of data blocks per key
CLUSTERING_FACTOR	NUMBER		Clustering factor
NUM_ROWS	NUMBER		Number of rows in the index
SAMPLE_SIZE	NUMBER		Sample size
LAST_ANALYZED	DATE		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 the DBMS_STATS package

---

编辑：一起学习网

标签：视图,指示器,索引,数据库中,更好地