SYS.SYSTEMSTATS

The SYSTEMSTATS table stores system wide monitoring statistics.

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	Internal use

Rows

This section contains tables with names and definitions of the statistics reported in the SYSTEMSTATS table. The statistics are subject to change across software releases.

Table 1-5 Asynchronous writethrough (AWT) cache group statistics

Name	Description
cg.awt.tt_txns	Number of TimesTen transactions propagated to the Oracle database
cg.awt.sql_mode.inserts.rows	Number of rows inserted on the Oracle database in SQL mode (CacheAWTMethod=0)
cg.awt.sql_mode.updates.rows	Number of rows updated on the Oracle database in SQL mode (CacheAWTMethod = 0)
cg.awt.sql_mode.deletes.rows	Number of rows deleted on the Oracle database in SQL mode (CacheAWTMethod=0)
cg.awt.sql_mode.inserts.batches	Number of insert batches sent to the Oracle database in SQL mode (CacheAWTMethod=0)
cg.awt.sql_mode.updates.batches	Number of update batches sent to the Oracle database in SQL mode (CacheAWTMethod=0)
cg.awt.sql_mode.deletes.batches	Number of delete batches sent to the Oracle database in SQL mode (CacheAWTMethod=0)
cg.awt.sql_mode.bytes	Number of bytes sent to the Oracle database in SQL mode (CacheAWTMethod=0)
cg.awt.sql_mode.batches	Number of batches sent to the Oracle database in SQL mode (CacheAWTMethod=0)
cg.awt.plsql_mode.inserts.rows	Number of rows inserted on the Oracle database in PL/SQL mode (CacheAWTMethod=1)
cg.awt.plsql_mode.updates.rows	Number of rows updated on the Oracle database in PL/SQL mode (CacheAWTMethod=1)
cg.awt.plsql_mode.deletes.rows	Number of rows deleted on the Oracle database in PL/SQL mode (CacheAWTMethod=1)
cg.awt.plsql_mode.bytes	Number of bytes sent to the Oracle database in PL/SQL mode (CacheAWTMethod=1)
cg.awt.plsql_mode.batches	Number of PL/SQL block batches sent to the Oracle database (CacheAWTMethod=1)
cg.awt.calls_to_oracle	Number of calls made to the Oracle database
cg.awt.commits_on_oracle	Number of AWT transactions committed on the Oracle database
cg.awt.rollbacks_on_oracle	Number of rollbacks on the Oracle database because of errors
cg.awt.retries_on_oracle	Number of times AWT transactions are retried on the Oracle database in case of an error

Table 1-6 Autorefresh cache group statistics

Name	Description
cg.autorefresh.inserts.rows	Number of rows inserted in TimesTen during autorefresh from the Oracle database
cg.autorefresh.updates.rows	Number of rows updated in TimesTen during autorefresh from the Oracle database
cg.autorefresh.deletes.rows	Number of rows deleted in TimesTen during autorefresh from the Oracle database
cg.autorefresh.cycles.completed	Number of autorefresh cycles completed successfully on TimesTen
cg.autorefresh.cycles.failed	Number of autorefresh cycles that failed because of errors
cg.autorefresh.full_refreshes	Number of full refreshes triggered during autorefresh operations
cg.autorefresh.logtblspacepct.exceeded	Number of iterations the cache agent has attempted to garbage collect

Table 1-7 Cache group flush statistics

Name	Description
cg.flush.execs	Number of flush cache group executions
cg.flush.rows	Number of rows flushed to the Oracle database
cg.flush.bytes	Number of bytes flushed to the Oracle database

Table 1-8 Synchronous writethrough (SWT) cache group statistics

Name	Description
cg.swt.inserts.rows	Number of rows in SWT cache groups inserted on the Oracle database
cg.swt.updates.rows	Number of rows in SWT cache groups updated on the Oracle database
cg.swt.deletes.rows	Number of rows in SWT cache groups deleted on the Oracle database
cg.swt.bytes	Number of bytes sent to the Oracle database during SWT cache group operations

Table 1-9 Local cache group statistics

Name	Description
cg.dynamic.local.hits.count	Local dynamic cache group cache hits: Number of dynamic loads that find the requested data within the TimesTen database
cg.dynamic.local.misses.count	Local dynamic cache group cache misses: Number of dynamic loads that do not find the requested data within the database and need to load the data from the Oracle database
cg.dynamic.local.misses.oracle.loads	Number of data load attempts from the Oracle database when servicing dynamic load misses for dynamic local cache groups
cg.dynamic.local.misses.oracle.loads.successes	Number of data loads from the Oracle database when servicing dynamic load misses for dynamic local cache groups
cg.dynamic.passthrough.count	Count of dynamic passthrough done: Number of dynamic loads that triggered passthrough

