Oracle教程 2023-02-24

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

本站中文解释

Oracle视图DBA_MVREF_RUN_STATS表示一组运行聚簇索引（Clustered Index）统计信息。它包含有关特定数据表或片段上已执行的统计信息（如实际和预期行数）以及表或片段的实际物理属性（如每行的印记大小和实际行的平均的长度）的信息。这些统计信息可以帮助数据库管理员优化表和片段的实施，并有助于为不同的查询提供最佳性能。

要查看关于DBA_MVREF_RUN_STATS的信息，可以通过使用SQL语句在具有查询权限的用户下调用该视图。下面是一个使用此视图的例子：

SELECT * FROM DBA_MVREF_RUN_STATS WHERE TABLE_OWNER = ‘OWNER_NAME’;

此语句将查询所有有关拥有者名为OWNER_NAME的表和片段的统计信息。

官方英文解释

DBA_MVREF_RUN_STATS has information about each refresh run for all the materialized views for the database, with each run being identified by the REFRESH_ID. The information includes timing statistics related to the run and the parameters specified in that run.

Related View

USER_MVREF_RUN_STATS has information about each refresh run for the materialized views accessible for the current database user, with each run being identified by the REFRESH_ID. The information includes timing statistics related to the run and the parameters specified in that run. This view does not display the RUN_OWNER column.

Column	Datatype	NULL	Description
`RUN_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the refresh operation (the user who launched the operation)
`REFRESH_ID`	`NUMBER`	`NOT NULL`	The refresh ID of the refresh run
`NUM_MVS`	`NUMBER`	`NOT NULL`	The number of materialized views being refreshed in the run
`MVIEWS`	`VARCHAR2(4000)`		Shows the list of comma separated parameters specified in the API for the materialized view refresh operation
`BASE_TABLES`	`VARCHAR2(4000)`		For internal use only
`METHOD`	`VARCHAR2(4000)`		The `METHOD` parameter specified by the API
`ROLLBACK_SEG`	`VARCHAR2(4000)`		The `ROLLBACK_SEG` parameter specified by the API
`PUSH_DEFERRED_RPC`	`CHAR(1)`		The `PUSH_DEFERRED_RPC` parameter specified by the API
`REFRESH_AFTER_ERRORS`	`CHAR(1)`		The `REFRESH_AFTER_ERRORS` parameter specified by the API
`PURGE_OPTION`	`NUMBER`		The `PURGE_OPTION` parameter specified by the API
`PARALLELISM`	`NUMBER`		The `PARALLELISM` parameter specified by the API
`HEAP_SIZE`	`NUMBER`		The `HEAP_SIZE` parameter specified by the API
`ATOMIC_REFRESH`	`CHAR(1)`		The `ATOMIC_REFRESH` parameter specified by the API
`NESTED`	`CHAR(1)`		The `NESTED` parameter specified by the API
`OUT_OF_PLACE`	`CHAR(1)`		The `OUT_OF_PLACE` parameter specified by the API
`NUMBER_OF_FAILURES`	`NUMBER`		The number of failures that occurred in processing the API
`START_TIME`	`TIMESTAMP(6)`		Start time of the refresh run
`END_TIME`	`TIMESTAMP(6)`		End time of the refresh run
`ELAPSED TIME`	`NUMBER`		The length of time for the refresh run, in seconds
`LOG_SETUP_TIME`	`NUMBER`		Log setup time (in seconds) for the materialized view for a non-atomic refresh; `NULL` for an atomic refresh
`LOG_PURGE_TIME`	`NUMBER`		Log purge time (in seconds) for the materialized view in the case of atomic refresh; `NULL` in the case of non-atomic refresh
`COMPLETE_STATS_AVAILABLE`	`CHAR(1)`		Indicates whether all the complete refresh statistics are available for this run: `Y`: All the statistics are available `N`: All the statistics are not available

本站中文解释

官方英文解释

相关推荐