Skip Headers
Oracle® TimesTen In-Memory Database SQL Reference
Release 11.2.1

Part Number E13070-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

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:

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:

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.
CHECKPOINT_WRITES TT_INTEGER NOT NULL for 32-bit systems

TT_BIGINT NOT NULL for 64-bit systems

Total number of checkpoint writes all checkpoints, including the current checkpoint.
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.