Oracle TimesTen

Supported OS Linux

marketplace

Overview

The Oracle TimesTen integration enables you to monitor your TimesTen in-memory databases. This integration covers over 200 metrics and provides details about your top queries, database status, execution times, and much more.

The integration includes an out-of-the-box dashboard that shows an overview of your TimesTen databases’ status and metrics.

Data Collected

Metrics

rapdev.oracle_timesten.SQL_Sort_by_Executions
(gauge)
rapdev.oracle_timesten.Non_ParseExecsPerc
(gauge)

Shown as percent
rapdev.oracle_timesten.LogBufferNoWaitPerc
(gauge)

Shown as percent
rapdev.oracle_timesten.LockHitPerc
(gauge)

Shown as percent
rapdev.oracle_timesten.CommandCacheHitPerc
(gauge)

Shown as percent
rapdev.oracle_timesten.SQL_Sort_by_Preparations
(gauge)
rapdev.oracle_timesten.memory.db.size.temp_in_use.kb
(gauge)

Shown as byte
rapdev.oracle_timesten.memory.db.size.temp_high_water_mark.kb
(gauge)

Shown as byte
rapdev.oracle_timesten.memory.db.size.temp_allocated.kb
(gauge)

Shown as byte
rapdev.oracle_timesten.memory.db.size.perm_in_use.kb
(gauge)

Shown as byte
rapdev.oracle_timesten.memory.db.size.perm_high_water_mark.kb
(gauge)

Shown as byte
rapdev.oracle_timesten.memory.db.size.perm_allocated.kb
(gauge)

Shown as byte
rapdev.oracle_timesten.memory.connections.established.threshold_exceeded
(gauge)

Shown as connection
rapdev.oracle_timesten.memory.connections.established.first.count
(gauge)

Shown as connection
rapdev.oracle_timesten.memory.connections.established.direct
(gauge)

Shown as connection
rapdev.oracle_timesten.memory.connections.established.count
(gauge)

Shown as connection
rapdev.oracle_timesten.memory.connections.established.client_server
(gauge)

Shown as connection
rapdev.oracle_timesten.memory.connections.disconnected
(gauge)

Shown as connection
rapdev.oracle_timesten.awt.zzzinternal.repl.transmitter.drift.requests
(gauge)
rapdev.oracle_timesten.awt.zzinternal.repl.transmitter.send.lag
(gauge)
rapdev.oracle_timesten.awt.zzinternal.repl.transmitter.max.adapted.timeout
(gauge)
rapdev.oracle_timesten.awt.zzinternal.repl.transmitter.max.actions
(gauge)
rapdev.oracle_timesten.awt.zzinternal.repl.transmitter.longest.running
(gauge)
rapdev.oracle_timesten.awt.zzinternal.repl.transmitter.longest.batch
(gauge)
rapdev.oracle_timesten.awt.zzinternal.repl.transmitter.log.waits
(gauge)

Shown as wait
rapdev.oracle_timesten.awt.zzinternal.repl.transmitter.log.wait_sleeps
(gauge)

Shown as wait
rapdev.oracle_timesten.awt.zzinternal.repl.transmitter.catch.lag
(gauge)
rapdev.oracle_timesten.awt.zzinternal.repl.transmitter.bulk.inserts.sent
(gauge)
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.wait.stall.lt.2
(gauge)

Shown as wait
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.wait.stall.gt.5
(gauge)

Shown as wait
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.wait.stall.2.to.5
(gauge)

Shown as wait
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.wait.backoffs
(gauge)

Shown as wait
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.txn.opt.time
(gauge)
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.txn.commit.waitspincounts
(gauge)

Shown as wait
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.txn.commit.waits
(gauge)

Shown as wait
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.txn.commit.nowaitcounts
(gauge)

Shown as wait
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.txn.commit.maxspinpertxn
(gauge)

Shown as commit
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.txn.commit.counts
(gauge)

