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_PARTITIONdisplays freshness information, with respect to PCT detail partitions, for all materialized views in the database. -
USER_MVIEW_DETAIL_PARTITIONdisplays freshness information, with respect to PCT detail partitions, for the materialized views owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the materialized view |
|
|
|
|
Name of the materialized view |
|
|
|
|
Owner of the detail object |
|
|
|
|
Name of the detail object |
|
|
|
Name of the detail object partition |
|
|
|
|
Position of the detail object partition |
|
|
|
|
Freshness state of the detail object logical partition. Possible values:
|
|
|
|
|
Date and time at which the materialized view was last refreshed |
See Also:
-
“DBA_MVIEW_DETAIL_PARTITION”
-
“USER_MVIEW_DETAIL_PARTITION”
