4.324 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 |
---|---|---|---|
|
|
|
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
|
Footnote 1 This column is available starting with Oracle Database release 19c, version 19.1.
See Also: