Configuration reference for Oracle Database monitoring with NRDOT

This reference provides comprehensive YAML configurations for Oracle Database monitoring with the New Relic Distribution of OpenTelemetry (NRDOT) Collector. These full-feature configurations include the complete Oracle Database metric catalog for production environments across on-host, RDS, and ADB deployments.

중요

Looking to get started quickly? These are advanced configurations for production use. If you're setting up Oracle Database monitoring for the first time, we recommend starting with the standard configuration in our setup guides and returning to these comprehensive configurations once you've verified basic functionality.

On-host

This configuration includes the complete Oracle Database metric catalog, with every metric enabled, for comprehensive visibility when monitoring an individual pluggable database.

Oracle PDB Hostname/IP

Oracle PDB Port

Database Username

Database Password

PDB Service Name

New Relic OTLP Endpoint

New Relic License Key

oracle-config.yaml

1
receivers:
2
    nroracledb:
3
      endpoint: oracle.example.com:1521
4
      username: newrelic
5
      password: YOUR_PASSWORD
6
      service: YOUR_PDB_SERVICE_NAME
7
      collection_interval: 15s
8
      events:
9
        db.server.query_sample:
10
          enabled: true
11
        db.server.top_query:
12
          enabled: true
13
        db.server.session.wait_sample:
14
          enabled: true
15
        db.server.top_procedure:
16
          enabled: true
17
        db.server.query_plan:
18
          enabled: true
19

20
      top_query_collection:
21
        max_query_sample_count: 1000
22
        top_query_count: 200
23
        collection_interval: 60s
24
        allowed_comment_keys:
25
          - nr_service_guid
26

27
      query_sample_collection:
28
        max_rows_per_query: 100
29
        allowed_comment_keys:
30
          - nr_service_guid
31

32
      session_wait_event_collection:
33
        max_rows_per_query: 100
34

35
      top_procedure_collection:
36
        max_procedure_sample_count: 1000
37
        top_procedure_count: 250
38
        collection_interval: 60s
39

40
      metrics:
41
        oracledb.asm.disk.errors:
42
          enabled: true
43
          attributes:
44
            - oracledb.asm.disk_group.name
45
            - oracledb.asm.disk.name
46
            - disk.io.direction
47
        oracledb.asm.disk_group.capacity:
48
          enabled: true
49
          attributes:
50
            - oracledb.asm.disk_group.name
51
        oracledb.asm.disk_group.free:
52
          enabled: true
53
          attributes:
54
            - oracledb.asm.disk_group.name
55
        oracledb.asm.disk_group.offline_disks:
56
          enabled: true
57
          attributes:
58
            - oracledb.asm.disk_group.name
59
        oracledb.asm.disk_group.usable_free:
60
          enabled: true
61
          attributes:
62
            - oracledb.asm.disk_group.name
63
        oracledb.buffer.inspected:
64
          enabled: true
65
          attributes:
66
            - oracledb.buffer.state
67
        oracledb.buffer.requests:
68
          enabled: true
69
        oracledb.buffer_cache.block.changes:
70
          enabled: true
71
        oracledb.buffer_cache.block.changes.rate:
72
          enabled: true
73
          attributes:
74
            - oracle.db.pdb
75
        oracledb.buffer_cache.block.gets:
76
          enabled: true
77
        oracledb.buffer_cache.utilization:
78
          enabled: true
79
          attributes:
80
            - oracle.db.pdb
81
        oracledb.call.count:
82
          enabled: true
83
          attributes:
84
            - oracledb.call.type
85
        oracledb.call.recursive.cpu.time:
86
          enabled: true
87
        oracledb.checkpoint.buffers:
88
          enabled: true
89
        oracledb.checkpoint.completed:
90
          enabled: true
91
        oracledb.consistent_gets:
92
          enabled: true
93
          attributes:
94
            - oracle.db.pdb
95
        oracledb.cpu.usage.rate:
96
          enabled: true
97
          attributes:
98
            - oracle.db.pdb
99
        oracledb.cpu_time:
100
          enabled: true
101
          attributes:
102
            - oracle.db.pdb
103
        oracledb.cursor.cache.hits:
104
          enabled: true
105
        oracledb.cursor.cache.size:
106
          enabled: true
107
        oracledb.cursor.cache.utilization:
108
          enabled: true
109
          attributes:
110
            - oracle.db.pdb
111
        oracledb.cursor.open:
112
          enabled: true
113
        oracledb.cursor.open.rate:
114
          enabled: true
115
          attributes:
116
            - oracle.db.pdb
117
        oracledb.data_dictionary.hit_ratio:
118
          enabled: true
119
        oracledb.database.cpu.utilization:
120
          enabled: true
121
          attributes:
122
            - oracle.db.pdb
123
        oracledb.database.wait.utilization:
124
          enabled: true
125
          attributes:
126
            - oracle.db.pdb
127
        oracledb.db.time:
128
          enabled: true
129
          attributes:
130
            - oracledb.session.type
131
        oracledb.db_block_gets:
132
          enabled: true
133
          attributes:
134
            - oracle.db.pdb
135
        oracledb.ddl_statements_parallelized:
136
          enabled: true
137
          attributes:
138
            - oracle.db.pdb
139
        oracledb.dml_locks.limit:
140
          enabled: true
141
        oracledb.dml_locks.usage:
142
          enabled: true
143
        oracledb.dml_statements_parallelized:
144
          enabled: true
145
          attributes:
146
            - oracle.db.pdb
147
        oracledb.enqueue.deadlocks.rate:
148
          enabled: true
149
          attributes:
150
            - oracle.db.pdb
151
        oracledb.enqueue.operations:
152
          enabled: true
153
          attributes:
154
            - oracledb.enqueue.type
155
        oracledb.enqueue.timeouts.rate:
156
          enabled: true
157
          attributes:
158
            - oracle.db.pdb
159
        oracledb.enqueue_deadlocks:
160
          enabled: true
161
          attributes:
162
            - oracle.db.pdb
163
        oracledb.enqueue_locks.limit:
164
          enabled: true
165
        oracledb.enqueue_locks.usage:
166
          enabled: true
167
        oracledb.enqueue_resources.limit:
168
          enabled: true
169
        oracledb.enqueue_resources.usage:
170
          enabled: true
171
        oracledb.exchange_deadlocks:
172
          enabled: true
173
          attributes:
174
            - oracle.db.pdb
175
        oracledb.execution.utilization:
176
          enabled: true
177
          attributes:
178
            - oracledb.parse.type
179
            - oracle.db.pdb
180
        oracledb.executions:
181
          enabled: true
182
          attributes:
183
            - oracle.db.pdb
184
        oracledb.executions.rate:
185
          enabled: true
186
          attributes:
187
            - oracle.db.pdb
188
        oracledb.gc.current_block.time:
189
          enabled: true
190
          attributes:
191
            - network.io.direction
192
        oracledb.hard_parses:
193
          enabled: true
194
          attributes:
195
            - oracle.db.pdb
196
        oracledb.hard_parses.rate:
197
          enabled: true
198
          attributes:
199
            - oracle.db.pdb
200
        oracledb.host.cpu.usage.rate:
201
          enabled: true
202
        oracledb.host.cpu.utilization:
203
          enabled: true
204
          attributes:
205
            - oracle.db.pdb
206
        oracledb.io.requests.rate:
207
          enabled: true
208
        oracledb.io.single_block.read.latency:
209
          enabled: true
210
        oracledb.io.throughput.rate:
211
          enabled: true
212
        oracledb.jvm.memory.committed:
213
          enabled: true
214
        oracledb.jvm.memory.live:
215
          enabled: true
216
        oracledb.jvm.memory.used:
217
          enabled: true
218
        oracledb.library_cache.utilization:
219
          enabled: true
220
          attributes:
221
            - oracle.db.pdb
222
        oracledb.lob.operations:
223
          enabled: true
224
          attributes:
225
            - disk.io.direction
226
        oracledb.lock.time:
227
          enabled: true
228
          attributes:
229
            - oracle.db.pdb
230
            - oracledb.session.type
231
        oracledb.logical_reads:
232
          enabled: true
233
          attributes:
234
            - oracle.db.pdb
235
        oracledb.logical_reads.rate:
236
          enabled: true
237
          attributes:
238
            - oracle.db.pdb
239
        oracledb.logons:
240
          enabled: true
241
          attributes:
242
            - oracle.db.pdb
243
        oracledb.logons.rate:
244
          enabled: true
245
          attributes:
246
            - oracle.db.pdb
247
        oracledb.os.swaps:
248
          enabled: true
249
        oracledb.parallel_operations_downgraded_1_to_25_pct:
250
          enabled: true
251
          attributes:
252
            - oracle.db.pdb
253
        oracledb.parallel_operations_downgraded_25_to_50_pct:
