DBA_HIST_DYN_REMASTER_STATS

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_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