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, except where otherwise noted, 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_TYPE VARCHAR2(11) NOT NULL

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.

PERSISTENT_OBJECTS NUMBER   Current number of objects that are marked persistent read-mostly in the cluster
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
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.

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
CON_DBID NUMBER   The database ID of the PDB for the sampled session
CON_ID NUMBER  

The ID of the container that CON_DBID identifies. 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

See Also: “V$DYNAMIC_REMASTER_STATS”