254
          enabled: true
255
          attributes:
256
            - oracle.db.pdb
257
        oracledb.parallel_operations_downgraded_50_to_75_pct:
258
          enabled: true
259
          attributes:
260
            - oracle.db.pdb
261
        oracledb.parallel_operations_downgraded_75_to_99_pct:
262
          enabled: true
263
          attributes:
264
            - oracle.db.pdb
265
        oracledb.parallel_operations_downgraded_to_serial:
266
          enabled: true
267
          attributes:
268
            - oracle.db.pdb
269
        oracledb.parallel_operations_not_downgraded:
270
          enabled: true
271
          attributes:
272
            - oracle.db.pdb
273
        oracledb.parse.cpu.time:
274
          enabled: true
275
        oracledb.parse.elapsed.time:
276
          enabled: true
277
        oracledb.parse.rate:
278
          enabled: true
279
          attributes:
280
            - oracledb.parse.result
281
            - oracle.db.pdb
282
        oracledb.parse.utilization:
283
          enabled: true
284
          attributes:
285
            - oracle.db.pdb
286
        oracledb.parse_calls:
287
          enabled: true
288
          attributes:
289
            - oracle.db.pdb
290
        oracledb.pga.cache.utilization:
291
          enabled: true
292
        oracledb.pga_memory:
293
          enabled: true
294
          attributes:
295
            - oracle.db.pdb
296
        oracledb.physical_io.cache_writes:
297
          enabled: true
298
          attributes:
299
            - oracle.db.pdb
300
        oracledb.physical_io.requests:
301
          enabled: true
302
          attributes:
303
            - disk.io.direction
304
            - disk.io.block_size
305
            - oracle.db.pdb
306
        oracledb.physical_io.requests.rate:
307
          enabled: true
308
          attributes:
309
            - disk.io.direction
310
            - oracle.db.pdb
311
        oracledb.physical_io.transferred:
312
          enabled: true
313
          attributes:
314
            - disk.io.direction
315
            - disk.io.type
316
            - oracle.db.pdb
317
        oracledb.physical_io.transferred.rate:
318
          enabled: true
319
          attributes:
320
            - disk.io.direction
321
            - oracle.db.pdb
322
        oracledb.physical_operations.rate:
323
          enabled: true
324
          attributes:
325
            - disk.io.direction
326
            - oracle.db.pdb
327
        oracledb.physical_read_io_requests:
328
          enabled: true
329
          attributes:
330
            - oracle.db.pdb
331
        oracledb.physical_reads:
332
          enabled: true
333
          attributes:
334
            - oracle.db.pdb
335
        oracledb.physical_reads_direct:
336
          enabled: true
337
          attributes:
338
            - oracle.db.pdb
339
        oracledb.physical_write_io_requests:
340
          enabled: true
341
          attributes:
342
            - oracle.db.pdb
343
        oracledb.physical_writes:
344
          enabled: true
345
          attributes:
346
            - oracle.db.pdb
347
        oracledb.physical_writes_direct:
348
          enabled: true
349
          attributes:
350
            - oracle.db.pdb
351
        oracledb.processes.limit:
352
          enabled: true
353
        oracledb.processes.usage:
354
          enabled: true
355
        oracledb.queries_parallelized:
356
          enabled: true
357
          attributes:
358
            - oracle.db.pdb
359
        oracledb.recovery.blocks:
360
          enabled: true
361
        oracledb.recycle_bin.limit:
362
          enabled: true
363
        oracledb.redo.blocks:
364
          enabled: true
365
          attributes:
366
            - disk.io.direction
367
        oracledb.redo.operations:
368
          enabled: true
369
          attributes:
370
            - disk.io.direction
371
        oracledb.redo.requests:
372
          enabled: true
373
          attributes:
374
            - oracledb.redo.request.type
375
        oracledb.redo.retries:
376
          enabled: true
377
          attributes:
378
            - oracledb.redo.retry.type
379
        oracledb.redo.size:
380
          enabled: true
381
        oracledb.redo.size.rate:
382
          enabled: true
383
          attributes:
384
            - oracle.db.pdb
385
        oracledb.redo.time:
386
          enabled: true
387
          attributes:
388
            - oracledb.redo.type
389
        oracledb.redo_allocation.utilization:
390
          enabled: true
391
          attributes:
392
            - oracle.db.pdb
393
        oracledb.scan.count:
394
          enabled: true
395
          attributes:
396
            - oracledb.scan.type
397
            - oracledb.scan.mode
398
        oracledb.scan.table.rows:
399
          enabled: true
400
        oracledb.session.average:
401
          enabled: true
402
          attributes:
403
            - session_status
404
            - oracle.db.pdb
405
        oracledb.session.stored_procedure.memory:
406
          enabled: true
407
          attributes:
408
            - oracle.db.pdb
409
        oracledb.session.wait.time:
410
          enabled: true
411
          attributes:
412
            - oracledb.session.wait.state
413
            - oracle.db.pdb
414
        oracledb.session.waits:
415
          enabled: true
416
          attributes:
417
            - oracledb.session.wait.state
418
            - oracle.db.pdb
419
        oracledb.sessions.limit:
420
          enabled: true
421
        oracledb.sessions.usage:
422
          enabled: true
423
          attributes:
424
            - session_type
425
            - session_status
426
            - oracle.db.pdb
427
        oracledb.sga.limit:
428
          enabled: true
429
        oracledb.sga.usage:
430
          enabled: true
431
          attributes:
432
            - oracledb.sga.component.name
433
        oracledb.shared_pool.utilization:
434
          enabled: true
435
          attributes:
436
            - oracle.db.pdb
437
        oracledb.smon.posts:
438
          enabled: true
439
          attributes:
440
            - oracledb.smon.type
441
        oracledb.sort.operations:
442
          enabled: true
443
          attributes:
444
            - oracledb.sort.type
445
        oracledb.sort.ratio:
446
          enabled: true
447
          attributes:
448
            - oracledb.sort.type
449
            - oracle.db.pdb
450
        oracledb.sort.rows:
451
          enabled: true
452
        oracledb.sql_service.response.duration:
453
          enabled: true
454
          attributes:
455
            - oracle.db.pdb
456
        oracledb.sqlnet.io.transferred:
457
          enabled: true
458
          attributes:
459
            - network.io.direction
460
            - destination.type
461
            - oracle.db.pdb
462
        oracledb.storage.usage:
463
          enabled: true
464
        oracledb.storage.utilization:
465
          enabled: true
466
        oracledb.system.cpu.count:
467
          enabled: true
468
        oracledb.system.memory.limit:
469
          enabled: true
470
        oracledb.system.process.count:
471
          enabled: true
472
        oracledb.tablespace.limit:
473
          enabled: true
474
          attributes:
475
            - tablespace_name
476
            - oracle.db.pdb
477
        oracledb.tablespace.status:
478
          enabled: true
479
          attributes:
480
            - tablespace_name
481
            - oracledb.tablespace.state
482
            - oracle.db.pdb
483
        oracledb.tablespace.utilization:
484
          enabled: true
485
          attributes:
486
            - tablespace_name
487
            - oracle.db.pdb
488
        oracledb.tablespace_size.limit:
489
          enabled: true
490
          attributes:
491
            - tablespace_name
492
            - oracle.db.pdb
493
        oracledb.tablespace_size.usage:
494
          enabled: true
495
          attributes:
496
            - tablespace_name
497
            - oracle.db.pdb
498
        oracledb.transaction.response.time:
499
          enabled: true
500
          attributes:
501
            - oracle.db.pdb
502
        oracledb.transaction.rollbacks:
503
          enabled: true
504
          attributes:
505
            - oracle.db.pdb
506
        oracledb.transactions.limit:
507
          enabled: true
508
        oracledb.transactions.rate:
509
          enabled: true
510
          attributes:
511
            - oracledb.transaction.type
512
            - oracle.db.pdb
513
        oracledb.transactions.usage:
514
          enabled: true
515
        oracledb.user_commits:
516
          enabled: true
517
          attributes:
518
            - oracle.db.pdb
519
        oracledb.user_rollbacks:
520
          enabled: true
521
          attributes:
522
            - oracle.db.pdb
523

524
      # Resource attributes attached to all metrics/logs (all enabled by default)
525
      resource_attributes:
526
        oracle.db.edition:
527
          enabled: true
528
exporters:
529
    otlp/newrelic:
530
      endpoint: https://otlp.nr-data.net:4318
531
      headers:
532
        api-key: YOUR_LICENSE_KEY
533
      compression: gzip
534
      retry_on_failure:
535
        enabled: true
536
        initial_interval: 5s
537
        max_interval: 30s
538
        max_elapsed_time: 300s
539
      sending_queue:
540
        enabled: true
