Oracle 视图 V$DYNAMIC_REMASTER_STATS 官方解释，作用，如何使用详细说明
本站中文解释
V$DYNAMIC_REMASTER_STATS是Oracle的一个视图，位于X$KRSBS 表上，用来显示动态重新定位操作的状态计数，其中包括了重新定位块总数、重新定位失败的块数、重新定位超时的块数等等。通过V$DYNAMIC_REMASTER_STATS可以查看动态重新定位操作执行的情况，确保动态重新定位操作正确执行，以提高存储引擎性能。
使用V$DYNAMIC_REMASTER_STATS视图的方法：
首先，进入SQL*Plus命令行，然后在SQL查询窗口中输入如下语句，以查询动态重新定位操作的状态计数：
SELECT * FROM V$DYNAMIC_REMASTER_STATS;
这将显示出动态重新定位操作的状态计数，如重新定位块总数、重新定位成功的块数、重新定位失败的块数、重新定位超时的块数等等。
以上就是关于Oracle视图V$DYNAMIC_REMASTER_STATS及其用途以及使用步骤的详细介绍。
官方英文解释
V$DYNAMIC_REMASTER_STATS displays statistical information about the dynamic remastering process of object affinity and read-mostly. All times are given in hundredths of a second, and total values reflect what has been collected since instance startup.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Remaster process type. Possible values:
|
|
|
|
Total number of dynamic remastering operations |
|
|
|
Total dynamic remastering time |
|
|
|
Total number of objects dynamically remastered due to affinity |
|
|
|
Current number of objects that are marked persistent read-mostly in the cluster |
|
|
|
Total quiesce step time |
|
|
|
Total freeze step time |
|
|
|
Total cleanup step time |
|
|
|
Total replay step time |
|
|
|
Total fixwrite step time |
|
|
|
Total synchronization step time |
|
|
|
Total number of resources cleaned in the cleanup steps |
|
|
|
Total number of locks replayed to other instances in the replay steps |
|
|
|
Total number of locks received from other instances in the replay steps |
|
|
|
Current number of objects remastered on this instance due to affinity or the current number of objects that are marked read-mostly in the cluster |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
