SYS.MONITOR

The MONITOR table stores information about system performance. It contains a single row with statistics about certain events. For many columns, statistics are gathered starting from the time the data store is loaded into memory and statistics are cleared when the data store is unloaded from memory. With a ramPolicy of manual or always, the data store remains in memory when there are no application connections.

For some columns, statistics are gathered as needed. TimesTen does not gather statistics from the time of the first connection for these columns:

PERM_ALLOCATED_SIZE
PERM_IN_USE_SIZE
TEMP_ALLOCATED_SIZE
LAST_LOG_FILE
REPHOLD_LOG_FILE
REPHOLD_LOG_OFF
FIRST_LOG_FILE
CHECKPOINT_BYTES_WRITTEN

For most columns, the MONITOR table is reset whenever there are no connections to the data store. TimesTen does not reset the values of the following columns, even when there are no connections to the data store:

PERM_ALLOCATED_SIZE
PERM_IN_USE_SIZE
TEMP_ALLOCATED_SIZE
LAST_LOG_FILE
REPHOLD_LOG_FILE
REPHOLD_LOG_OFF
FIRST_LOG_FILE

TimesTen frequently updates information in the MONITOR table. To prevent these updates from slowing down the system, they are not protected by latches. Hence values in the MONITOR table are not absolutely accurate. They can be used as a reliable indication of activities in the system.

Columns