541
        sizer: bytes
542
        queue_size: 100_000_000
543
        num_consumers: 10
544
        batch:
545
          sizer: bytes
546
          max_size: 1_000_000
547
          min_size: 0
548
          flush_timeout: 5s
549
service:
550
    pipelines:
551
      metrics/oracledb:
552
        receivers: [nroracledb]
553
        exporters: [otlp/newrelic]
554
      logs/oracledb:
555
        receivers: [nroracledb]
556
        exporters: [otlp/newrelic]

This configuration includes the complete Oracle Database metric catalog, with every metric enabled, for comprehensive visibility when monitoring an entire container database and all its pluggable databases.

Oracle CDB Hostname/IP

Oracle CDB Port

Database Username (without the C## prefix)

Database Password

CDB Service Name

New Relic OTLP Endpoint

New Relic License Key

oracle-config.yaml

1
receivers:
2
    nroracledb:
3
      endpoint: oracle.example.com:1521
4
      username: C##newrelic
5
      password: YOUR_PASSWORD
6
      service: YOUR_CDB_SERVICE_NAME
7
      collection_interval: 15s
8
      events:
9
        db.server.query_sample:
10
          enabled: true
11
        db.server.top_query:
12
          enabled: true
13
        db.server.session.wait_sample:
14
          enabled: true
15
        db.server.top_procedure:
16
          enabled: true
17
        db.server.query_plan:
18
          enabled: true
19

20
      top_query_collection:
21
        max_query_sample_count: 1000
22
        top_query_count: 200
23
        collection_interval: 60s
24
        allowed_comment_keys:
25
          - nr_service_guid
26

27
      query_sample_collection:
28
        max_rows_per_query: 100
29
        allowed_comment_keys:
30
          - nr_service_guid
31

32
      session_wait_event_collection:
33
        max_rows_per_query: 100
34

35
      top_procedure_collection:
36
        max_procedure_sample_count: 1000
37
        top_procedure_count: 250
38
        collection_interval: 60s
39

40
      metrics:
41
        oracledb.asm.disk.errors:
42
          enabled: true
43
          attributes:
44
            - oracledb.asm.disk_group.name
45
            - oracledb.asm.disk.name
46
            - disk.io.direction
47
        oracledb.asm.disk_group.capacity:
48
          enabled: true
49
          attributes:
50
            - oracledb.asm.disk_group.name
51
        oracledb.asm.disk_group.free:
52
          enabled: true
53
          attributes:
54
            - oracledb.asm.disk_group.name
55
        oracledb.asm.disk_group.offline_disks:
56
          enabled: true
57
          attributes:
58
            - oracledb.asm.disk_group.name
59
        oracledb.asm.disk_group.usable_free:
60
          enabled: true
61
          attributes:
62
            - oracledb.asm.disk_group.name
63
        oracledb.buffer.inspected:
64
          enabled: true
65
          attributes:
66
            - oracledb.buffer.state
67
        oracledb.buffer.requests:
68
          enabled: true
69
        oracledb.buffer_cache.block.changes:
70
          enabled: true
71
        oracledb.buffer_cache.block.changes.rate:
72
          enabled: true
73
          attributes:
74
            - oracle.db.pdb
75
        oracledb.buffer_cache.block.gets:
76
          enabled: true
77
        oracledb.buffer_cache.utilization:
78
          enabled: true
79
          attributes:
80
            - oracle.db.pdb
81
        oracledb.call.count:
82
          enabled: true
83
          attributes:
84
            - oracledb.call.type
85
        oracledb.call.recursive.cpu.time:
86
          enabled: true
87
        oracledb.checkpoint.buffers:
88
          enabled: true
89
        oracledb.checkpoint.completed:
90
          enabled: true
91
        oracledb.consistent_gets:
92
          enabled: true
93
          attributes:
94
            - oracle.db.pdb
95
        oracledb.cpu.usage.rate:
96
          enabled: true
97
          attributes:
98
            - oracle.db.pdb
99
        oracledb.cpu_time:
100
          enabled: true
101
          attributes:
102
            - oracle.db.pdb
103
        oracledb.cursor.cache.hits:
104
          enabled: true
105
        oracledb.cursor.cache.size:
106
          enabled: true
107
        oracledb.cursor.cache.utilization:
108
          enabled: true
109
          attributes:
110
            - oracle.db.pdb
111
        oracledb.cursor.open:
112
          enabled: true
113
        oracledb.cursor.open.rate:
114
          enabled: true
115
          attributes:
116
            - oracle.db.pdb
117
        oracledb.data_dictionary.hit_ratio:
118
          enabled: true
119
        oracledb.database.cpu.utilization:
120
          enabled: true
121
          attributes:
122
            - oracle.db.pdb
123
        oracledb.database.wait.utilization:
124
          enabled: true
125
          attributes:
126
            - oracle.db.pdb
127
        oracledb.db.time:
128
          enabled: true
129
          attributes:
130
            - oracledb.session.type
131
        oracledb.db_block_gets:
132
          enabled: true
133
          attributes:
134
            - oracle.db.pdb
135
        oracledb.ddl_statements_parallelized:
136
          enabled: true
137
          attributes:
138
            - oracle.db.pdb
139
        oracledb.dml_locks.limit:
140
          enabled: true
141
        oracledb.dml_locks.usage:
142
          enabled: true
143
        oracledb.dml_statements_parallelized:
144
          enabled: true
145
          attributes:
146
            - oracle.db.pdb
147
        oracledb.enqueue.deadlocks.rate:
148
          enabled: true
149
          attributes:
150
            - oracle.db.pdb
151
        oracledb.enqueue.operations:
152
          enabled: true
153
          attributes:
154
            - oracledb.enqueue.type
155
        oracledb.enqueue.timeouts.rate:
156
          enabled: true
157
          attributes:
158
            - oracle.db.pdb
159
        oracledb.enqueue_deadlocks:
160
          enabled: true
161
          attributes:
162
            - oracle.db.pdb
163
        oracledb.enqueue_locks.limit:
164
          enabled: true
165
        oracledb.enqueue_locks.usage:
166
          enabled: true
167
        oracledb.enqueue_resources.limit:
168
          enabled: true
169
        oracledb.enqueue_resources.usage:
170
          enabled: true
171
        oracledb.exchange_deadlocks:
172
          enabled: true
173
          attributes:
174
            - oracle.db.pdb
175
        oracledb.execution.utilization:
176
          enabled: true
177
          attributes:
178
            - oracledb.parse.type
179
            - oracle.db.pdb
180
        oracledb.executions:
181
          enabled: true
182
          attributes:
183
            - oracle.db.pdb
184
        oracledb.executions.rate:
185
          enabled: true
186
          attributes:
187
            - oracle.db.pdb
188
        oracledb.gc.current_block.time:
189
          enabled: true
190
          attributes:
191
            - network.io.direction
192
        oracledb.hard_parses:
193
          enabled: true
194
          attributes:
195
            - oracle.db.pdb
196
        oracledb.hard_parses.rate:
197
          enabled: true
198
          attributes:
199
            - oracle.db.pdb
200
        oracledb.host.cpu.usage.rate:
201
          enabled: true
202
        oracledb.host.cpu.utilization:
203
          enabled: true
204
          attributes:
205
            - oracle.db.pdb
206
        oracledb.io.requests.rate:
207
          enabled: true
208
        oracledb.io.single_block.read.latency:
209
          enabled: true
210
        oracledb.io.throughput.rate:
211
          enabled: true
212
        oracledb.jvm.memory.committed:
213
          enabled: true
214
        oracledb.jvm.memory.live:
215
          enabled: true
216
        oracledb.jvm.memory.used:
217
          enabled: true
218
        oracledb.library_cache.utilization:
219
          enabled: true
220
          attributes:
221
            - oracle.db.pdb
222
        oracledb.lob.operations:
223
          enabled: true
224
          attributes:
225
            - disk.io.direction
226
        oracledb.lock.time:
227
          enabled: true
228
          attributes:
229
            - oracle.db.pdb
230
            - oracledb.session.type
231
        oracledb.logical_reads:
232
          enabled: true
233
          attributes:
234
            - oracle.db.pdb
235
        oracledb.logical_reads.rate:
236
          enabled: true
237
          attributes:
238
            - oracle.db.pdb
239
        oracledb.logons:
240
          enabled: true
241
          attributes:
242
            - oracle.db.pdb
243
        oracledb.logons.rate:
244
          enabled: true
245
          attributes:
246
            - oracle.db.pdb
247
        oracledb.os.swaps:
248
          enabled: true
249
        oracledb.parallel_operations_downgraded_1_to_25_pct:
250
          enabled: true
251
          attributes:
252
            - oracle.db.pdb
253
        oracledb.parallel_operations_downgraded_25_to_50_pct:
254
          enabled: true
255
          attributes:
256
            - oracle.db.pdb
257
        oracledb.parallel_operations_downgraded_50_to_75_pct:
258
          enabled: true
259
          attributes:
260
            - oracle.db.pdb
261
        oracledb.parallel_operations_downgraded_75_to_99_pct:
262
          enabled: true
263
          attributes:
264
            - oracle.db.pdb
265
        oracledb.parallel_operations_downgraded_to_serial:
266
          enabled: true
267
          attributes:
268
            - oracle.db.pdb
269
        oracledb.parallel_operations_not_downgraded:
270
          enabled: true
271
          attributes:
272
            - oracle.db.pdb
273
        oracledb.parse.cpu.time:
274
          enabled: true
275
        oracledb.parse.elapsed.time:
276
          enabled: true
277
        oracledb.parse.rate:
278
          enabled: true
279
          attributes:
280
            - oracledb.parse.result
281
            - oracle.db.pdb
282
        oracledb.parse.utilization:
283
          enabled: true
284
          attributes:
285
            - oracle.db.pdb
286
        oracledb.parse_calls:
287
          enabled: true
288
          attributes:
289
            - oracle.db.pdb
290
        oracledb.pga.cache.utilization:
291
          enabled: true
292
        oracledb.pga_memory:
293
          enabled: true
294
          attributes:
295
            - oracle.db.pdb
296
        oracledb.physical_io.cache_writes:
297
          enabled: true
298
          attributes:
299
            - oracle.db.pdb
300
        oracledb.physical_io.requests:
301
          enabled: true
302
          attributes:
303
            - disk.io.direction
304
            - disk.io.block_size
305
            - oracle.db.pdb
306
        oracledb.physical_io.requests.rate:
307
          enabled: true
308
          attributes:
309
            - disk.io.direction
310
            - oracle.db.pdb
311
        oracledb.physical_io.transferred:
312
          enabled: true
313
          attributes:
314
            - disk.io.direction
315
            - disk.io.type
316
            - oracle.db.pdb
317
        oracledb.physical_io.transferred.rate:
318
          enabled: true
319
          attributes:
320
            - disk.io.direction
321
            - oracle.db.pdb
322
        oracledb.physical_operations.rate:
323
          enabled: true
324
          attributes:
325
            - disk.io.direction
326
            - oracle.db.pdb
327
        oracledb.physical_read_io_requests:
328
          enabled: true
329
          attributes:
330
            - oracle.db.pdb
331
        oracledb.physical_reads:
332
          enabled: true
333
          attributes:
334
            - oracle.db.pdb
335
        oracledb.physical_reads_direct:
336
          enabled: true
337
          attributes:
338
            - oracle.db.pdb
339
        oracledb.physical_write_io_requests:
340
          enabled: true
341
          attributes:
342
            - oracle.db.pdb
343
        oracledb.physical_writes:
344
          enabled: true
345
          attributes:
346
            - oracle.db.pdb
347
        oracledb.physical_writes_direct:
348
          enabled: true
349
          attributes:
350
            - oracle.db.pdb
351
        oracledb.processes.limit:
352
          enabled: true
353
        oracledb.processes.usage:
354
          enabled: true
355
        oracledb.queries_parallelized:
356
          enabled: true
357
          attributes:
358
            - oracle.db.pdb
359
        oracledb.recovery.blocks:
360
          enabled: true
361
        oracledb.recycle_bin.limit:
362
          enabled: true
363
        oracledb.redo.blocks:
364
          enabled: true
365
          attributes:
366
            - disk.io.direction
367
        oracledb.redo.operations:
368
          enabled: true
369
          attributes:
370
            - disk.io.direction
371
        oracledb.redo.requests:
372
          enabled: true
373
          attributes:
374
            - oracledb.redo.request.type
375
        oracledb.redo.retries:
376
          enabled: true
377
          attributes:
378
            - oracledb.redo.retry.type
379
        oracledb.redo.size:
380
          enabled: true
381
        oracledb.redo.size.rate:
382
          enabled: true
383
          attributes:
384
            - oracle.db.pdb
385
        oracledb.redo.time:
386
          enabled: true
387
          attributes:
388
            - oracledb.redo.type
389
        oracledb.redo_allocation.utilization:
390
          enabled: true
391
          attributes:
392
            - oracle.db.pdb
393
        oracledb.scan.count:
394
          enabled: true
395
          attributes:
396
            - oracledb.scan.type
397
            - oracledb.scan.mode
398
        oracledb.scan.table.rows:
399
          enabled: true
400
        oracledb.session.average:
401
          enabled: true
402
          attributes:
403
            - session_status
404
            - oracle.db.pdb
405
        oracledb.session.stored_procedure.memory:
406
          enabled: true
407
          attributes:
408
            - oracle.db.pdb
409
        oracledb.session.wait.time:
410
          enabled: true
411
          attributes:
412
            - oracledb.session.wait.state
413
            - oracle.db.pdb
414
        oracledb.session.waits:
415
          enabled: true
416
          attributes:
417
            - oracledb.session.wait.state
418
            - oracle.db.pdb
419
        oracledb.sessions.limit:
420
          enabled: true
421
        oracledb.sessions.usage:
422
          enabled: true
423
          attributes:
424
            - session_type
425
            - session_status
426
            - oracle.db.pdb
427
        oracledb.sga.limit:
428
          enabled: true
429
        oracledb.sga.usage:
430
          enabled: true
431
          attributes:
432
            - oracledb.sga.component.name
433
        oracledb.shared_pool.utilization:
434
          enabled: true
435
          attributes:
436
            - oracle.db.pdb
437
        oracledb.smon.posts:
438
          enabled: true
439
          attributes:
440
            - oracledb.smon.type
441
        oracledb.sort.operations:
442
          enabled: true
443
          attributes:
444
            - oracledb.sort.type
445
        oracledb.sort.ratio:
446
          enabled: true
447
          attributes:
448
            - oracledb.sort.type
449
            - oracle.db.pdb
450
        oracledb.sort.rows:
451
          enabled: true
452
        oracledb.sql_service.response.duration:
453
          enabled: true
454
          attributes:
455
            - oracle.db.pdb
456
        oracledb.sqlnet.io.transferred:
457
          enabled: true
458
          attributes:
459
            - network.io.direction
460
            - destination.type
461
            - oracle.db.pdb
462
        oracledb.storage.usage:
463
          enabled: true
464
        oracledb.storage.utilization:
465
          enabled: true
466
        oracledb.system.cpu.count:
467
          enabled: true
468
        oracledb.system.memory.limit:
469
          enabled: true
470
        oracledb.system.process.count:
471
          enabled: true
472
        oracledb.tablespace.limit:
473
          enabled: true
474
          attributes:
475
            - tablespace_name
476
            - oracle.db.pdb
477
        oracledb.tablespace.status:
478
          enabled: true
479
          attributes:
480
            - tablespace_name
481
            - oracledb.tablespace.state
482
            - oracle.db.pdb
483
        oracledb.tablespace.utilization:
484
          enabled: true
485
          attributes:
486
            - tablespace_name
487
            - oracle.db.pdb
488
        oracledb.tablespace_size.limit:
489
          enabled: true
490
          attributes:
491
            - tablespace_name
492
            - oracle.db.pdb
493
        oracledb.tablespace_size.usage:
494
          enabled: true
495
          attributes:
496
            - tablespace_name
497
            - oracle.db.pdb
498
        oracledb.transaction.response.time:
499
          enabled: true
500
          attributes:
501
            - oracle.db.pdb
502
        oracledb.transaction.rollbacks:
503
          enabled: true
504
          attributes:
505
            - oracle.db.pdb
506
        oracledb.transactions.limit:
507
          enabled: true
508
        oracledb.transactions.rate:
509
          enabled: true
510
          attributes:
511
            - oracledb.transaction.type
512
            - oracle.db.pdb
513
        oracledb.transactions.usage:
514
          enabled: true
515
        oracledb.user_commits:
516
          enabled: true
517
          attributes:
518
            - oracle.db.pdb
519
        oracledb.user_rollbacks:
520
          enabled: true
521
          attributes:
522
            - oracle.db.pdb
523

524
      # Resource attributes attached to all metrics/logs (all enabled by default)
525
      resource_attributes:
526
        oracle.db.edition:
527
          enabled: true
528
exporters:
529
    otlp/newrelic:
530
      endpoint: https://otlp.nr-data.net:4318
531
      headers:
532
        api-key: YOUR_LICENSE_KEY
533
      compression: gzip
534
      retry_on_failure:
535
        enabled: true
536
        initial_interval: 5s
537
        max_interval: 30s
538
        max_elapsed_time: 300s
539
      sending_queue:
540
        enabled: true
541
        sizer: bytes
542
        queue_size: 100_000_000
543
        num_consumers: 10
544
        batch:
545
          sizer: bytes
546
          max_size: 1_000_000
547
          min_size: 0
548
          flush_timeout: 5s
549
service:
550
    pipelines:
551
      metrics/oracledb:
552
        receivers: [nroracledb]
553
        exporters: [otlp/newrelic]
554
      logs/oracledb:
555
        receivers: [nroracledb]
556
        exporters: [otlp/newrelic]

RDS

This configuration includes the complete Oracle Database metric catalog, with every metric enabled, for comprehensive visibility when monitoring an Oracle Database instance running on Amazon RDS.

Oracle RDS Endpoint

Oracle RDS Port

Database Username

Database Password

Service Name

New Relic OTLP Endpoint

New Relic License Key

oracle-config.yaml

1
receivers:
2
    nroracledb/rds:
3
      endpoint: mydb-instance.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com:1521
4
      username: newrelic
5
      password: YOUR_PASSWORD
6
      service: YOUR_SERVICE_NAME
7
      collection_interval: 15s
8
      events:
9
        db.server.query_sample:
10
          enabled: true
11
        db.server.top_query:
12
          enabled: true
13
        db.server.session.wait_sample:
14
          enabled: true
15
        db.server.top_procedure:
16
          enabled: true
17
        db.server.query_plan:
18
          enabled: true
19

20
      top_query_collection:
21
        max_query_sample_count: 1000
22
        top_query_count: 200
23
        collection_interval: 60s
24
        allowed_comment_keys:
25
          - nr_service_guid
26

27
      query_sample_collection:
28
        max_rows_per_query: 100
29
        allowed_comment_keys:
30
          - nr_service_guid
31

32
      session_wait_event_collection:
33
        max_rows_per_query: 100
34

35
      top_procedure_collection:
36
        max_procedure_sample_count: 1000
37
        top_procedure_count: 250
38
        collection_interval: 60s
39

40
      metrics:
41
        oracledb.buffer.inspected:
42
          enabled: true
43
          attributes:
44
            - oracledb.buffer.state
45
        oracledb.buffer.requests:
46
          enabled: true
47
        oracledb.buffer_cache.block.changes:
48
          enabled: true
49
        oracledb.buffer_cache.block.changes.rate:
50
          enabled: true
51
          attributes:
52
            - oracle.db.pdb
53
        oracledb.buffer_cache.block.gets:
54
          enabled: true
55
        oracledb.buffer_cache.utilization:
56
          enabled: true
57
          attributes:
58
            - oracle.db.pdb
59
        oracledb.call.count:
60
          enabled: true
61
          attributes:
62
            - oracledb.call.type
63
        oracledb.call.recursive.cpu.time:
64
          enabled: true
65
        oracledb.checkpoint.buffers:
66
          enabled: true
67
        oracledb.checkpoint.completed:
68
          enabled: true
69
        oracledb.consistent_gets:
70
          enabled: true
71
          attributes:
72
            - oracle.db.pdb
73
        oracledb.cpu.usage.rate:
74
          enabled: true
75
          attributes:
76
            - oracle.db.pdb
77
        oracledb.cpu_time:
78
          enabled: true
79
          attributes:
80
            - oracle.db.pdb
81
        oracledb.cursor.cache.hits:
82
          enabled: true
83
        oracledb.cursor.cache.size:
84
          enabled: true
85
        oracledb.cursor.cache.utilization:
86
          enabled: true
87
          attributes:
88
            - oracle.db.pdb
89
        oracledb.cursor.open:
90
          enabled: true
91
        oracledb.cursor.open.rate:
92
          enabled: true
93
          attributes:
94
            - oracle.db.pdb
95
        oracledb.data_dictionary.hit_ratio:
96
          enabled: true
97
        oracledb.database.cpu.utilization:
98
          enabled: true
99
          attributes:
100
            - oracle.db.pdb
101
        oracledb.database.wait.utilization:
102
          enabled: true
103
          attributes:
104
            - oracle.db.pdb
105
        oracledb.db.time:
106
          enabled: true
107
          attributes:
108
            - oracledb.session.type
109
        oracledb.db_block_gets:
110
          enabled: true
111
          attributes:
112
            - oracle.db.pdb
113
        oracledb.ddl_statements_parallelized:
114
          enabled: true
115
          attributes:
116
            - oracle.db.pdb
117
        oracledb.dml_locks.limit:
118
          enabled: true
119
        oracledb.dml_locks.usage:
120
          enabled: true
121
        oracledb.dml_statements_parallelized:
122
          enabled: true
123
          attributes:
124
            - oracle.db.pdb
125
        oracledb.enqueue.deadlocks.rate:
126
          enabled: true
127
          attributes:
128
            - oracle.db.pdb
129
        oracledb.enqueue.operations:
130
          enabled: true
131
          attributes:
132
            - oracledb.enqueue.type
133
        oracledb.enqueue.timeouts.rate:
134
          enabled: true
135
          attributes:
136
            - oracle.db.pdb
137
        oracledb.enqueue_deadlocks:
138
          enabled: true
139
          attributes:
140
            - oracle.db.pdb
141
        oracledb.enqueue_locks.limit:
142
          enabled: true
143
        oracledb.enqueue_locks.usage:
144
          enabled: true
145
        oracledb.enqueue_resources.limit:
146
          enabled: true
147
        oracledb.enqueue_resources.usage:
148
          enabled: true
149
        oracledb.exchange_deadlocks:
150
          enabled: true
151
          attributes:
152
            - oracle.db.pdb
153
        oracledb.execution.utilization:
154
          enabled: true
155
          attributes:
156
            - oracledb.parse.type
157
            - oracle.db.pdb
158
        oracledb.executions:
159
          enabled: true
160
          attributes:
161
            - oracle.db.pdb
162
        oracledb.executions.rate:
163
          enabled: true
164
          attributes:
165
            - oracle.db.pdb
166
        oracledb.gc.current_block.time:
167
          enabled: true
168
          attributes:
169
            - network.io.direction
170
        oracledb.hard_parses:
171
          enabled: true
172
          attributes:
173
            - oracle.db.pdb
174
        oracledb.hard_parses.rate:
175
          enabled: true
176
          attributes:
177
            - oracle.db.pdb
178
        oracledb.host.cpu.usage.rate:
179
          enabled: true
180
        oracledb.host.cpu.utilization:
181
          enabled: true
182
          attributes:
183
            - oracle.db.pdb
184
        oracledb.io.requests.rate:
185
          enabled: true
186
        oracledb.io.single_block.read.latency:
187
          enabled: true
188
        oracledb.io.throughput.rate:
189
          enabled: true
190
        oracledb.jvm.memory.committed:
191
          enabled: true
192
        oracledb.jvm.memory.live:
193
          enabled: true
194
        oracledb.jvm.memory.used:
195
          enabled: true
196
        oracledb.library_cache.utilization:
197
          enabled: true
198
          attributes:
199
            - oracle.db.pdb
200
        oracledb.lob.operations:
201
          enabled: true
202
          attributes:
203
            - disk.io.direction
204
        oracledb.lock.time:
205
          enabled: true
206
          attributes:
207
            - oracle.db.pdb
208
            - oracledb.session.type
209
        oracledb.logical_reads:
210
          enabled: true
211
          attributes:
212
            - oracle.db.pdb
213
        oracledb.logical_reads.rate:
214
          enabled: true
215
          attributes:
216
            - oracle.db.pdb
217
        oracledb.logons:
218
          enabled: true
219
          attributes:
220
            - oracle.db.pdb
221
        oracledb.logons.rate:
222
          enabled: true
223
          attributes:
224
            - oracle.db.pdb
225
        oracledb.os.swaps:
226
          enabled: true
227
        oracledb.parallel_operations_downgraded_1_to_25_pct:
228
          enabled: true
229
          attributes:
230
            - oracle.db.pdb
231
        oracledb.parallel_operations_downgraded_25_to_50_pct:
232
          enabled: true
233
          attributes:
234
            - oracle.db.pdb
235
        oracledb.parallel_operations_downgraded_50_to_75_pct:
236
          enabled: true
237
          attributes:
238
            - oracle.db.pdb
239
        oracledb.parallel_operations_downgraded_75_to_99_pct:
240
          enabled: true
241
          attributes:
242
            - oracle.db.pdb
243
        oracledb.parallel_operations_downgraded_to_serial:
244
          enabled: true
245
          attributes:
246
            - oracle.db.pdb
247
        oracledb.parallel_operations_not_downgraded:
248
          enabled: true
249
          attributes:
250
            - oracle.db.pdb
251
        oracledb.parse.cpu.time:
252
          enabled: true
253
        oracledb.parse.elapsed.time:
254
          enabled: true
255
        oracledb.parse.rate:
256
          enabled: true
257
          attributes:
258
            - oracledb.parse.result
259
            - oracle.db.pdb
260
        oracledb.parse.utilization:
261
          enabled: true
262
          attributes:
263
            - oracle.db.pdb
264
        oracledb.parse_calls:
265
          enabled: true
266
          attributes:
267
            - oracle.db.pdb
268
        oracledb.pga.cache.utilization:
269
          enabled: true
270
        oracledb.pga_memory:
271
          enabled: true
272
          attributes:
273
            - oracle.db.pdb
274
        oracledb.physical_io.cache_writes:
275
          enabled: true
276
          attributes:
277
            - oracle.db.pdb
278
        oracledb.physical_io.requests:
279
          enabled: true
280
          attributes:
281
            - disk.io.direction
282
            - disk.io.block_size
283
            - oracle.db.pdb
284
        oracledb.physical_io.requests.rate:
285
          enabled: true
286
          attributes:
287
            - disk.io.direction
288
            - oracle.db.pdb
289
        oracledb.physical_io.transferred:
290
          enabled: true
291
          attributes:
292
            - disk.io.direction
293
            - disk.io.type
294
            - oracle.db.pdb
295
        oracledb.physical_io.transferred.rate:
296
          enabled: true
297
          attributes:
298
            - disk.io.direction
299
            - oracle.db.pdb
300
        oracledb.physical_operations.rate:
301
          enabled: true
302
          attributes:
303
            - disk.io.direction
304
            - oracle.db.pdb
305
        oracledb.physical_read_io_requests:
306
          enabled: true
307
          attributes:
308
            - oracle.db.pdb
309
        oracledb.physical_reads:
310
          enabled: true
311
          attributes:
312
            - oracle.db.pdb
313
        oracledb.physical_reads_direct:
314
          enabled: true
315
          attributes:
316
            - oracle.db.pdb
317
        oracledb.physical_write_io_requests:
318
          enabled: true
319
          attributes:
320
            - oracle.db.pdb
321
        oracledb.physical_writes:
322
          enabled: true
323
          attributes:
324
            - oracle.db.pdb
325
        oracledb.physical_writes_direct:
326
          enabled: true
327
          attributes:
328
            - oracle.db.pdb
329
        oracledb.processes.limit:
330
          enabled: true
331
        oracledb.processes.usage:
332
          enabled: true
333
        oracledb.queries_parallelized:
334
          enabled: true
335
          attributes:
336
            - oracle.db.pdb
337
        oracledb.recovery.blocks:
338
          enabled: true
339
        oracledb.recycle_bin.limit:
340
          enabled: true
341
        oracledb.redo.blocks:
342
          enabled: true
343
          attributes:
344
            - disk.io.direction
345
        oracledb.redo.operations:
346
          enabled: true
347
          attributes:
348
            - disk.io.direction
349
        oracledb.redo.requests:
350
          enabled: true
351
          attributes:
352
            - oracledb.redo.request.type
353
        oracledb.redo.retries:
354
          enabled: true
355
          attributes:
356
            - oracledb.redo.retry.type
357
        oracledb.redo.size:
358
          enabled: true
359
        oracledb.redo.size.rate:
360
          enabled: true
361
          attributes:
362
            - oracle.db.pdb
363
        oracledb.redo.time:
364
          enabled: true
365
          attributes:
366
            - oracledb.redo.type
367
        oracledb.redo_allocation.utilization:
368
          enabled: true
369
          attributes:
370
            - oracle.db.pdb
371
        oracledb.scan.count:
372
          enabled: true
373
          attributes:
374
            - oracledb.scan.type
375
            - oracledb.scan.mode
376
        oracledb.scan.table.rows:
377
          enabled: true
378
        oracledb.session.average:
379
          enabled: true
380
          attributes:
381
            - session_status
382
            - oracle.db.pdb
383
        oracledb.session.stored_procedure.memory:
384
          enabled: true
385
          attributes:
386
            - oracle.db.pdb
387
        oracledb.session.wait.time:
388
          enabled: true
389
          attributes:
390
            - oracledb.session.wait.state
391
            - oracle.db.pdb
392
        oracledb.session.waits:
393
          enabled: true
394
          attributes:
395
            - oracledb.session.wait.state
396
            - oracle.db.pdb
397
        oracledb.sessions.limit:
398
          enabled: true
399
        oracledb.sessions.usage:
400
          enabled: true
401
          attributes:
402
            - session_type
403
            - session_status
404
            - oracle.db.pdb
405
        oracledb.sga.limit:
406
          enabled: true
407
        oracledb.sga.usage:
408
          enabled: true
409
          attributes:
410
            - oracledb.sga.component.name
411
        oracledb.shared_pool.utilization:
412
          enabled: true
413
          attributes:
414
            - oracle.db.pdb
415
        oracledb.smon.posts:
416
          enabled: true
417
          attributes:
418
            - oracledb.smon.type
419
        oracledb.sort.operations:
420
          enabled: true
421
          attributes:
422
            - oracledb.sort.type
423
        oracledb.sort.ratio:
424
          enabled: true
425
          attributes:
426
            - oracledb.sort.type
427
            - oracle.db.pdb
428
        oracledb.sort.rows:
429
          enabled: true
430
        oracledb.sql_service.response.duration:
431
          enabled: true
432
          attributes:
433
            - oracle.db.pdb
434
        oracledb.sqlnet.io.transferred:
435
          enabled: true
436
          attributes:
437
            - network.io.direction
438
            - destination.type
439
            - oracle.db.pdb
440
        oracledb.storage.usage:
441
          enabled: true
442
        oracledb.storage.utilization:
443
          enabled: true
444
        oracledb.system.cpu.count:
445
          enabled: true
446
        oracledb.system.memory.limit:
447
          enabled: true
448
        oracledb.system.process.count:
449
          enabled: true
450
        oracledb.tablespace.limit:
451
          enabled: true
452
          attributes:
453
            - tablespace_name
454
            - oracle.db.pdb
455
        oracledb.tablespace.status:
456
          enabled: true
457
          attributes:
458
            - tablespace_name
459
            - oracledb.tablespace.state
460
            - oracle.db.pdb
461
        oracledb.tablespace.utilization:
462
          enabled: true
463
          attributes:
464
            - tablespace_name
465
            - oracle.db.pdb
466
        oracledb.tablespace_size.limit:
467
          enabled: true
468
          attributes:
469
            - tablespace_name
470
            - oracle.db.pdb
471
        oracledb.tablespace_size.usage:
472
          enabled: true
473
          attributes:
474
            - tablespace_name
475
            - oracle.db.pdb
476
        oracledb.transaction.response.time:
477
          enabled: true
478
          attributes:
479
            - oracle.db.pdb
480
        oracledb.transaction.rollbacks:
481
          enabled: true
482
          attributes:
483
            - oracle.db.pdb
484
        oracledb.transactions.limit:
485
          enabled: true
486
        oracledb.transactions.rate:
487
          enabled: true
488
          attributes:
489
            - oracledb.transaction.type
490
            - oracle.db.pdb
491
        oracledb.transactions.usage:
492
          enabled: true
493
        oracledb.user_commits:
494
          enabled: true
495
          attributes:
496
            - oracle.db.pdb
497
        oracledb.user_rollbacks:
498
          enabled: true
499
          attributes:
500
            - oracle.db.pdb
501

502
      # Resource attributes attached to all metrics/logs (all enabled by default)
503
      resource_attributes:
504
        oracle.db.edition:
505
          enabled: true
506
exporters:
507
    otlp/newrelic:
508
      endpoint: https://otlp.nr-data.net:4318
509
      headers:
510
        api-key: YOUR_LICENSE_KEY
511
      compression: gzip
512
      retry_on_failure:
513
        enabled: true
514
        initial_interval: 5s
515
        max_interval: 30s
516
        max_elapsed_time: 300s
517
      sending_queue:
518
        enabled: true
519
        sizer: bytes
520
        queue_size: 100_000_000
521
        num_consumers: 10
522
        batch:
523
          sizer: bytes
524
          max_size: 1_000_000
525
          min_size: 0
526
          flush_timeout: 5s
527
service:
528
    pipelines:
529
      metrics/oracledb:
530
        receivers: [nroracledb/rds]
531
        exporters: [otlp/newrelic]
532
      logs/oracledb:
533
        receivers: [nroracledb/rds]
534
        exporters: [otlp/newrelic]

ADB

This configuration includes the complete Oracle Database metric catalog, with every metric enabled, for comprehensive visibility when monitoring an Oracle Autonomous Database instance.

Database Username

Database Password

Oracle ADB Hostname

Oracle ADB Port

Service Name

New Relic OTLP Endpoint

New Relic License Key

oracle-config.yaml

1
receivers:
2
    nroracledb/adb:
3
      datasource: "oracle://newrelic:YOUR_PASSWORD@adb.example.oraclecloud.com:1522/YOUR_SERVICE_NAME?ssl=true&ssl%20verify=true"
4
      collection_interval: 15s
5
      events:
6
        db.server.query_sample:
7
          enabled: true
8
        db.server.top_query:
9
          enabled: true
10
        db.server.session.wait_sample:
11
          enabled: true
12
        db.server.top_procedure:
13
          enabled: true
14
        db.server.query_plan:
15
          enabled: true
16

17
      top_query_collection:
18
        max_query_sample_count: 1000
19
        top_query_count: 200
20
        collection_interval: 60s
21
        allowed_comment_keys:
22
          - nr_service_guid
23

24
      query_sample_collection:
25
        max_rows_per_query: 100
26
        allowed_comment_keys:
27
          - nr_service_guid
28

29
      session_wait_event_collection:
30
        max_rows_per_query: 100
31

32
      top_procedure_collection:
33
        max_procedure_sample_count: 1000
34
        top_procedure_count: 250
35
        collection_interval: 60s
36

37
      metrics:
38
        oracledb.buffer.inspected:
39
          enabled: true
40
          attributes:
41
            - oracledb.buffer.state
42
        oracledb.buffer.requests:
43
          enabled: true
44
        oracledb.buffer_cache.block.changes:
45
          enabled: true
46
        oracledb.buffer_cache.block.changes.rate:
47
          enabled: true
48
          attributes:
49
            - oracle.db.pdb
50
        oracledb.buffer_cache.block.gets:
51
          enabled: true
52
        oracledb.buffer_cache.utilization:
53
          enabled: true
54
          attributes:
55
            - oracle.db.pdb
56
        oracledb.call.count:
57
          enabled: true
58
          attributes:
59
            - oracledb.call.type
60
        oracledb.call.recursive.cpu.time:
61
          enabled: true
62
        oracledb.checkpoint.buffers:
63
          enabled: true
64
        oracledb.checkpoint.completed:
65
          enabled: true
66
        oracledb.consistent_gets:
67
          enabled: true
68
          attributes:
69
            - oracle.db.pdb
70
        oracledb.cpu.usage.rate:
71
          enabled: true
72
          attributes:
73
            - oracle.db.pdb
74
        oracledb.cpu_time:
75
          enabled: true
76
          attributes:
77
            - oracle.db.pdb
78
        oracledb.cursor.cache.hits:
79
          enabled: true
80
        oracledb.cursor.cache.size:
81
          enabled: true
82
        oracledb.cursor.cache.utilization:
83
          enabled: true
84
          attributes:
85
            - oracle.db.pdb
86
        oracledb.cursor.open:
87
          enabled: true
88
        oracledb.cursor.open.rate:
89
          enabled: true
90
          attributes:
91
            - oracle.db.pdb
92
        oracledb.data_dictionary.hit_ratio:
93
          enabled: true
94
        oracledb.database.cpu.utilization:
95
          enabled: true
96
          attributes:
97
            - oracle.db.pdb
98
        oracledb.database.wait.utilization:
99
          enabled: true
100
          attributes:
101
            - oracle.db.pdb
102
        oracledb.db.time:
103
          enabled: true
104
          attributes:
105
            - oracledb.session.type
106
        oracledb.db_block_gets:
107
          enabled: true
108
          attributes:
109
            - oracle.db.pdb
110
        oracledb.ddl_statements_parallelized:
111
          enabled: true
112
          attributes:
113
            - oracle.db.pdb
114
        oracledb.dml_locks.limit:
115
          enabled: true
116
        oracledb.dml_locks.usage:
117
          enabled: true
118
        oracledb.dml_statements_parallelized:
119
          enabled: true
120
          attributes:
121
            - oracle.db.pdb
122
        oracledb.enqueue.deadlocks.rate:
123
          enabled: true
124
          attributes:
125
            - oracle.db.pdb
126
        oracledb.enqueue.operations:
127
          enabled: true
128
          attributes:
129
            - oracledb.enqueue.type
130
        oracledb.enqueue.timeouts.rate:
131
          enabled: true
132
          attributes:
133
            - oracle.db.pdb
134
        oracledb.enqueue_deadlocks:
135
          enabled: true
136
          attributes:
137
            - oracle.db.pdb
138
        oracledb.enqueue_locks.limit:
139
          enabled: true
140
        oracledb.enqueue_locks.usage:
141
          enabled: true
142
        oracledb.enqueue_resources.limit:
143
          enabled: true
144
        oracledb.enqueue_resources.usage:
145
          enabled: true
146
        oracledb.exchange_deadlocks:
147
          enabled: true
148
          attributes:
149
            - oracle.db.pdb
150
        oracledb.execution.utilization:
151
          enabled: true
152
          attributes:
153
            - oracledb.parse.type
154
            - oracle.db.pdb
155
        oracledb.executions:
156
          enabled: true
157
          attributes:
158
            - oracle.db.pdb
159
        oracledb.executions.rate:
160
          enabled: true
161
          attributes:
162
            - oracle.db.pdb
163
        oracledb.gc.current_block.time:
164
          enabled: true
165
          attributes:
166
            - network.io.direction
167
        oracledb.hard_parses:
168
          enabled: true
169
          attributes:
170
            - oracle.db.pdb
171
        oracledb.hard_parses.rate:
172
          enabled: true
173
          attributes:
174
            - oracle.db.pdb
175
        oracledb.host.cpu.usage.rate:
176
          enabled: true
177
        oracledb.host.cpu.utilization:
178
          enabled: true
179
          attributes:
180
            - oracle.db.pdb
181
        oracledb.io.requests.rate:
182
          enabled: true
183
        oracledb.io.single_block.read.latency:
184
          enabled: true
185
        oracledb.io.throughput.rate:
186
          enabled: true
187
        oracledb.jvm.memory.committed:
188
          enabled: true
189
        oracledb.jvm.memory.live:
190
          enabled: true
191
        oracledb.jvm.memory.used:
192
          enabled: true
193
        oracledb.library_cache.utilization:
194
          enabled: true
195
          attributes:
196
            - oracle.db.pdb
197
        oracledb.lob.operations:
198
          enabled: true
199
          attributes:
200
            - disk.io.direction
201
        oracledb.lock.time:
202
          enabled: true
203
          attributes:
204
            - oracle.db.pdb
205
            - oracledb.session.type
206
        oracledb.logical_reads:
207
          enabled: true
208
          attributes:
209
            - oracle.db.pdb
210
        oracledb.logical_reads.rate:
211
          enabled: true
212
          attributes:
213
            - oracle.db.pdb
214
        oracledb.logons:
215
          enabled: true
216
          attributes:
217
            - oracle.db.pdb
218
        oracledb.logons.rate:
219
          enabled: true
220
          attributes:
221
            - oracle.db.pdb
222
        oracledb.os.swaps:
223
          enabled: true
224
        oracledb.parallel_operations_downgraded_1_to_25_pct:
225
          enabled: true
226
          attributes:
227
            - oracle.db.pdb
228
        oracledb.parallel_operations_downgraded_25_to_50_pct:
229
          enabled: true
230
          attributes:
231
            - oracle.db.pdb
232
        oracledb.parallel_operations_downgraded_50_to_75_pct:
233
          enabled: true
234
          attributes:
235
            - oracle.db.pdb
236
        oracledb.parallel_operations_downgraded_75_to_99_pct:
237
          enabled: true
238
          attributes:
239
            - oracle.db.pdb
240
        oracledb.parallel_operations_downgraded_to_serial:
241
          enabled: true
242
          attributes:
243
            - oracle.db.pdb
244
        oracledb.parallel_operations_not_downgraded:
245
          enabled: true
246
          attributes:
247
            - oracle.db.pdb
248
        oracledb.parse.cpu.time:
249
          enabled: true
250
        oracledb.parse.elapsed.time:
251
          enabled: true
252
        oracledb.parse.rate:
253
          enabled: true
254
          attributes:
255
            - oracledb.parse.result
256
            - oracle.db.pdb
257
        oracledb.parse.utilization:
258
          enabled: true
259
          attributes:
260
            - oracle.db.pdb
261
        oracledb.parse_calls:
262
          enabled: true
263
          attributes:
264
            - oracle.db.pdb
265
        oracledb.pga.cache.utilization:
266
          enabled: true
267
        oracledb.pga_memory:
268
          enabled: true
269
          attributes:
270
            - oracle.db.pdb
271
        oracledb.physical_io.cache_writes:
272
          enabled: true
273
          attributes:
274
            - oracle.db.pdb
275
        oracledb.physical_io.requests:
276
          enabled: true
277
          attributes:
278
            - disk.io.direction
279
            - disk.io.block_size
280
            - oracle.db.pdb
281
        oracledb.physical_io.requests.rate:
282
          enabled: true
283
          attributes:
284
            - disk.io.direction
285
            - oracle.db.pdb
286
        oracledb.physical_io.transferred:
287
          enabled: true
288
          attributes:
289
            - disk.io.direction
290
            - disk.io.type
291
            - oracle.db.pdb
292
        oracledb.physical_io.transferred.rate:
293
          enabled: true
294
          attributes:
295
            - disk.io.direction
296
            - oracle.db.pdb
297
        oracledb.physical_operations.rate:
298
          enabled: true
299
          attributes:
300
            - disk.io.direction
301
            - oracle.db.pdb
302
        oracledb.physical_read_io_requests:
303
          enabled: true
304
          attributes:
305
            - oracle.db.pdb
306
        oracledb.physical_reads:
307
          enabled: true
308
          attributes:
309
            - oracle.db.pdb
310
        oracledb.physical_reads_direct:
311
          enabled: true
312
          attributes:
313
            - oracle.db.pdb
314
        oracledb.physical_write_io_requests:
315
          enabled: true
316
          attributes:
317
            - oracle.db.pdb
318
        oracledb.physical_writes:
319
          enabled: true
320
          attributes:
321
            - oracle.db.pdb
322
        oracledb.physical_writes_direct:
323
          enabled: true
324
          attributes:
325
            - oracle.db.pdb
326
        oracledb.processes.limit:
327
          enabled: true
328
        oracledb.processes.usage:
329
          enabled: true
330
        oracledb.queries_parallelized:
331
          enabled: true
332
          attributes:
333
            - oracle.db.pdb
334
        oracledb.recovery.blocks:
335
          enabled: true
336
        oracledb.recycle_bin.limit:
337
          enabled: true
338
        oracledb.redo.blocks:
339
          enabled: true
340
          attributes:
341
            - disk.io.direction
342
        oracledb.redo.operations:
343
          enabled: true
344
          attributes:
345
            - disk.io.direction
346
        oracledb.redo.requests:
347
          enabled: true
348
          attributes:
349
            - oracledb.redo.request.type
350
        oracledb.redo.retries:
351
          enabled: true
352
          attributes:
353
            - oracledb.redo.retry.type
354
        oracledb.redo.size:
355
          enabled: true
356
        oracledb.redo.size.rate:
357
          enabled: true
358
          attributes:
359
            - oracle.db.pdb
360
        oracledb.redo.time:
361
          enabled: true
362
          attributes:
363
            - oracledb.redo.type
364
        oracledb.redo_allocation.utilization:
365
          enabled: true
366
          attributes:
367
            - oracle.db.pdb
368
        oracledb.scan.count:
369
          enabled: true
370
          attributes:
371
            - oracledb.scan.type
372
            - oracledb.scan.mode
373
        oracledb.scan.table.rows:
374
          enabled: true
375
        oracledb.session.average:
376
          enabled: true
377
          attributes:
378
            - session_status
379
            - oracle.db.pdb
380
        oracledb.session.stored_procedure.memory:
381
          enabled: true
382
          attributes:
383
            - oracle.db.pdb
384
        oracledb.session.wait.time:
385
          enabled: true
386
          attributes:
387
            - oracledb.session.wait.state
388
            - oracle.db.pdb
389
        oracledb.session.waits:
390
          enabled: true
391
          attributes:
392
            - oracledb.session.wait.state
393
            - oracle.db.pdb
394
        oracledb.sessions.limit:
395
          enabled: true
396
        oracledb.sessions.usage:
397
          enabled: true
398
          attributes:
399
            - session_type
400
            - session_status
401
            - oracle.db.pdb
402
        oracledb.sga.limit:
403
          enabled: true
404
        oracledb.sga.usage:
405
          enabled: true
406
          attributes:
407
            - oracledb.sga.component.name
408
        oracledb.shared_pool.utilization:
409
          enabled: true
410
          attributes:
411
            - oracle.db.pdb
412
        oracledb.smon.posts:
413
          enabled: true
414
          attributes:
415
            - oracledb.smon.type
416
        oracledb.sort.operations:
417
          enabled: true
418
          attributes:
419
            - oracledb.sort.type
420
        oracledb.sort.ratio:
421
          enabled: true
422
          attributes:
423
            - oracledb.sort.type
424
            - oracle.db.pdb
425
        oracledb.sort.rows:
426
          enabled: true
427
        oracledb.sql_service.response.duration:
428
          enabled: true
429
          attributes:
430
            - oracle.db.pdb
431
        oracledb.sqlnet.io.transferred:
432
          enabled: true
433
          attributes:
434
            - network.io.direction
435
            - destination.type
436
            - oracle.db.pdb
437
        oracledb.storage.usage:
438
          enabled: true
439
        oracledb.storage.utilization:
440
          enabled: true
441
        oracledb.system.cpu.count:
442
          enabled: true
443
        oracledb.system.memory.limit:
444
          enabled: true
445
        oracledb.system.process.count:
446
          enabled: true
447
        oracledb.tablespace.limit:
448
          enabled: true
449
          attributes:
450
            - tablespace_name
451
            - oracle.db.pdb
452
        oracledb.tablespace.status:
453
          enabled: true
454
          attributes:
455
            - tablespace_name
456
            - oracledb.tablespace.state
457
            - oracle.db.pdb
458
        oracledb.tablespace.utilization:
459
          enabled: true
460
          attributes:
461
            - tablespace_name
462
            - oracle.db.pdb
463
        oracledb.tablespace_size.limit:
464
          enabled: true
465
          attributes:
466
            - tablespace_name
467
            - oracle.db.pdb
468
        oracledb.tablespace_size.usage:
469
          enabled: true
470
          attributes:
471
            - tablespace_name
472
            - oracle.db.pdb
473
        oracledb.transaction.response.time:
474
          enabled: true
475
          attributes:
476
            - oracle.db.pdb
477
        oracledb.transaction.rollbacks:
478
          enabled: true
479
          attributes:
480
            - oracle.db.pdb
481
        oracledb.transactions.limit:
482
          enabled: true
483
        oracledb.transactions.rate:
484
          enabled: true
485
          attributes:
486
            - oracledb.transaction.type
487
            - oracle.db.pdb
488
        oracledb.transactions.usage:
489
          enabled: true
490
        oracledb.user_commits:
491
          enabled: true
492
          attributes:
493
            - oracle.db.pdb
494
        oracledb.user_rollbacks:
495
          enabled: true
496
          attributes:
497
            - oracle.db.pdb
498

499
      # Resource attributes attached to all metrics/logs (all enabled by default)
500
      resource_attributes:
501
        oracle.db.edition:
502
          enabled: true
503
exporters:
504
    otlp/newrelic:
505
      endpoint: https://otlp.nr-data.net:4318
506
      headers:
507
        api-key: YOUR_LICENSE_KEY
508
      compression: gzip
509
      retry_on_failure:
510
        enabled: true
511
        initial_interval: 5s
512
        max_interval: 30s
513
        max_elapsed_time: 300s
514
      sending_queue:
515
        enabled: true
516
        sizer: bytes
517
        queue_size: 100_000_000
518
        num_consumers: 10
519
        batch:
520
          sizer: bytes
521
          max_size: 1_000_000
522
          min_size: 0
523
          flush_timeout: 5s
524
service:
525
    pipelines:
526
      metrics/oracledb:
527
        receivers: [nroracledb/adb]
528
        exporters: [otlp/newrelic]
529
      logs/oracledb:
530
        receivers: [nroracledb/adb]
531
        exporters: [otlp/newrelic]

CDB instrumentation

Learn how to set up your Oracle Database for CDB monitoring in New Relic.

PDB instrumentation

Learn how to set up your Oracle Database for PDB monitoring in New Relic.

RDS instrumentation

Learn how to set up your Oracle Database for RDS monitoring in New Relic.

ADB instrumentation

Learn how to set up your Oracle Autonomous Database for monitoring in New Relic.

Configuration reference for Oracle Database monitoring with NRDOT

중요

On-host

For on-host Pluggable Database (PDB)

For on-host Container Database (CDB)

RDS

For Amazon RDS

ADB

For Autonomous Database (ADB)

CDB instrumentation

PDB instrumentation

RDS instrumentation

ADB instrumentation

Configuration reference for Oracle Database monitoring with NRDOT

중요

On-host .css-21sua1{background:none;border:none;width:0;padding:0;}

For on-host Container Database (CDB)

RDS

For Amazon RDS

ADB

For Autonomous Database (ADB)

Related documentation

CDB instrumentation

PDB instrumentation

RDS instrumentation

ADB instrumentation

On-host