Shown as commit
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.txn.begin.waits
(gauge)

Shown as wait
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.transient.errors
(gauge)
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.serial.modes
(gauge)
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.permanent.errors
(gauge)
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.longest.running
(gauge)
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.longest.batch
(gauge)
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.deadlock.wakeups
(gauge)
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.bulk.inserts.applied
(gauge)
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.batch.commit.time
(gauge)

Shown as commit
rapdev.oracle_timesten.awt.zzinternal.repl.receiver.batch.commit.counts
(gauge)

Shown as commit
rapdev.oracle_timesten.awt.zzinternal.log.trackswitch.out.timeout
(gauge)
rapdev.oracle_timesten.awt.zzinternal.log.trackswitch.out.busy
(gauge)
rapdev.oracle_timesten.awt.zzinternal.log.trackswitch.in.timeout
(gauge)
rapdev.oracle_timesten.awt.zzinternal.log.trackswitch.in.busy
(gauge)
rapdev.oracle_timesten.awt.zzinternal.log.track.wait
(gauge)

Shown as wait
rapdev.oracle_timesten.awt.zzinternal.log.track.arbitration
(gauge)
rapdev.oracle_timesten.Reloads
(gauge)
rapdev.oracle_timesten.Pins
(gauge)
rapdev.oracle_timesten.PinHits
(gauge)
rapdev.oracle_timesten.PinHitRatio
(gauge)
rapdev.oracle_timesten.Invalidations
(gauge)
rapdev.oracle_timesten.Gets
(gauge)
rapdev.oracle_timesten.GetHits
(gauge)
rapdev.oracle_timesten.GetHitRatio
(gauge)
rapdev.oracle_timesten.DeferredCleanups
(gauge)
rapdev.oracle_timesten.CurrentConnectionMemory
(gauge)
rapdev.oracle_timesten.loghold.Checkpoint_hold_lsn
(gauge)
rapdev.oracle_timesten.zzinternal.stmt.executes.updates.versioned.temp_table
(gauge)

Shown as update
rapdev.oracle_timesten.zzinternal.stmt.executes.updates.versioned.system_table
(gauge)

Shown as update
rapdev.oracle_timesten.zzinternal.stmt.executes.updates.versioned.serial_scan
(gauge)

Shown as update
rapdev.oracle_timesten.zzinternal.stmt.executes.updates.versioned.multi_partitions
(gauge)

Shown as update
rapdev.oracle_timesten.zzinternal.stmt.executes.updates.versioned.matview
(gauge)

Shown as update
rapdev.oracle_timesten.zzinternal.stmt.executes.updates.versioned.log_not_writable
(gauge)

Shown as update
rapdev.oracle_timesten.zzinternal.stmt.executes.updates.versioned.lob
(gauge)

Shown as update
rapdev.oracle_timesten.zzinternal.stmt.executes.updates.versioned.index
(gauge)

Shown as update
rapdev.oracle_timesten.zzinternal.stmt.executes.updates.versioned.disabled_ipu
(gauge)

Shown as update
rapdev.oracle_timesten.zzinternal.stmt.executes.updates.versioned.compressed_col
(gauge)

Shown as update
rapdev.oracle_timesten.zzinternal.stmt.executes.updates.versioned
(gauge)

Shown as update
rapdev.oracle_timesten.zzinternal.stmt.executes.updates.inplace
(gauge)

Shown as update
rapdev.oracle_timesten.stmt.reprepares.count
(gauge)
rapdev.oracle_timesten.stmt.reprepares.automatic
(gauge)
rapdev.oracle_timesten.stmt.prepares.count
(gauge)
rapdev.oracle_timesten.stmt.prepares.command_cache_miss
(gauge)
rapdev.oracle_timesten.stmt.executes.updates
(gauge)

Shown as execution
rapdev.oracle_timesten.stmt.executes.selects
(gauge)

Shown as execution
rapdev.oracle_timesten.stmt.executes.merges
(gauge)