Table 1-10 Persistence (logging and checkpointing) statistics

Name	Description
log.buffer.insertions	Number of log records inserted into the log buffer
log.buffer.bytes_inserted	Number of bytes inserted into the log buffer
log.buffer.waits	Total number of waits experienced by all insertion processes
log.file.reads	Number of file system reads
log.file.writes	Number of file system writes
log.forces	Number of times the log is synched to disk
log.files.generated	Number of log files generated so far
log.file.earliest	Earliest log file that currently exists in the database
log.file.latest	Most recent log file present Same as LAST_LOG_FILE in SYS.MONITOR.
log.commit.bytes.read	Number of bytes read from the log for commit processing
log.commit.file.reads	Number of file system reads from the log for commit processing
log.recovery.bytes.read	Number of log bytes read during database recovery
ckpt.bytes_written	Number of bytes written for checkpointing
ckpt.writes	Number of checkpoint writes
ckpt.completed	Number of checkpoints completed
ckpt.completed.fuzzy	Number of fuzzy checkpoints completed
ckpt.bytes_written.during_recovery	Number of bytes written for checkpointing during database recovery

Table 1-11 User and system activity statistics

Name	Description
stmt.prepares.count	Number of statement prepares
stmt.prepares.command_cache_miss	Number of command cache misses during statement prepare
stmt.reprepares.count	Number of statement reprepares, including forced and automatic
stmt.reprepares.automatic	Number of automatic statement reprepares
stmt.executes.count	Number of SQL statements executed
stmt.executes.updates	Number of UPDATE statements executed
stmt.executes.deletes	Number of DELETE statements executed
stmt.executes.merges	Number of MERGE statements executed
stmt.executes.inserts	Number of INSERT statements executed
stmt.executes.selects	Number of SELECT statements executed
stmt.executes.alters	Number of ALTER statements executed
stmt.executes.creates	Number of CREATE statements executed
stmt.executes.drops	Number of DROP statements executed
txn.commits.count	Number of transactions committed
txn.commits.durable	Number of durable transaction commits
txn.commits.nondurable	Number of nondurable transaction commits
txn.commits.replicated.durable	Number of durable replicated transaction commits
txn.commits.replicated.nondurable	Number of nondurable replicated transaction commits
txn.commits.internal.replication	Number of replication-initiated transaction commits
txn.commits.internal.xla	Number of XLA-initiated transaction commits
txn.nonempty.rollbacks	Number of non-emtpy transaction rollbacks
txn.rollbacks	Number of transaction rollbacks
connections.established.count	Number of database connections established
connections.established.first.count	Number of first database connections established
connections.established.direct	Number of direct-linked database connections established
connections.established.client_server	Number of client/server connections established
connections.established.threshold_exceeded	Number of database connection threshold exceeded events
connections.disconnected	Number of database disconnects

Table 1-12 Database activity statistics

Name	Description
db.table.rows_read	Number of table rows read
db.table.rows_inserted	Number of table rows inserted
db.table.rows_updated	Number of table rows updated
db.table.rows_deleted	Number of table rows deleted
db.table.full_scans	Number of full table scans
db.index.rebuilds	Number of indexes rebuilt
db.index.hash.inserts	Number of rows inserted into hash indexes
db.index.hash.inserts.recovery_rebuild	Number of rows inserted into hash indexes during index rebuild phase of database recovery
db.index.hash.deletes	Number of rows deleted from hash indexes
db.index.hash.scans.count	Number of hash indexes scanned
db.index.hash.scans.repl	Number of hash indexes scanned during replication operations (such as insert, update and delete operations on tables)
db.index.hash.rows_fetched.count	Number of rows fetched from hash indexes
db.index.hash.rows_fetched.repl	Number of rows fetched from hash indexes during replication operations
db.index.range.inserts.count	Number of rows inserted into range indexes
db.index.range.inserts.recovery_rebuild	Number of rows inserted into range indexes during index rebuild phase of database recovery
db.index.range.deletes	Number of rows deleted from range indexes
db.index.range.updates	Number of rows updated on range indexes
db.index.range.scans.count	Number of range indexes scanned
db.index.range.scans.repl	Number of range indexes scanned during replication operations (such as insert, update and delete operations on tables)
db.index.range.rows_fetched.count	Number of rows fetched from range indexes
db.index.range.rows_fetched.repl	Number of rows fetched from range indexes during replication operations
db.index.temporary.created	Number of temporary indexes created
db.index.temporary.scans.count	Number of temporary indexes scanned
db.index.temporary.scans.repl	Number of temporary indexes scanned during replication operations
db.index.temporary.rows_fetched.count	Number of rows fetched from temporary indexes
db.index.temporary.rows_fetched.repl	Number of rows fetched from temporary indexes during replication operations
db.sorts	Number of sorts done
db.joins.nested_loop	Number of nested loop joins done
db.joins.merge	Number of merge joins done

