SYS.V$DISTRIBUTION_STATE

This view contains data about the state of each element. The element reporting the state is the local element. The state is retrieved from the distribution map for the local element.

Usage with TimesTen Scaleout

This view contains data for the local element.

Usage with TimesTen Classic

This view is not supported in TimesTen Classic.

Columns

Column name Type Description

STATEELEMENTID

TT_INTEGER

Id of the element whose state is being reported

STATE

TT_VARCHAR(20) INLINE NOT NULL

State of the element. Valid states:

  • Active: The element is actively participating in the grid.

  • Failed: The element in the grid has failed.

  • Unloaded: The element has been unloaded from the database.

  • Down: The element is down.

  • Evicted: The element has been evicted from the grid.

  • Recovering: The element is recovering.

  • Recovering LBCU: The element is recovering and is in LBCU mode.

ELEMENTID

TT_INTEGER NOT NULL

Element id of the element who is reporting the state