Oracle 视图 DBA_HIST_DYN_REMASTER_STATS 官方解释，作用，如何使用详细说明
本站中文解释
查询
Oracle 视图DBA_HIST_DYN_REMASTER_STATS用于查询动态重新基准状态历史信息。它展示了每次动态重新基准操作的状态及活动信息，让DBA能够更好的监控每次的动态重新基准操作。
使用方法如下：
1.首先用以下SQL语句查询DBA_HIST_DYN_REMASTER_STATS视图：
SELECT * FROM DBA_HIST_DYN_REMASTER_STATS;
2.查询日期区间内的动态重新基准操作状态及活动信息：
SELECT * FROM DBA_HIST_DYN_REMASTER_STATS WHERE BEGIN_TIME >= AND TIME_END ;
3.查询某个动态重新基准操作的状态及活动信息：
SELECT * FROM DBA_HIST_DYN_REMASTER_STATS WHERE OPERATION_NAME = ;
官方英文解释
DBA_HIST_DYN_REMASTER_STATS displays historical statistical information about the dynamic remastering process.
All times are given in hundredths of a second, and total values reflect what has been collected since instance startup. This view contains snapshots of V$DYNAMIC_REMASTER_STATS.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
| Unique snapshot ID |
|
|
| Database ID for the snapshot |
|
|
| Instance number for the snapshot |
|
|
| Remaster process type. Possible values:
|
|
| Current number of objects that are marked persistent read-mostly in the cluster | |
|
| Total number of dynamic remastering operations | |
|
| Total dynamic remastering time | |
|
| Total number of objects dynamically remastered due to affinity | |
|
| 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 database ID of the PDB for the sampled session | |
|
| The ID of the container that
|
See Also:
“V$DYNAMIC_REMASTER_STATS”
编辑：一起学习网
标签：基准,动态,状态,操作,信息