Oracle教程 2023-03-27

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
`SNAP_ID`	`NUMBER`	`NOT NULL`	Unique snapshot ID
`DBID`	`NUMBER`	`NOT NULL`	Database ID for the snapshot
`INSTANCE_NUMBER`	`NUMBER`	`NOT NULL`	Instance number for the snapshot
`REMASTER_TYPE`	`VARCHAR2(11)`	`NOT NULL`	Remaster process type. Possible values: `AFFINITY`: This value is used for the row containing statistics that pertain to dynamic remastering activity on object affinity. `READ-MOSTLY`: This value is used for the row containing statistics that pertain to dynamic remastering activity on read-mostly objects.
`PERSISTENT_OBJECTS`	`NUMBER`		Current number of objects that are marked persistent read-mostly in the cluster
`REMASTER_OPS`	`NUMBER`		Total number of dynamic remastering operations
`REMASTER_TIME`	`NUMBER`		Total dynamic remastering time
`REMASTERED_OBJECTS`	`NUMBER`		Total number of objects dynamically remastered due to affinity
`QUIESCE_TIME`	`NUMBER`		Total quiesce step time
`FREEZE_TIME`	`NUMBER`		Total freeze step time
`CLEANUP_TIME`	`NUMBER`		Total cleanup step time
`REPLAY_TIME`	`NUMBER`		Total replay step time
`FIXWRITE_TIME`	`NUMBER`		Total fixwrite step time
`SYNC_TIME`	`NUMBER`		Total synchronization step time
`RESOURCES_CLEANED`	`NUMBER`		Total number of resources cleaned in the cleanup steps
`REPLAYED_LOCKS_SENT`	`NUMBER`		Total number of locks replayed to other instances in the replay steps
`REPLAYED_LOCKS_RECEIVED`	`NUMBER`		Total number of locks received from other instances in the replay steps
`CURRENT_OBJECTS`	`NUMBER`		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
`CON_DBID`	`NUMBER`		The database ID of the PDB for the sampled session
`CON_ID`	`NUMBER`		The ID of the container that `CON_DBID` identifies. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

本站中文解释

官方英文解释

相关推荐