V$DYNAMIC_REMASTER_STATS
displays 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.
Column | Datatype | Description |
---|---|---|
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 |