Table 1-13 Locking statistics

Name	Description
lock.locks_granted.immediate	Number of locks granted immediately
lock.locks_granted.wait	Number of locks granted that required waiting
lock.timeouts	Number of lock timeouts
lock.deadlocks	Number of deadlocks
lock.locks_acquired.table_scans	Number of locks acquired for table scans
lock.locks_acquired.dml	Number of locks acquired for DML activity

Table 1-14 Replication statistics

Name	Description
txn.commits.internal.count	Number of internal transactions
txn.commits.internal.durable	Number of durable internal transactions
txn.commit.dml.on.success.bundle	Number of DML commit on success that can be bundled with execution

Table 1-15 Aging statistics

Name	Description
aging.timebased.cycles	Number of time-based aging cycles completed since the database was loaded into memory
aging.timebased.commits	Number of time-based aging commits done since the database was loaded into memory
aging.timebased.rows.deleted	Number of rows deleted during time-based aging since the database was loaded into memory
aging.timebased.rows.skipped	Number of rows that were not deleted using time-based aging because of lock contention since the database was loaded into memory
aging.lru.cycles	Number of LRU aging cycles completed since the database was loaded into memory
aging.lru.commits	Number of LRU aging commits done since the database was loaded into memory
aging.lru.rows.deleted	Number of rows deleted during LRU aging since the database was loaded into memory
aging.lru.rows.skipped	Number of rows that were not deleted using LRU aging because of lock contention since the database was loaded into memory
aging.lru.high_threshold_reached	Number of times LRU aging high threshold is reached since the database was loaded into memory
aging.lru.low_threshold_reached	Number of times LRU aging low threshold is reached since the database was loaded into memory
aging.row.lru.high_threshold_reached	Number of times LRU aging high row threshold is reached since the database was loaded into memory
aging.row.lru.low_threshold_reached	Number of times LRU aging low row threshold is reached since the database was loaded into memory

Table 1-16 Client/Server statistics

Name	Description
cs.server.executes.updates	Number of UPDATE statements executed by server
cs.server.executes.deletes	Number of DELETE statements executed by server
cs.server.executes.merges	Number of MERGE statements executed by server
cs.server.executes.inserts	Number of INSERT statements executed by server
cs.server.executes.selects	Number of SELECT statements executed by server
cs.server.executes.alters	Number of ALTER statements executed by server
cs.server.executes.creates	Number of CREATE statements executed by server
cs.server.executes.drops	Number of DROP statements executed by server
cs.server.commits.count	Number of transactions committed by server
cs.server.rollbacks	Number of transaction rollbacks by server
cs.server.rows_inserted	Number of table rows inserted by server
cs.server.rows_updated	Number of table rows updated by server
cs.server.rows_deleted	Number of table rows deleted by server
cs.server.roundtrips	Number of client/server round trips
cs.server.bytes.transmitted	Number of client/server bytes transmitted by server
cs.server.bytes.received	Number of client/server bytes received by server
cs.server.disconnected	Number of client/server disconnects

Table 1-17 Reclaim cache statistics

Name	Description
txn.commits.buf.overflowed	Number of commits that overflowed the buffer
log.flush.frames.latest	Number of frames in the most recent log flush
cg.dynamic.local.misses.oracle.loads.misses	Number of data misses on the Oracle database when servicing dynamic load misses for dynamic global cache groups
cg.dynamic.local.misses.oracle.loads.disconnects	Number of times the connection to Oracle was closed after performing a dynamic load
cg.ar.nondurable.commits	Number of times non-durable commit was used during refresh
cg.ar.flush.sync	Number of times flush and sync had been called because cache config CacheCommitDurable is set to 0
cg.dynamic.local.misses.logoff.retries	Number of times the LogOff had to be retried due to no connection being available when UseCacheConnPool and ConnNoWait are enabled

See also

SYS.MONITOR