--- title: Oracle TimesTen description: Monitor Oracle TimesTen database performance breadcrumbs: Docs > Integrations > Oracle TimesTen --- # Oracle TimesTen Supported OS marketplace Oracle TimesTen Datadog IntegrationStatus OverviewReplication MetricsSQL StatisticsDashboard Overview ## Overview{% #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{% #data-collected %} ### Metrics{% #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{% #service-checks %} **rapdev.oracle\_timesten** Returns `CRITICAL` if the agent can't retrieve Oracle TimesTen metrics, `OK` otherwise. *Statuses: ok, critical* ## Support{% #support %} For support or feature requests please contact RapDev.io through the following channels: - Email: [support@rapdev.io](mailto:support@rapdev.io) - Chat: [rapdev.io](https://www.rapdev.io/#Get-in-touch) - Phone: 855-857-0222 This application is made available through the Marketplace and is supported by a Datadog Technology Partner. Click Here to purchase this application.