SYS.V$TTSTATS_CKPTHIST_HIST

This view contains data about the critical checkpoint metric history.

Usage with TimesTen Scaleout

This view contains data for the local element.

Usage with TimesTen Classic

This view exists in TimesTen Classic, but contains no data.

Related view

SYS.GV$TTSTATS_CKPTHIST_HIST

Columns

Column name	Type	Description
ID	TT_BIGINT NOT NULL	The snapshot identifier
STARTTIME	TT_TIMESTAMP NOT NULL	The time when the checkpoint started
ENDTIME	TT_TIMESTAMP	The time when the checkpoint ended
CKPT_TYPE	CHAR(1)	The type of checkpoint: B: Blocking F: Fuzzy S: Static
DURATION_SEC	NUMBER	The duration of the checkpoint
BYTESWRITTEN	TT_BIGINT	The number of bytes that were written in the checkpoint
PER_COMPLETE	TT_INTEGER	Reserved for future use
CKPTVNO	TT_INTEGER NOT NULL	The checkpoint sequence number, which is incremented for each checkpoint
CKPTFILENUM	TT_INTEGER NOT NULL	The database file number that is used by the checkpoint.
COLLECTED_AT	TT_TIMESTAMP NOT NULL	The time when the snapshot was collected
ELEMENTID	TT_INTEGER NOT NULL	The element from which the snapshot was collected