V$DYNAMIC_REMASTER_STATS

V$DYNAMIC_REMASTER_STATS displays statistical information about the dynamic remastering process of object affinity and read-mostly. All times are given in hundredths of a second, and total values reflect what has been collected since instance startup.

Column Datatype Description

REMASTER_TYPE1

VARCHAR2(11)

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.

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

CON_ID

NUMBER

The ID of the container to which the data pertains. 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
1

This column is available starting with Oracle Database 12c Release 1 (12.1.0.2).