Oracle 视图 USER_MVIEW_ANALYSIS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图USER_MVIEW_ANALYSIS提供了关于用户的多个维度的分析信息，其中列出了用户下面的多个具体视图的分析信息，例如更新频率、更新延迟、失效频率等。
使用方法：
1. 打开一个SQL工具，然后使用下面的SQL以查看用户下所有视图的分析信息：
SELECT * FROM USER_MVIEW_ANALYSIS;
2. 可以使用下面的SQL语句以指定视图名称来查询某个具体视图的分析信息：
SELECT * FROM USER_MVIEW_ANALYSIS
WHERE MVIEW_NAME = ”;
官方英文解释
USER_MVIEW_ANALYSIS describes all materialized views owned by the current user that potentially support query rewrite and that provide additional information for analysis by applications. Its columns are the same as those in ALL_MVIEW_ANALYSIS.
Note:
This view excludes materialized views that reference remote tables or that include references to non-static values such as SYSDATE or USER. This view also excludes materialized views that were created as snapshots before Oracle8i and that were never altered to enable query rewrite.
See Also:
“ALL_MVIEW_ANALYSIS”
