Oracle 视图 ALL_MVIEW_DETAIL_PARTITION 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图ALL_MVIEW_DETAIL_PARTITION显示了指定的完全物化视图索引的所有可分区的信息。该视图用于确定分区细节、查找计划细节以及监控物化视图的性能并调整其优化设置。

使用方法：

1. 获取物化视图的分区信息
SELECT MV_NAME, PARTITION_NAME FROM ALL_MVIEW_DETAIL_PARTITION WHERE OWNER=”;

2. 获取某个分区下的物化视图的索引信息
SELECT MV_NAME, INDEX_NAME, INDEX_TYPE FROM ALL_MVIEW_DETAIL_PARTITION WHERE OWNER=” AND PARTITION_NAME=” ;

3. 查询索引信息
SELECT INDEX_NAME, COLUMN_USED, COLUMN_POSITION FROM ALL_MVIEW_DETAIL_PARTITION WHERE OWNER=” AND MV_NAME =” AND PARTITION_NAME =” ;

官方英文解释

ALL_MVIEW_DETAIL_PARTITION displays freshness information, with respect to partition change tracking (PCT) detail partitions, for the materialized views accessible to the current user.

Related Views

• DBA_MVIEW_DETAIL_PARTITION displays freshness information, with respect to PCT detail partitions, for all materialized views in the database.

• USER_MVIEW_DETAIL_PARTITION displays freshness information, with respect to PCT detail partitions, for the materialized views owned by the current user.

See Also:

• “DBA_MVIEW_DETAIL_PARTITION”

• “USER_MVIEW_DETAIL_PARTITION”