Oracle TimesTen

Supported OS Linux

marketplace
Cette page n'est pas encore disponible en français, sa traduction est en cours.
Si vous avez des questions ou des retours sur notre projet de traduction actuel, n'hésitez pas à nous contacter.

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.