Shown as execution
rapdev.oracle_timesten.stmt.executes.inserts
(gauge)

Shown as execution
rapdev.oracle_timesten.stmt.executes.drops
(gauge)

Shown as execution
rapdev.oracle_timesten.stmt.executes.deletes
(gauge)

Shown as execution
rapdev.oracle_timesten.stmt.executes.creates
(gauge)

Shown as execution
rapdev.oracle_timesten.stmt.executes.count
(gauge)

Shown as execution
rapdev.oracle_timesten.stmt.executes.alters
(gauge)

Shown as execution
rapdev.oracle_timesten.loghold.Replication_hold_lsn
(gauge)
rapdev.oracle_timesten.zzinternal.db.table.rows_updated.versioned.nonzero_refcount
(gauge)
rapdev.oracle_timesten.zzinternal.db.table.rows_updated.versioned
(gauge)
rapdev.oracle_timesten.zzinternal.db.table.rows_updated.inplace
(gauge)
rapdev.oracle_timesten.zzinternal.db.table.page_frees
(gauge)
rapdev.oracle_timesten.zzinternal.db.table.page_allocs
(gauge)
rapdev.oracle_timesten.zzinternal.db.index.range.gc.signalled
(gauge)
rapdev.oracle_timesten.zzinternal.db.index.range.gc.freed
(gauge)
rapdev.oracle_timesten.zzinternal.db.index.range.btree.split
(gauge)
rapdev.oracle_timesten.zzinternal.db.index.range.btree.right_most_insert
(gauge)
rapdev.oracle_timesten.zzinternal.db.index.range.btree.restart
(gauge)
rapdev.oracle_timesten.zzinternal.db.index.range.btree.node_unlinked
(gauge)
rapdev.oracle_timesten.zzinternal.db.index.range.btree.node_allocated_freelist
(gauge)
rapdev.oracle_timesten.zzinternal.db.index.range.btree.node_allocated
(gauge)
rapdev.oracle_timesten.zzinternal.db.index.range.btree.merge
(gauge)
rapdev.oracle_timesten.zzinternal.db.index.range.btree.lock_wait
(gauge)

Shown as wait
rapdev.oracle_timesten.zzinternal.db.index.range.btree.balance
(gauge)
rapdev.oracle_timesten.db.tpl_fetches
(gauge)

Shown as task
rapdev.oracle_timesten.db.tpl_exec
(gauge)

Shown as task
rapdev.oracle_timesten.db.table.rows_updated
(gauge)

Shown as task
rapdev.oracle_timesten.db.table.rows_read
(gauge)

Shown as task
rapdev.oracle_timesten.db.table.rows_inserted
(gauge)

Shown as task
rapdev.oracle_timesten.db.table.rows_deleted
(gauge)

Shown as task
rapdev.oracle_timesten.db.table.full_scans
(gauge)

Shown as task
rapdev.oracle_timesten.db.sorts
(gauge)

Shown as task
rapdev.oracle_timesten.db.size.temp_in_use.kb
(gauge)

Shown as task
rapdev.oracle_timesten.db.size.temp_high_water_mark.kb
(gauge)

Shown as task
rapdev.oracle_timesten.db.size.temp_allocated.kb
(gauge)

Shown as task
rapdev.oracle_timesten.db.size.perm_in_use.kb
(gauge)

Shown as task
rapdev.oracle_timesten.db.size.perm_high_water_mark.kb
(gauge)

Shown as task
rapdev.oracle_timesten.db.size.perm_allocated.kb
(gauge)

Shown as task
rapdev.oracle_timesten.db.passthroughs
(gauge)

Shown as task
rapdev.oracle_timesten.db.joins.nested_loop
(gauge)

