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
| Level | Signals |
|---|---|
| alpha | metrics |
| development | logs |
Attributes
| Attribute | Type | Description |
|---|---|---|
client.address | string | Hostname or address of the client. |
client.port | int | TCP port used by the client. |
db.namespace | string | The database name. |
db.query.comment_tags | string | Filtered 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.text | string | The text of the database query being executed. |
db.server.name | string | The name of the server hosting the database. |
db.system.name | string | The database management system (DBMS) product as identified by the client instrumentation. |
destination.type | string | Type of the SQL*Net destination endpoint (client application or remote database link). |
disk.io.block_size | string | Multi-block vs single-block (all) I/O request grouping. |
disk.io.direction | string | Direction of the storage I/O operation. |
disk.io.type | string | Whether the I/O bytes are buffered (cache-mediated) or total (raw transfer count). |
network.io.direction | string | Direction of the SQL*Net network transfer. |
network.peer.address | string | IP address of the peer client. |
network.peer.port | int | TCP port used by the peer client. |
oracle.db.service | string | The Oracle service name associated with the database connection. |
oracledb.application_wait_time | double | The total time (in seconds) a query spent waiting on the application before it could proceed with execution (reporting delta). |
oracledb.blocking.blocker.root_sid | string | The 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.sid | string | The session ID (SID) of the immediate blocker of this session. Empty string when the session is not blocked. |
oracledb.blocking.blocker.state | string | The status of the blocking session relationship (e.g. VALID, NOT IN WAIT, GLOBAL, NO HOLDER, UNKNOWN). |
oracledb.blocking.lock.mode | string | The 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.type | string | The 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.name | string | The name of the database object the session is waiting to lock. Empty when no object lock wait is active. |
oracledb.blocking.object.owner | string | The owner (schema) of the database object the session is waiting to lock. Empty when no object lock wait is active. |
oracledb.blocking.start_time | string | Estimated UTC timestamp of when the blocking wait began, derived from SYSDATE - SECONDS_IN_WAIT. RFC3339 format. |
oracledb.blocking.wait_duration | int | The number of seconds this session has been waiting for the current wait event. |
oracledb.buffer.state | string | The 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_gets | int | Number of logical reads (i.e., buffer cache accesses) performed by a query (reporting delta). |
oracledb.call.type | string | Type of call reported by Oracle. |
oracledb.child_address | string | Address of the child cursor. |
oracledb.child_number | string | The child number of the query. |
oracledb.cluster_wait_time | double | Total time (in seconds) that a query waited due to Oracle Real Application Clusters (RAC) coordination (reporting delta). |
oracledb.command_type | int | Command type of the query. |
oracledb.concurrency_wait_time | double | Total time (in seconds) a query spent waiting on concurrency-related events (reporting delta). |
oracledb.cpu_time | double | Total time (in seconds) that the CPU spent actively processing a query, excluding time spent waiting (reporting delta). |
oracledb.direct_reads | int | The 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_writes | int | The number of direct path write operations, where data is written directly to disk from user memory (reporting delta). |
oracledb.disk_reads | int | The number of physical reads a query performs — that is, the number of data blocks read from disk (reporting delta). |
oracledb.duration_sec | double | Total time taken by a database query to execute. |
oracledb.elapsed_time | double | The total time (in seconds) taken by a query from start to finish, including CPU time and all types of waits (reporting delta). |
oracledb.enqueue.type | string | Type of enqueue (lock) operation reported by Oracle. |
oracledb.event | string | The specific wait event that a query or session is currently experiencing. |
oracledb.executions | int | The number of times a specific SQL query has been executed (reporting delta). |
oracledb.module | string | Logical module name of the client application that initiated a query or session. |
oracledb.osuser | string | Name of the operating system user that initiated or is running the Oracle database session. |
oracledb.parse.result | string | Result of a parse operation (e.g., failure). |
oracledb.parse.type | string | Type of parse operation (e.g., soft). |
oracledb.physical_read_bytes | int | The total number of bytes read from disk by a query (reporting delta). |
oracledb.physical_read_requests | int | The number of physical I/O read operations performed by a query (reporting delta). |
oracledb.physical_write_bytes | int | The total number of bytes written to disk by a query (reporting delta). |
oracledb.physical_write_requests | int | The number of times a query requested to write data to disk (reporting delta). |
oracledb.plan.first_load | string | Time 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_load | string | Plan load time in the server's local timezone. Format: YYYY-MM-DD/HH:MM:SS |
oracledb.plan_hash_value | string | Binary hash value calculated on the query execution plan and used to identify similar query execution plans, reported in the HEX format. |
oracledb.procedure_execution_count | int | The 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_id | int | The identifier of the stored procedure or function being executed by the query. |
oracledb.procedure_name | string | Name of the database object that a query is accessing. |
oracledb.procedure_type | string | Type of the database object that a query is accessing. |
oracledb.process | string | The operating system process ID (PID) associated with a session. |
oracledb.program | string | Name of the client program or tool that initiated the Oracle database session. |
oracledb.query.started | string | The timestamp when the SQL statement started execution, in ISO 8601 format (UTC). |
oracledb.query.wait_time | double | The 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_plan | string | The query execution plan used by the SQL Server. |
oracledb.redo.request.type | string | The type of redo log buffer space request. |
oracledb.redo.retry.type | string | The type of redo buffer allocation retry. |
oracledb.redo.type | string | The phase of the redo pipeline that a redo time measurement is attributed to. |
oracledb.rows_processed | int | The total number of rows that a query has read, returned, or affected during its execution (reporting delta). |
oracledb.scan.mode | string | Execution mode of the scan reported by Oracle. |
oracledb.scan.type | string | Type of scan operation reported by Oracle. |
oracledb.schemaname | string | Oracle schema under which SQL statements are being executed |
oracledb.serial | string | Serial number associated with a session. |
oracledb.session.duration | double | The total time in seconds that the session has been connected. |
oracledb.session.started | string | The timestamp when the session logged on, in ISO 8601 format (UTC). |
oracledb.session.type | string | Class of session the database time is attributed to. |
oracledb.sid | string | ID of the Oracle Server session. |
oracledb.sort.type | string | Type of sort operation (e.g., memory, disk). |
oracledb.sql_id | string | The SQL ID of the query. |
oracledb.state | string | Current state of the query or the session executing it. |
oracledb.status | string | Execution state or result of a database query or session. |
oracledb.user_io_wait_time | double | The 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.count | int | Total number of waits for the wait event across all sessions. |
oracledb.wait.duration | double | Total time waited in seconds for the wait event. |
oracledb.wait_class | string | The category of wait events a query or session is currently experiencing in Oracle Database. |
session_status | string | Session status |
session_type | string | Session type |
tablespace_name | string | Tablespace name |
user.name | string | Database user name under which a session is connected to |