Column name	Type	Description
TIME_OF_1ST_CONNECT	TT_CHAR (32) NOT NULL	Time at which the first connection was made.
DS_CONNECTS	TT_INTEGER NOT NULL	Number of connects to the data store.
DS_DISCONNECTS	TT_INTEGER NOT NULL	Number of disconnects from the data store.
DS_CHECKPOINTS	TT_INTEGER NOT NULL	Number of checkpoints taken.
DS_CHECKPOINTS_ FUZZY	TT_INTEGER NOT NULL	Number of fuzzy checkpoints taken.
DS_COMPACTS	TT_INTEGER NOT NULL	Number of data store compactions.
PERM_ALLOCATED_SIZE	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	Allocated size in kilobytes of the permanent data partition
PERM_IN_USE_SIZE	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	Size in kilobytes of the portion of the permanent data partition that is currently in use.
PERM_IN_USE_HIGH_ WATER	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	The highest amount (in kilobytes) of permanent data partition memory in use since the first connection to the data store. The value of this field can be reset to the current value of the PERM_IN_USE_SIZE attribute by using the `ttMonitorHighWaterReset` procedure.
TEMP_ALLOCATED_SIZE	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	Allocated size in kilobytes of the temporary data partition
TEMP_IN_USE_SIZE	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	Size in kilobytes of the portion of the temporary data partition that is currently in use.
TEMP_IN_USE_HIGH_ WATER	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	The highest amount (in kilobytes) of temporary data partition memory in use since the first connection to the data store. The value of this field can be reset to the current value of the TEMP_IN_USE_SIZE attribute by using the `ttMonitorHighWaterReset` procedure.
TPL_FETCHES	TT_BIGINT NOT NULL	Number of times TimesTen fetches data from Oracle into TimesTen using transparent load.
TPL_EXECS	TT_BIGINT NOT NULL	Number of times TimesTen communicates with Oracle to transparently load data into TimesTen. This count also includes attempts to perform a transparent load when there is no data to fetch from Oracle.
CACHE_HITS	TT_BIGINT NOT NULL	Number of times TimesTen successfully finds the required data in TimesTen.
PASSTHROUGH_COUNT	TT_BIGINT NOT NULL	Number of successful passthrough executions.
XACT_BEGINS	TT_BIGINT NOT NULL	Number of -transactions started.
XACT_COMMITS	TT_BIGINT NOT NULL	Number of durable and nondurable transactions -committed.
XACT_D_COMMITS	TT_BIGINT NOT NULL	Number of transactions committed durably.
XACT_ROLLBACKS	TT_BIGINT NOT NULL	Number of transactions rolled back.
LOG_FORCES	TT_BIGINT NOT NULL	Number of log flushes to disk.
DEADLOCKS	TT_BIGINT NOT NULL	Number of deadlocks.
LOCK_TIMEOUTS	TT_BIGINT NOT NULL	Number of lock requests denied due to timeouts.
LOCK_GRANTS_ IMMED	TT_BIGINT NOT NULL	Number of lock requests granted without a wait.
LOCK_GRANTS_WAIT	TT_BIGINT NOT NULL	Number of lock requests granted after a wait.
CMD_PREPARES	TT_BIGINT NOT NULL	Number of commands prepared (compiled).
CMD_REPREPARES	TT_BIGINT NOT NULL	Number of commands re-prepared.
CMD_TEMP_INDEXES	TT_BIGINT NOT NULL	Number of temporary indexes created during query -execution.
LAST_LOG_FILE	TT_INTEGER NOT NULL	Number of last log file.
REPHOLD_LOG_FILE	TT_INTEGER NOT NULL	Number of last log file held by replication.
REPHOLD_LOG_OFF	TT_INTEGER NOT NULL	Offset in last log file held by replication.
REP_XACT_COUNT	TT_INTEGER NOT NULL	The number of replicated transactions generated on the local store that are being replicated to at least one peer data store.
REP_CONFLICT_COUNT	TT_INTEGER NOT NULL	The number of replicated transactions that ran into a conflict when being applied on the local store.
REP_PEER_ CONNECTIONS	TT_INTEGER NOT NULL	The sum of all peer connections initiated by the local replication agent. There is one connection for every peer relationship where the local store is the master. If a transport level failure results in the establishment of a new connection, this count is incremented.
REP_PEER_RETRIES	TT_INTEGER NOT NULL	The number of retry attempts while trying to establish a new peer connection.
FIRST_LOG_FILE	TT_INTEGER NOT NULL	The number of the oldest existing (not yet purged) log file.
LOGBYTES_TO_LOG_ BUFFER	TT_BIGINT NOT NULL	The number of bytes written to the log since first connect. This value includes the sizes of actual log records plus any log overhead.
LOG_FS_READS	TT_BIGINT NOT NULL	The number of times that a log read could not be satisfied from the in-memory log buffer.
LOG_FS_WRITES	TT_BIGINT NOT NULL	The number of times TimesTen has written the contents of the in-memory log buffer to the operating system. This column does not count the number of times data was flushed to disk. It counts writes to the operating system's file buffers.
LOG_BUFFER_WAITS	TT_BIGINT NOT NULL	The number of times a thread was delayed while trying to insert a log record into the log buffer because the log buffer was full. Generally speaking, if this value is increasing, it indicates that the log buffer is too small.
CHECKPOINT_BYTES_ WRITTEN	TT_INTEGER NOT NULL for 32-bit systems TT_BIGINT NOT NULL for 64-bit systems	The number of bytes written to disk by the most recent checkpoint operation.
CURSOR_OPENS	TT_INTEGER NOT NULL for 32-bit systems TT_BIGINT NOT NULL for 64-bit systems	Number of SELECT statements issued.
CURSOR_CLOSES	TT_INTEGER NOT NULL for 32-bit systems TT_BIGINT NOT NULL for 64-bit systems	Number of SELECT statements completed.
CHECKPOINT_BLOCKS_WRITTEN	TT_INTEGER NOT NULL for 32-bit systems TT_BIGINT NOT NULL for 64-bit systems	Total number of blocks written for all completed checkpoints. To improve I/O efficiency, multiple blocks may be coalesced into a single write or a single block may be split across multiple writes.
CHECKPOINT_WRITES	TT_INTEGER NOT NULL for 32-bit systems TT_BIGINT NOT NULL for 64-bit systems	Total number of write operations issued by all completed and in-progress checkpoints.
REQUIRED_RECOVERY	TT_INTEGER NOT NULL	1: When the data store was initially loaded into RAM at TIME_OF_1ST_CONNECT, recovery ran. This means that the previous time the data store was in memory, the data store did not shut down cleanly. When it was loaded into memory this time, the log was replayed and other operations were performed in an attempt to recover data. If `DurableCommit` had been set to 0, transactions could have been lost. 0: The data store was previously shut down cleanly. Thus the data store was restarted cleanly.
TYPE_MODE	TT_INTEGER NOT NULL	0: Oracle mode. 1: TimesTen mode.