Shown as task
rapdev.oracle_timesten.db.joins.merge
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.temporary.scans.repl
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.temporary.scans.count
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.temporary.rows_fetched.repl
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.temporary.rows_fetched.count
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.temporary.created
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.rebuilds
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.range.updates
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.range.scans.repl
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.range.scans.count
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.range.rows_fetched.repl
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.range.rows_fetched.count
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.range.inserts.recovery_rebuild
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.range.inserts.count
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.range.deletes
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.hash.scans.repl
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.hash.scans.count
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.hash.rows_fetched.repl
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.hash.rows_fetched.count
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.hash.inserts.recovery_rebuild
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.hash.inserts
(gauge)

Shown as task
rapdev.oracle_timesten.db.index.hash.deletes
(gauge)

Shown as task
rapdev.oracle_timesten.db.cache_hits
(gauge)

Shown as task
rapdev.oracle_timesten.UpdatesPerTxn
(gauge)
rapdev.oracle_timesten.UpdatesPerSec
(gauge)
rapdev.oracle_timesten.TotalParsesPerTxn
(gauge)
rapdev.oracle_timesten.TotalParsesPerSec
(gauge)
rapdev.oracle_timesten.TempIndexesCreated
(gauge)
rapdev.oracle_timesten.SortsPerTxn
(gauge)
rapdev.oracle_timesten.SortsPerSec
(gauge)
rapdev.oracle_timesten.SelectPerTxn
(gauge)
rapdev.oracle_timesten.SelectPerSec
(gauge)
rapdev.oracle_timesten.RowsPerRead
(gauge)
rapdev.oracle_timesten.RollbackPerTxn
(gauge)
rapdev.oracle_timesten.RollbackPerSec
(gauge)
rapdev.oracle_timesten.Log_Send_LSN_E
(gauge)
rapdev.oracle_timesten.Log_Send_LSN_B
(gauge)
rapdev.oracle_timesten.LogWritesPerTxn
(gauge)

Shown as write
rapdev.oracle_timesten.LogWritesPerSec
(gauge)

Shown as write
rapdev.oracle_timesten.LogReadsforCommitPerTxn
(gauge)

Shown as commit
rapdev.oracle_timesten.LogReadsforCommitPerSec
(gauge)

Shown as commit
rapdev.oracle_timesten.LogReadsPerTxn
(gauge)

Shown as read
rapdev.oracle_timesten.LogReadsPerSec
(gauge)

Shown as read
rapdev.oracle_timesten.LogBytesPerTxn
(gauge)

Shown as byte
rapdev.oracle_timesten.LogBytesPerSec
(gauge)

Shown as byte
rapdev.oracle_timesten.LogBufWaitsPerTxn
(gauge)

Shown as wait
rapdev.oracle_timesten.LogBufWaitsPerSec
(gauge)

Shown as wait
rapdev.oracle_timesten.InsertsPerTxn
(gauge)

Shown as task
rapdev.oracle_timesten.InsertsPerSec
(gauge)

Shown as task
rapdev.oracle_timesten.HardParsesPerTxn
(gauge)

Shown as task
rapdev.oracle_timesten.HardParsesPerSec
(gauge)

Shown as task
rapdev.oracle_timesten.DurableCommitPerTxn
(gauge)

Shown as commit
rapdev.oracle_timesten.DurableCommitPerSec
(gauge)

Shown as commit
rapdev.oracle_timesten.DeletesPerTxn
(gauge)

Shown as task
rapdev.oracle_timesten.DeletesPerSec
(gauge)

Shown as task
rapdev.oracle_timesten.CkptSizePerTxn
(gauge)

Shown as task
rapdev.oracle_timesten.CkptSizePerSec
(gauge)

Shown as task
rapdev.oracle_timesten.zzinternal.repl.transmitter.log.waits
(gauge)

Shown as wait
rapdev.oracle_timesten.zzinternal.repl.transmitter.log.wait_sleeps
(gauge)

