SYS.V$TTSTATS_LOGHOLD_HIST

This view contains data about the history of transaction log holds.

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_LOGHOLD_HIST

Columns

Column name	Type	Description
ID	TT_BIGINT NOT NULL	The snapshot identifier
HOLD_LFN	TT_INTEGER NOT NULL	The transaction log file number of the hold
HOLD_LFO	TT_BIGINT NOT NULL	The transaction log file offset of the hold
LOG_TYPE	TT_CHAR(1) NOT NULL	The log type. Valid values are: C: Checkpoint R: Replication B: Backup X: XLA L: Long running transaction A: Long running XA transaction T: TimesTen Scaleout replica E: Element duplicate
DESCRIPTION	VARCHAR2(1024) NOT INLINE NOT NULL	A description of the log type object for which the hold was created
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