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, except where otherwise noted, and total values reflect what has been collected since instance startup.

Column Datatype Description
REMASTER_TYPE 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
PERSISTENT_OBJECTS NUMBER Current number of objects that are marked persistent read-mostly in the cluster
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
REMASTERED_BUFFERS NUMBER

Total sum of the sizes (number of buffers) of all dynamically remastered objects

The size of a buffer is specified by the DB_BLOCK_SIZE initialization parameter. The default is 8192 bytes.

AVG_BUFFER_AGE NUMBER Average time (in seconds) that buffers spent in the request queue, waiting to be processed
FILTERED_OBJECTS NUMBER Number of requests that were filtered (not processed)
FILTERED_BUFFERS NUMBER

Total sum of the sizes (number of buffers) of all requests that were filtered

The size of a buffer is specified by the DB_BLOCK_SIZE initialization parameter. The default is 8192 bytes.

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