SYS.V$GRIDSTATS

This view contains data about TimesTen Scaleout statistics.

Usage with TimesTen Scaleout

This view contains data for the local element.

Usage with TimesTen Classic

This view is not supported in TimesTen Classic.

Related view

SYS.GV$GRIDSTATS

Columns

Column name	Type	Description
NAME	TT_CHAR(64) NOT NULL	Name of statistic
VALUE	TT_BIGINT NOT NULL	Value of statistic
LEVEL	TT_BIGINT NOT NULL	Level of the statistic
ELEMENTID	TT_INTEGER NOT NULL	Id of the element

Rows

Table 1-19 lists the name and the description of the TimesTen Scaleout statistics. The statistics are subject to change across software releases.

Table 1-19 TimesTen Scaleout statistics

Name	Description
stmt.local.executes.count	Number of grid local SQL statements executed
stmt.local.executes.updates	Number of grid local update SQL statements executed
stmt.local.executes.deletes	Number of grid local delete SQL statements executed
stmt.local.executes.merges	Number of grid local merge SQL statements executed
stmt.local.executes.inserts	Number of grid local insert SQL statements executed
stmt.local.executes.selects	Number of grid local select SQL statements executed
stmt.remote.executes.count	Number of grid remote SQL statements executed
stmt.remote.executes.updates	Number of grid remote update SQL statements executed
stmt.remote.executes.deletes	Number of grid remote delete SQL statements executed
stmt.remote.executes.merges	Number of grid remote merge SQL statements executed
stmt.remote.executes.inserts	Number of grid remote insert SQL statements executed
stmt.remote.executes.selects	Number of grid remote select SQL statements executed
stmt.global.executes.count	Number of grid global SQL statements executed
stmt.global.executes.updates	Number of grid global update SQL statements executed
stmt.global.executes.deletes	Number of grid global delete SQL statements executed
stmt.global.executes.merges	Number of grid global merge SQL statements executed
stmt.global.executes.inserts	Number of grid global insert SQL statements executed
stmt.global.executes.selects	Number of grid global select SQL statements executed
channel.recv.messages	Number of messages received
channel.send.messages	Number of messages sent
channel.recv.bytes	Number of bytes received
channel.send.bytes	Number of bytes sent
channel.invalidations	Number of channel invalidations
txn.initiated.tm.count	Number of grid transactions initiated as TM
txn.participated.remote.count	Number of grid transactions in which participated as remote
txn.forget.alloc	Number of transaction forget entries allocated
txn.forget.used	Number of transaction forget entries used
txn.voted.no	Number of transactions this element has voted NOT commit
txn.tcc	Number of transactions resolved by TCC
txn.epoch	Number of committed epoch transactions
txn.srso	Number of transactions resolved on a single replica set
tunnel.enqueued.requests	Number of requests enqueued for tunneling
tunnel.processed.requests	Number of requests processed by the tunnels
tunnel.timeoutd.requests	Number of requests timed out while tunneling
tunnel.hangs	Number of hangs detected for the tunnels
tunnel.false.hangs	Number of false positives for hangs detected