SYS.SYSTEMSTATS
The SYSTEMSTATS
table stores system wide monitoring statistics.
Columns
Column name | Type | Description |
---|---|---|
|
|
Name of statistic |
|
|
Value of statistic |
|
|
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-6 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 ( |
cg.awt.sql_mode.updates.rows |
Number of rows updated on the Oracle database in SQL mode ( |
cg.awt.sql_mode.deletes.rows |
Number of rows deleted on the Oracle database in SQL mode ( |
cg.awt.sql_mode.inserts.batches |
Number of insert batches sent to the Oracle database in SQL mode ( |
cg.awt.sql_mode.updates.batches |
Number of update batches sent to the Oracle database in SQL mode ( |
cg.awt.sql_mode.deletes.batches |
Number of delete batches sent to the Oracle database in SQL mode ( |
cg.awt.sql_mode.bytes |
Number of bytes sent to the Oracle database in SQL mode ( |
cg.awt.sql_mode.batches |
Number of batches sent to the Oracle database in SQL mode ( |
cg.awt.plsql_mode.inserts.rows |
Number of rows inserted on the Oracle database in PL/SQL mode ( |
cg.awt.plsql_mode.updates.rows |
Number of rows updated on the Oracle database in PL/SQL mode ( |
cg.awt.plsql_mode.deletes.rows |
Number of rows deleted on the Oracle database in PL/SQL mode ( |
cg.awt.plsql_mode.bytes |
Number of bytes sent to the Oracle database in PL/SQL mode ( |
cg.awt.plsql_mode.batches |
Number of PL/SQL block batches sent to the Oracle database ( |
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-7 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-8 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-9 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-10 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-11 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 |
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-12 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 |
stmt.executes.deletes |
Number of |
stmt.executes.merges |
Number of |
stmt.executes.inserts |
Number of |
stmt.executes.selects |
Number of |
stmt.executes.alters |
Number of |
stmt.executes.creates |
Number of |
stmt.executes.drops |
Number of |
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.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-13 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-14 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-15 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-16 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-17 Client/Server statistics
Name | Description |
---|---|
cs.server.executes.updates |
Number of |
cs.server.executes.deletes |
Number of |
cs.server.executes.merges |
Number of |
cs.server.executes.inserts |
Number of |
cs.server.executes.selects |
Number of |
cs.server.executes.alters |
Number of |
cs.server.executes.creates |
Number of |
cs.server.executes.drops |
Number of |
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-18 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 |
cg.dynamic.local.misses.logoff.retries |
Number of times the LogOff had to be retried due to no connection being available when |
See also