This documentation has an index for AI agents at /llms.txt. A Markdown version of this page is available at https://explorer.opentelemetry.io/collector/components/contrib/oracledbreceiver.md.

Oracle DB Receiver

OpenTelemetry Collector receiver · contrib distribution

This receiver periodically queries an Oracle Database host to collect metrics.

  • Component ID: contrib-oracledbreceiver
  • Name: oracledbreceiver
  • Type: receiver
  • Distribution: contrib
  • Repository: opentelemetry-collector-contrib

Stability

LevelSignals
alphametrics
developmentlogs

Metrics

MetricTypeValue typeUnitStabilityEnabledAttributesDescription
oracledb.asm.disk.errorssum (monotonic)int{error}developmentnodisk.io.direction (string), oracledb.asm.disk.name (string), oracledb.asm.disk_group.name (string)Count of I/O errors on an ASM disk.
oracledb.asm.disk_group.capacitygaugeintBydevelopmentnooracledb.asm.disk_group.name (string)Total space in an ASM diskgroup.
oracledb.asm.disk_group.freegaugeintBydevelopmentnooracledb.asm.disk_group.name (string)Free space in an ASM diskgroup.
oracledb.asm.disk_group.offline_disksgaugeint{disk}developmentnooracledb.asm.disk_group.name (string)Count of disks currently offline within an ASM diskgroup.
oracledb.asm.disk_group.usable_freegaugeintBydevelopmentnooracledb.asm.disk_group.name (string)Free space that can safely be used for files after accounting for ASM redundancy and required mirror recovery capacity.
oracledb.buffer.inspectedsum (monotonic)int{buffer}developmentnooracledb.buffer.state (string)Number of buffers inspected from the end of the LRU queue while a process searched for a reusable buffer, grouped by buffer state.
oracledb.buffer.requestssum (monotonic)int{request}developmentnoNumber of times a reusable or free buffer was requested to create or load a block.
oracledb.buffer_cache.block.changessum (monotonic)int{change}developmentnoNumber of changes that were part of an update or delete operation made to blocks in the buffer cache.
oracledb.buffer_cache.block.changes.rategaugedouble{change}/sdevelopmentnooracle.db.pdb (string)Rate of changes applied to blocks in the buffer cache.
oracledb.buffer_cache.block.getssum (monotonic)int{get}developmentnoNumber of current-mode block gets satisfied from the buffer cache. Distinct from oracledb.db_block_gets, which counts all current-mode block gets requested regardless of where they are satisfied.
oracledb.buffer_cache.utilizationgaugedouble%developmentnooracle.db.pdb (string)Fraction of logical reads served from the buffer cache without physical I/O, as computed by Oracle V$SYSMETRIC (% (LogRead - PhyRead)/LogRead).
oracledb.call.countsum (monotonic)int{call}developmentnooracledb.call.type (string)Total count of calls issued to the database.
oracledb.call.recursive.cpu.timesum (monotonic)doublesdevelopmentnoTotal CPU time spent on recursive (internal) calls.
oracledb.checkpoint.bufferssum (monotonic)int{buffer}developmentnoNumber of buffers written by the Database Writer (DBWR) for checkpoints.
oracledb.checkpoint.completedsum (monotonic)int{checkpoint}developmentnoNumber of checkpoints completed by the Database Writer (DBWR).
oracledb.consistent_getssum (monotonic)int{gets}developmentnooracle.db.pdb (string)Number of times a consistent read was requested for a block from the buffer cache.
oracledb.cpu.usage.rategaugedouble1developmentnooracle.db.pdb (string)CPU consumption rate, in CPU-seconds used per second.
oracledb.cpu_timesum (monotonic)doublesdevelopmentyesoracle.db.pdb (string)Cumulative CPU time, in seconds
oracledb.cursor.cache.hitssum (monotonic)int{hit}developmentnoTotal count of session cursor cache hits, where an existing cached cursor is reused to avoid a soft parse.
oracledb.cursor.cache.sizegaugeint{cursor}developmentnoNumber of cursors currently held in the session cursor cache.
oracledb.cursor.cache.utilizationgaugedouble%developmentnooracle.db.pdb (string)Percentage of cursor executions that reused a cursor in the session cursor cache.
oracledb.cursor.opengaugeint{cursor}developmentnoNumber of currently open cursors in the Oracle instance.
oracledb.cursor.open.rategaugedouble{cursor}/sdevelopmentnooracle.db.pdb (string)Rate of cursors opened.
oracledb.data_dictionary.hit_ratiogaugedouble%developmentnoData dictionary cache hit ratio from v$rowcache.
oracledb.database.cpu.utilizationgaugedouble%developmentnooracle.db.pdb (string)Fraction of total database time spent on CPU, as computed by Oracle V$SYSMETRIC (% Cpu/DB_Time).
oracledb.database.wait.utilizationgaugedouble%developmentnooracle.db.pdb (string)Fraction of total database time spent waiting on I/O, locks, or latches, as computed by Oracle V$SYSMETRIC (% Wait/DB_Time).
oracledb.db.timesum (monotonic)doublesdevelopmentnooracledb.session.type (string)Total wall-clock time spent in database calls.
oracledb.db_block_getssum (monotonic)int{gets}developmentnooracle.db.pdb (string)Number of times a current block was requested from the buffer cache.
oracledb.ddl_statements_parallelizedsum (monotonic)int{statements}developmentnooracle.db.pdb (string)Number of DDL statements that were executed in parallel
oracledb.dml_locks.limitgaugeint{locks}developmentyesMaximum limit of active DML (Data Manipulation Language) locks, -1 if unlimited.
oracledb.dml_locks.usagegaugeint{locks}developmentyesCurrent count of active DML (Data Manipulation Language) locks.
oracledb.dml_statements_parallelizedsum (monotonic)int{statements}developmentnooracle.db.pdb (string)Number of DML statements that were executed in parallel
oracledb.enqueue.deadlocks.rategaugedouble{deadlock}/sdevelopmentnooracle.db.pdb (string)Rate of enqueue deadlocks.
oracledb.enqueue.operationssum (monotonic)int{operation}developmentnooracledb.enqueue.type (string)Total count of enqueue (lock) operations.
oracledb.enqueue.timeouts.rategaugedouble{timeout}/sdevelopmentnooracle.db.pdb (string)Rate of enqueue timeouts.
oracledb.enqueue_deadlockssum (monotonic)int{deadlocks}developmentyesoracle.db.pdb (string)Total number of deadlocks between table or row locks in different sessions.
oracledb.enqueue_locks.limitgaugeint{locks}developmentyesMaximum limit of active enqueue locks, -1 if unlimited.
oracledb.enqueue_locks.usagegaugeint{locks}developmentyesCurrent count of active enqueue locks.
oracledb.enqueue_resources.limitgaugeint{resources}developmentyesMaximum limit of active enqueue resources, -1 if unlimited.
oracledb.enqueue_resources.usagegaugeint{resources}developmentyesCurrent count of active enqueue resources.
oracledb.exchange_deadlockssum (monotonic)int{deadlocks}developmentyesoracle.db.pdb (string)Number of times that a process detected a potential deadlock when exchanging two buffers and raised an internal, restartable error. Index scans are the only operations that perform exchanges.
oracledb.execution.utilizationgaugedouble%developmentnooracle.db.pdb (string), oracledb.parse.type (string)Fraction of executions that did not require a parse, as computed by Oracle V$SYSMETRIC (% (ExecWOParse/TotalExec)). High values indicate good cursor reuse.
oracledb.executionssum (monotonic)int{executions}developmentyesoracle.db.pdb (string)Total number of calls (user and recursive) that executed SQL statements
oracledb.executions.rategaugedouble{execution}/sdevelopmentnooracle.db.pdb (string)Rate of SQL statement executions.
oracledb.gc.current_block.timesum (monotonic)doublesdevelopmentnonetwork.io.direction (string)Cumulative time spent transferring current blocks between instances over RAC cache fusion.
oracledb.hard_parsessum (monotonic)int{parses}developmentyesoracle.db.pdb (string)Number of hard parses
oracledb.hard_parses.rategaugedouble{parse}/sdevelopmentnooracle.db.pdb (string)Rate of hard parses.
oracledb.host.cpu.usage.rategaugedouble1developmentnoHost CPU consumption rate across all cores, in CPU-seconds used per second.
oracledb.host.cpu.utilizationgaugedouble%developmentnooracle.db.pdb (string)Fraction of host CPU time in use, as computed by Oracle V$SYSMETRIC (% Busy/(Idle+Busy)).
oracledb.io.requests.rategaugedouble{request}/sdevelopmentnoRate of I/O requests issued by the database.
oracledb.io.single_block.read.latencygaugedoublesdevelopmentnoAverage latency of a synchronous single-block read.
oracledb.io.throughput.rategaugedoubleBy/sdevelopmentnoRate of I/O bytes transferred by the database.
oracledb.jvm.memory.committedgaugeintBydevelopmentnoCommitted (total) size of Oracle's in-database JVM (OJVM) call heap.
oracledb.jvm.memory.livegaugeintBydevelopmentnoSize of live objects in Oracle's in-database JVM (OJVM) call heap.
oracledb.jvm.memory.usedgaugeintBydevelopmentnoUsed size of Oracle's in-database JVM (OJVM) call heap.
oracledb.library_cache.utilizationgaugedouble%developmentnooracle.db.pdb (string)Fraction of library cache pin requests that found the object already cached, as computed by Oracle V$SYSMETRIC (% Hits/Pins).
oracledb.lob.operationssum (monotonic)int{operation}developmentnodisk.io.direction (string)Total count of LOB (large object) I/O operations.
oracledb.lock.timesum (monotonic)doublesdevelopmentnooracle.db.pdb (string), oracledb.session.type (string)Cumulative time spent on transaction lock activity.
oracledb.logical_readssum (monotonic)int{reads}developmentyesoracle.db.pdb (string)Number of logical reads
oracledb.logical_reads.rategaugedouble{read}/sdevelopmentnooracle.db.pdb (string)Rate of logical reads performed by the database.
oracledb.logonssum (monotonic)int{operation}developmentnooracle.db.pdb (string)Number of logon operations
oracledb.logons.rategaugedouble{logon}/sdevelopmentnooracle.db.pdb (string)Rate of logon operations.
oracledb.os.swapssum (monotonic)int{swap}developmentnoNumber of OS swap operations.
oracledb.parallel_operations_downgraded_1_to_25_pctsum (monotonic)int{executions}developmentnooracle.db.pdb (string)Number of times parallel execution was requested and the degree of parallelism was reduced down to 1-25% because of insufficient parallel execution servers
oracledb.parallel_operations_downgraded_25_to_50_pctsum (monotonic)int{executions}developmentnooracle.db.pdb (string)Number of times parallel execution was requested and the degree of parallelism was reduced down to 25-50% because of insufficient parallel execution servers
oracledb.parallel_operations_downgraded_50_to_75_pctsum (monotonic)int{executions}developmentnooracle.db.pdb (string)Number of times parallel execution was requested and the degree of parallelism was reduced down to 50-75% because of insufficient parallel execution servers
oracledb.parallel_operations_downgraded_75_to_99_pctsum (monotonic)int{executions}developmentnooracle.db.pdb (string)Number of times parallel execution was requested and the degree of parallelism was reduced down to 75-99% because of insufficient parallel execution servers
oracledb.parallel_operations_downgraded_to_serialsum (monotonic)int{executions}developmentnooracle.db.pdb (string)Number of times parallel execution was requested but execution was serial because of insufficient parallel execution servers
oracledb.parallel_operations_not_downgradedsum (monotonic)int{executions}developmentnooracle.db.pdb (string)Number of times parallel execution was executed at the requested degree of parallelism
oracledb.parse.cpu.timesum (monotonic)doublesdevelopmentnoTotal CPU time spent on SQL parsing.
oracledb.parse.elapsed.timesum (monotonic)doublesdevelopmentnoTotal wall-clock time spent on SQL parsing.
oracledb.parse.rategaugedouble{parses}/sdevelopmentnooracle.db.pdb (string), oracledb.parse.result (string)Rate of parse operations per second broken down by result, as computed by Oracle V$SYSMETRIC (e.g., Parse Failure Count Per Sec).
oracledb.parse.utilizationgaugedouble%developmentnooracle.db.pdb (string)Fraction of parse calls that were soft parses, as computed by Oracle V$SYSMETRIC (% SoftParses/TotalParses). High values indicate good cursor reuse.
oracledb.parse_callssum (monotonic)int{parses}developmentyesoracle.db.pdb (string)Total number of parse calls.
oracledb.pga.cache.utilizationgaugedouble%developmentnoPercentage of PGA work-area memory requests satisfied without spilling to temporary disk.
oracledb.pga_memorysum (monotonic)intBydevelopmentyesoracle.db.pdb (string)Session PGA (Program Global Area) memory
oracledb.physical_io.cache_writessum (monotonic)int{writes}developmentnooracle.db.pdb (string)Number of physical writes from the buffer cache to disk by DBWR. Sourced from v$sysstat name physical writes from cache.
oracledb.physical_io.requestssum (monotonic)int{requests}developmentnodisk.io.block_size (string), disk.io.direction (string), oracle.db.pdb (string)Number of physical I/O requests issued to storage. Sourced from v$sysstat names physical read/write total IO requests (disk.io.block_size=all) and physical read/write total multi block requests (disk.io.block_size=multi).
oracledb.physical_io.requests.rategaugedouble{request}/sdevelopmentnodisk.io.direction (string), oracle.db.pdb (string)Rate of physical I/O requests issued to storage.
oracledb.physical_io.transferredsum (monotonic)intBydevelopmentnodisk.io.direction (string), disk.io.type (string), oracle.db.pdb (string)Total physical I/O bytes transferred between Oracle and storage. Sums across all data files. Sourced from v$sysstat names physical read/write bytes (disk.io.type=buffered) and physical read/write total bytes (disk.io.type=total).
oracledb.physical_io.transferred.rategaugedoubleBy/sdevelopmentnodisk.io.direction (string), oracle.db.pdb (string)Rate of physical I/O bytes transferred between Oracle and storage.
oracledb.physical_operations.rategaugedouble{operation}/sdevelopmentnodisk.io.direction (string), oracle.db.pdb (string)Rate of physical read and write operations performed by the database.
oracledb.physical_read_io_requestssum (monotonic)int{requests}developmentnooracle.db.pdb (string)Number of read requests for application activity
oracledb.physical_readssum (monotonic)int{reads}developmentyesoracle.db.pdb (string)Number of physical reads
oracledb.physical_reads_directsum (monotonic)int{reads}developmentnooracle.db.pdb (string)Number of reads directly from disk, bypassing the buffer cache
oracledb.physical_write_io_requestssum (monotonic)int{requests}developmentnooracle.db.pdb (string)Number of write requests for application activity
oracledb.physical_writessum (monotonic)int{writes}developmentnooracle.db.pdb (string)Number of physical writes
oracledb.physical_writes_directsum (monotonic)int{writes}developmentnooracle.db.pdb (string)Number of writes directly to disk, bypassing the buffer cache
oracledb.processes.limitgaugeint{processes}developmentyesMaximum limit of active processes, -1 if unlimited.
oracledb.processes.usagegaugeint{processes}developmentyesCurrent count of active processes.
oracledb.queries_parallelizedsum (monotonic)int{queries}developmentnooracle.db.pdb (string)Number of SELECT statements executed in parallel
oracledb.recovery.blockssum (monotonic)int{block}developmentnoNumber of blocks read during instance or media recovery.
oracledb.recycle_bin.limitgaugedoubleBydevelopmentnoTotal size of the recycle bin.
oracledb.redo.blockssum (monotonic)int{block}developmentnodisk.io.direction (string)Number of redo blocks moved between the redo log and storage.
oracledb.redo.operationssum (monotonic)int{operation}developmentnodisk.io.direction (string)Number of redo I/O operations.
oracledb.redo.requestssum (monotonic)int{request}developmentnooracledb.redo.request.type (string)Number of times a process requested space in the redo log buffer and had to wait.
oracledb.redo.retriessum (monotonic)int{retry}developmentnooracledb.redo.retry.type (string)Number of times a process waited and retried to allocate space in the redo buffer.
oracledb.redo.sizesum (monotonic)intBydevelopmentnoAmount of redo generated.
oracledb.redo.size.rategaugedoubleBy/sdevelopmentnooracle.db.pdb (string)Rate of redo bytes generated by the database.
oracledb.redo.timesum (monotonic)doublesdevelopmentnooracledb.redo.type (string)Time spent in each phase of the redo pipeline.
oracledb.redo_allocation.utilizationgaugedouble%developmentnooracle.db.pdb (string)Fraction of redo allocations that succeeded without space contention, as computed by Oracle V$SYSMETRIC (% (#Redo - RedoSpaceReq)/#Redo).
oracledb.scan.countsum (monotonic)int{operation}developmentnooracledb.scan.mode (string), oracledb.scan.type (string)Total count of scan operations.
oracledb.scan.table.rowssum (monotonic)int{row}developmentnoTotal number of rows returned by full-table scans.
oracledb.session.averagegaugedouble{session}developmentnooracle.db.pdb (string), session_status (string)Average number of sessions over the metric interval.
oracledb.session.stored_procedure.memorygaugeintBydevelopmentnooracle.db.pdb (string)Memory currently allocated for stored procedures in the session.
oracledb.session.wait.timesum (monotonic)doublesdevelopmentnooracle.db.pdb (string), oracledb.session.wait.state (string)Cumulative time sessions spent in waits.
oracledb.session.waitssum (monotonic)int{wait}developmentnooracle.db.pdb (string), oracledb.session.wait.state (string)Cumulative number of waits across sessions.
oracledb.sessions.limitgaugeint{sessions}developmentyesMaximum limit of active sessions, -1 if unlimited.
oracledb.sessions.usagegaugeint{sessions}developmentyesoracle.db.pdb (string), session_status (string), session_type (string)Count of active sessions.
oracledb.sga.limitgaugeintBydevelopmentnoMaximum size of the System Global Area (SGA).
oracledb.sga.usagegaugeintBydevelopmentnooracledb.sga.component.name (string)Size of each component of the System Global Area (SGA).
oracledb.shared_pool.utilizationgaugedouble%developmentnooracle.db.pdb (string)Fraction of the shared pool that is currently free, as computed by Oracle V$SYSMETRIC (% Free/Total). Low values indicate shared pool pressure.
oracledb.smon.postssum (monotonic)int{post}developmentnooracledb.smon.type (string)Number of times SMON was posted to perform recovery.
oracledb.sort.operationssum (monotonic)int{operation}developmentnooracledb.sort.type (string)Total count of sort operations.
oracledb.sort.ratiogaugedouble1developmentnooracle.db.pdb (string), oracledb.sort.type (string)Fraction of sorts performed in memory vs disk, as computed by Oracle V$SYSMETRIC (% MemSort/(MemSort + DiskSort)). Low values indicate PGA memory pressure.
oracledb.sort.rowssum (monotonic)int{row}developmentnoTotal number of rows sorted across all sort operations.
oracledb.sql_service.response.durationgaugedoublesdevelopmentnooracle.db.pdb (string)Average SQL service response time in seconds, converted from centiseconds as reported by Oracle V$SYSMETRIC (CentiSeconds Per Call).
oracledb.sqlnet.io.transferredsum (monotonic)intBydevelopmentnodestination.type (string), network.io.direction (string), oracle.db.pdb (string)Bytes transferred via SQL*Net between Oracle and clients/dblinks. Sourced from v$sysstat names bytes received/sent via SQL*Net from/to client/dblink.
oracledb.storage.usagegaugedoubleBydevelopmentnoUsed database storage size from dba_data_files and dba_free_space.
oracledb.storage.utilizationgaugedouble1developmentnoFraction of allocated database storage that is used.
oracledb.system.cpu.countgaugeint{cpu}developmentnoNumber of CPUs or processors available to the Oracle server, as reported by the operating system.
oracledb.system.memory.limitgaugeintBydevelopmentnoTotal number of bytes of physical memory on the host running the Oracle server.
oracledb.system.process.countgaugedouble{process}developmentnoCurrent number of processes that are either running or in the ready state, waiting to be selected by the operating-system scheduler to run.
oracledb.tablespace.limitgaugeintBydevelopmentnooracle.db.pdb (string), tablespace_name (string)Maximum autoextend size of tablespace in bytes. Returns 0 for temporary tablespaces and tablespaces without autoextend enabled.
oracledb.tablespace.statussumint{tablespace}developmentnooracle.db.pdb (string), oracledb.tablespace.state (string), tablespace_name (string)Current status of tablespaces, broken down by state. A timeseries is produced for every possible value of oracledb.tablespace.state; the value is 1 for a tablespace's current state, and 0 for all other states.
oracledb.tablespace.utilizationgaugedouble1developmentnooracle.db.pdb (string), tablespace_name (string)Fraction of tablespace currently in use, expressed as a value between 0 and 1.
oracledb.tablespace_size.limitgaugeintBydevelopmentyesoracle.db.pdb (string), tablespace_name (string)Maximum size of tablespace in bytes, -1 if unlimited.
oracledb.tablespace_size.usagegaugeintBydevelopmentyesoracle.db.pdb (string), tablespace_name (string)Used tablespace in bytes.
oracledb.transaction.response.timegaugedoublesdevelopmentnooracle.db.pdb (string)Average response time per transaction.
oracledb.transaction.rollbackssum (monotonic)int{rollback}developmentnooracle.db.pdb (string)Total number of transactions rolled back.
oracledb.transactions.limitgaugeint{transactions}developmentyesMaximum limit of active transactions, -1 if unlimited.
oracledb.transactions.rategaugedouble{transaction}/sdevelopmentnooracle.db.pdb (string), oracledb.transaction.type (string)Rate of user transactions.
oracledb.transactions.usagegaugeint{transactions}developmentyesCurrent count of active transactions.
oracledb.user_commitssum (monotonic)int{commits}developmentyesoracle.db.pdb (string)Number of user commits. When a user commits a transaction, the redo generated that reflects the changes made to database blocks must be written to disk. Commits often represent the closest thing to a user transaction rate.
oracledb.user_rollbackssum (monotonic)int1developmentyesoracle.db.pdb (string)Number of times users manually issue the ROLLBACK statement or an error occurs during a user's transactions

Attributes

AttributeTypeDescription
client.addressstringHostname or address of the client.
client.portintTCP port used by the client.
db.namespacestringThe database name.
db.query.comment_tagsstringFiltered SQL query comments extracted from leading block comments. Contains comma-separated key=value pairs for keys specified in allowed_comment_keys configuration. Used for correlation with APM traces.
db.query.textstringThe text of the database query being executed.
db.server.namestringThe name of the server hosting the database.
db.system.namestringThe database management system (DBMS) product as identified by the client instrumentation.
destination.typestringType of the SQL*Net destination endpoint (client application or remote database link).
disk.io.block_sizestringMulti-block vs single-block (all) I/O request grouping.
disk.io.directionstringDirection of the storage I/O operation.
disk.io.typestringWhether the I/O bytes are buffered (cache-mediated) or total (raw transfer count).
network.io.directionstringDirection of the network transfer.
network.peer.addressstringIP address of the peer client.
network.peer.portintTCP port used by the peer client.
oracle.db.pdbstringThe name of the pluggable database (PDB) the data point belongs to. Emit one data point per PDB on CDB-root connections and one per direct-PDB connection; empty otherwise. When disabled, per-PDB collection is skipped and each metric emits a single instance-wide data point.
oracle.db.servicestringThe Oracle service name associated with the database connection.
oracledb.application_wait_timedoubleThe total time (in seconds) a query spent waiting on the application before it could proceed with execution (reporting delta).
oracledb.asm.disk.namestringThe name of the ASM disk.
oracledb.asm.disk_group.namestringThe name of the ASM diskgroup.
oracledb.blocking.blocker.root_sidstringThe session ID (SID) of the root/head blocker at the top of the blocking chain. Empty string when there is no blocking.
oracledb.blocking.blocker.sidstringThe session ID (SID) of the immediate blocker of this session. Empty string when the session is not blocked.
oracledb.blocking.blocker.statestringThe status of the blocking session relationship (e.g. VALID, NOT IN WAIT, GLOBAL, NO HOLDER, UNKNOWN).
oracledb.blocking.lock.modestringThe lock mode being requested by the blocked session (e.g., ROW SHARE, ROW EXCLUSIVE, SHARE, SHARE ROW EXCLUSIVE, EXCLUSIVE). Empty when not waiting on a lock.
oracledb.blocking.lock.typestringThe type of enqueue lock the session is waiting on, extracted from the wait event (e.g., TX for row lock, TM for table lock). Empty when not waiting on a lock.
oracledb.blocking.object.namestringThe name of the database object the session is waiting to lock. Empty when no object lock wait is active.
oracledb.blocking.object.ownerstringThe owner (schema) of the database object the session is waiting to lock. Empty when no object lock wait is active.
oracledb.blocking.start_timestringEstimated UTC timestamp of when the blocking wait began, derived from SYSDATE - SECONDS_IN_WAIT. RFC3339 format.
oracledb.blocking.wait_durationintThe number of seconds this session has been waiting for the current wait event.
oracledb.buffer.statestringThe state of a buffer encountered while inspecting the LRU queue for a reusable buffer (free = a reusable buffer that was skipped; dirty = a dirty buffer found).
oracledb.buffer_getsintNumber of logical reads (i.e., buffer cache accesses) performed by a query (reporting delta).
oracledb.call.typestringType of call reported by Oracle.
oracledb.child_addressstringAddress of the child cursor.
oracledb.child_numberstringThe child number of the query.
oracledb.cluster_wait_timedoubleTotal time (in seconds) that a query waited due to Oracle Real Application Clusters (RAC) coordination (reporting delta).
oracledb.command_typeintCommand type of the query.
oracledb.concurrency_wait_timedoubleTotal time (in seconds) a query spent waiting on concurrency-related events (reporting delta).
oracledb.cpu_timedoubleTotal time (in seconds) that the CPU spent actively processing a query, excluding time spent waiting (reporting delta).
oracledb.direct_readsintThe number of direct path reads performed by a query — i.e., data blocks read directly from disk into the session’s memory (reporting delta).
oracledb.direct_writesintThe number of direct path write operations, where data is written directly to disk from user memory (reporting delta).
oracledb.disk_readsintThe number of physical reads a query performs — that is, the number of data blocks read from disk (reporting delta).
oracledb.duration_secdoubleTotal time taken by a database query to execute.
oracledb.elapsed_timedoubleThe total time (in seconds) taken by a query from start to finish, including CPU time and all types of waits (reporting delta).
oracledb.enqueue.typestringType of enqueue (lock) operation reported by Oracle.
oracledb.eventstringThe specific wait event that a query or session is currently experiencing.
oracledb.executionsintThe number of times a specific SQL query has been executed (reporting delta).
oracledb.modulestringLogical module name of the client application that initiated a query or session.
oracledb.osuserstringName of the operating system user that initiated or is running the Oracle database session.
oracledb.parse.resultstringResult of a parse operation (e.g., failure).
oracledb.parse.typestringType of parse operation (e.g., soft).
oracledb.physical_read_bytesintThe total number of bytes read from disk by a query (reporting delta).
oracledb.physical_read_requestsintThe number of physical I/O read operations performed by a query (reporting delta).
oracledb.physical_write_bytesintThe total number of bytes written to disk by a query (reporting delta).
oracledb.physical_write_requestsintThe number of times a query requested to write data to disk (reporting delta).
oracledb.plan.first_loadstringTime at which the plan was first loaded into the library cache, in the server's local timezone. Format: YYYY-MM-DD/HH:MM:SS
oracledb.plan.last_loadstringPlan load time in the server's local timezone. Format: YYYY-MM-DD/HH:MM:SS
oracledb.plan_hash_valuestringNumeric representation of the execution plan.
oracledb.procedure_execution_countintThe number of times the stored procedure has been executed, derived from the minimum statement execution count across all statements in the procedure (reporting delta). Please note, this is best effort and may not be accurate in some scenarios. Use with caution.
oracledb.procedure_idintThe identifier of the stored procedure or function being executed by the query.
oracledb.procedure_namestringName of the database object that a query is accessing.
oracledb.procedure_typestringType of the database object that a query is accessing.
oracledb.processstringThe operating system process ID (PID) associated with a session.
oracledb.programstringName of the client program or tool that initiated the Oracle database session.
oracledb.query.startedstringThe timestamp when the SQL statement started execution, in ISO 8601 format (UTC).
oracledb.query.wait_timedoubleThe wait time in seconds. If the session is currently waiting, the value is the time spent waiting in the current wait. Returns 0 if the session is not currently waiting.
oracledb.query_planstringThe query execution plan used by the SQL Server.
oracledb.redo.request.typestringThe type of redo log buffer space request.
oracledb.redo.retry.typestringThe type of redo buffer allocation retry.
oracledb.redo.typestringThe phase of the redo pipeline that a redo time measurement is attributed to.
oracledb.rows_processedintThe total number of rows that a query has read, returned, or affected during its execution (reporting delta).
oracledb.scan.modestringExecution mode of the scan reported by Oracle.
oracledb.scan.typestringType of scan operation reported by Oracle.
oracledb.schemanamestringOracle schema under which SQL statements are being executed
oracledb.serialstringSerial number associated with a session.
oracledb.session.durationdoubleThe total time in seconds that the session has been connected.
oracledb.session.startedstringThe timestamp when the session logged on, in ISO 8601 format (UTC).
oracledb.session.typestringClass of session the activity is attributed to.
oracledb.session.wait.statestringWhether the session wait time/count is for idle or non-idle wait events.
oracledb.sga.component.namestringName of the SGA component.
oracledb.sidstringID of the Oracle Server session.
oracledb.smon.typestringType of recovery SMON was posted to perform.
oracledb.sort.typestringType of sort operation (e.g., memory, disk).
oracledb.sql_idstringThe SQL ID of the query.
oracledb.statestringCurrent state of the query or the session executing it.
oracledb.statusstringExecution state or result of a database query or session.
oracledb.tablespace.statestringTablespace state as reported by Oracle (e.g. online, offline, read only)
oracledb.transaction.typestringThe type of user transaction.
oracledb.user_io_wait_timedoubleThe total time (in seconds) a query spent waiting for user I/O operations—such as reading or writing data to disk or network file systems (reporting delta).
oracledb.wait.countintNumber of times the session has waited on the wait event.
oracledb.wait.durationdoubleTotal time waited in seconds for the wait event.
oracledb.wait.timeoutsintNumber of the session's waits on the wait event that timed out.
oracledb.wait_classstringThe category of wait events a query or session is currently experiencing in Oracle Database.
session_statusstringSession status
session_typestringSession type
tablespace_namestringTablespace name
user.namestringDatabase user name under which a session is connected to

Data

  • JSON (latest): /data/collector/components/contrib-oracledbreceiver/latest.json
  • JSON (pinned): /data/collector/components/contrib-oracledbreceiver/contrib-oracledbreceiver-b7374b837250.json
  • Explore: /collector/components/contrib/oracledbreceiver