SYS.V$TTSTATS_DISK_HIST

This view contains data about the critical disk IO 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.

Columns

Column name Type Description

ID

TT_BIGINT NOT NULL

The snapshot identifier

IO_MB_RATE

NUMBER NOT NULL

The read and write rates (measured in megabytes per second) since the last snapshot for the checkpoint or the transaction log

PERCENT_USED

NUMBER NOT NULL

The measure of how full the disk is (expressed as a percentage)

TT_FILE_TYPE

TT_TINYINT NOT NULL

The device of the metric. Valid values are:

  • 1: The metric is for the checkpoint device.

  • 2: The metric is for the transaction log device.

  • 3: The metric is for the checkpoint and the transaction log devices.

OS_FILE_SYSTEM

TT_TINYINT NOT NULL

Type of device. Valid values are:

  • 1: Direct attached device

  • 2: Network attached device

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