Shown as wait
rapdev.oracle_timesten.zzinternal.log.strand_switches.strand_full
(gauge)
rapdev.oracle_timesten.zzinternal.log.strand_switches.insertion_latch_held
(gauge)
rapdev.oracle_timesten.zzinternal.log.buffer.insertions.fast_path
(gauge)
rapdev.oracle_timesten.zzinternal.log.buffer.bytes_inserted.fast_path
(gauge)
rapdev.oracle_timesten.txn.rollbacks
(gauge)
rapdev.oracle_timesten.txn.commits.replicated.nondurable
(gauge)

Shown as commit
rapdev.oracle_timesten.txn.commits.replicated.durable
(gauge)

Shown as commit
rapdev.oracle_timesten.txn.commits.nondurable
(gauge)

Shown as commit
rapdev.oracle_timesten.txn.commits.internal.xla
(gauge)

Shown as commit
rapdev.oracle_timesten.txn.commits.internal.replication
(gauge)

Shown as commit
rapdev.oracle_timesten.txn.commits.internal.durable
(gauge)

Shown as commit
rapdev.oracle_timesten.txn.commits.internal.count
(gauge)

Shown as commit
rapdev.oracle_timesten.txn.commits.durable
(gauge)

Shown as commit
rapdev.oracle_timesten.txn.commits.count
(gauge)

Shown as commit
rapdev.oracle_timesten.txn.commits.buf.overflowed
(gauge)

Shown as commit
rapdev.oracle_timesten.txn.commit.dml.on.success.bundle
(gauge)

Shown as commit
rapdev.oracle_timesten.log.recovery.bytes.read
(gauge)
rapdev.oracle_timesten.log.log_bytes_per_transaction
(gauge)
rapdev.oracle_timesten.log.last_log_lfn
(gauge)
rapdev.oracle_timesten.log.forces
(gauge)
rapdev.oracle_timesten.log.flush.frames.latest
(gauge)
rapdev.oracle_timesten.log.files.generated
(gauge)
rapdev.oracle_timesten.log.file.writes
(gauge)
rapdev.oracle_timesten.log.file.reads
(gauge)
rapdev.oracle_timesten.log.file.latest
(gauge)
rapdev.oracle_timesten.log.file.earliest
(gauge)
rapdev.oracle_timesten.log.commit.file.reads
(gauge)

Shown as read
rapdev.oracle_timesten.log.commit.bytes.read
(gauge)

Shown as read
rapdev.oracle_timesten.log.buffer.waits
(gauge)

Shown as wait
rapdev.oracle_timesten.log.buffer.insertions
(gauge)
rapdev.oracle_timesten.log.buffer.bytes_inserted
(gauge)
rapdev.oracle_timesten.ckpt.writes
(gauge)
rapdev.oracle_timesten.ckpt.completed.fuzzy
(gauge)
rapdev.oracle_timesten.ckpt.completed
(gauge)
rapdev.oracle_timesten.ckpt.bytes_written_MB
(gauge)
rapdev.oracle_timesten.ckpt.bytes_written.during_recovery_MB
(gauge)
rapdev.oracle_timesten.reportduration
(gauge)

Shown as time
rapdev.oracle_timesten.TPS_E
(gauge)

Shown as task
rapdev.oracle_timesten.TPS_B
(gauge)

Shown as task
rapdev.oracle_timesten.RPS_E
(gauge)

Shown as task
rapdev.oracle_timesten.RPS_B
(gauge)

Shown as task
rapdev.oracle_timesten.Log_Behind_E
(gauge)

Shown as task
rapdev.oracle_timesten.Log_Behind_B
(gauge)

Shown as task
rapdev.oracle_timesten.Latency_E
(gauge)

Shown as task
rapdev.oracle_timesten.Latency_B
(gauge)

Shown as task

Service Checks

rapdev.oracle_timesten

Returns CRITICAL if the agent can’t retrieve Oracle TimesTen metrics, OK otherwise.

Statuses: ok, critical

Support

For support or feature requests please contact RapDev.io through the following channels:


This application is made available through the Marketplace and is supported by a Datadog Technology Partner. Click Here to purchase this application.