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 host infrastructure metrics alongside database monitoring for production environments.

Important

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 both infrastructure host metrics and database monitoring 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
extensions:
2
    health_check:
3
receivers:
4
    otlp:
5
      protocols:
6
        grpc:
7
        http:
8
    hostmetrics:
9
      collection_interval: 60s
10
      scrapers:
11
        cpu:
12
          metrics:
13
            system.cpu.time:
14
              enabled: false
15
            system.cpu.utilization:
16
              enabled: true
17
        load:
18
        memory:
19
          metrics:
20
            system.memory.utilization:
21
              enabled: true
22
        paging:
23
          metrics:
24
            system.paging.utilization:
25
              enabled: false
26
            system.paging.faults:
27
              enabled: false
28
        filesystem:
29
          metrics:
30
            system.filesystem.utilization:
31
              enabled: true
32
        disk:
33
          metrics:
34
            system.disk.merged:
35
              enabled: false
36
            system.disk.pending_operations:
37
              enabled: false
38
            system.disk.weighted_io_time:
39
              enabled: false
40
        network:
41
          metrics:
42
            system.network.connections:
43
              enabled: false
44
        # Uncomment to enable process metrics, which can be noisy but valuable.
45
        # processes:
46
        # process:
47
        #   metrics:
48
        #     process.cpu.utilization:
49
        #       enabled: true
50
        #     process.cpu.time:
51
        #       enabled: false
52
    filelog:
53
      include:
54
        - /var/log/alternatives.log
55
        - /var/log/cloud-init.log
56
        - /var/log/auth.log
57
        - /var/log/dpkg.log
58
        - /var/log/syslog
59
        - /var/log/messages
60
        - /var/log/secure
61
        - /var/log/yum.log
62
    nroracledb:
63
      endpoint: oracle.example.com:1521
64
      username: newrelic
65
      password: YOUR_PASSWORD
66
      service: YOUR_PDB_SERVICE_NAME
67
      collection_interval: 10s
68
      events:
69
        db.server.query_sample:
70
          enabled: true
71
        db.server.top_query:
72
          enabled: true
73
        db.server.session.wait_sample:
74
          enabled: true
75

76
      top_query_collection:
77
        max_query_sample_count: 1000
78
        top_query_count: 200
79
        collection_interval: 60s
80
        allowed_comment_keys:
81
          - nr_service_guid
82

83
      query_sample_collection:
84
        max_rows_per_query: 100
85
        allowed_comment_keys:
86
          - nr_service_guid
87

88
      session_wait_event_collection:
89
        max_rows_per_query: 100
90

91
      # Metrics configuration - organized by category
92
      metrics:
93
        # === CPU & Performance Metrics ===
94
        oracledb.cpu_time:
95
          enabled: true
96
          attributes:
97
            - oracle.db.pdb
98
        oracledb.database.cpu.utilization:
99
          enabled: true
100
          attributes:
101
            - oracle.db.pdb
102
        oracledb.host.cpu.utilization:
103
          enabled: true
104
          attributes:
105
            - oracle.db.pdb
106

107
        # === Execution & Parse Metrics ===
108
        oracledb.executions:
109
          enabled: true
110
          attributes:
111
            - oracle.db.pdb
112
        oracledb.execution.utilization:
113
          enabled: true
114
          attributes:
115
            - oracledb.parse.type
116
            - oracle.db.pdb
117
        oracledb.parse_calls:
118
          enabled: true
119
          attributes:
120
            - oracle.db.pdb
121
        oracledb.parse.rate:
122
          enabled: true
123
          attributes:
124
            - oracledb.parse.result
125
            - oracle.db.pdb
126
        oracledb.parse.utilization:
127
          enabled: true
128
          attributes:
129
            - oracle.db.pdb
130
        oracledb.hard_parses:
131
          enabled: true
132
          attributes:
133
            - oracle.db.pdb
134

135
        # === I/O & Physical Read/Write Metrics ===
136
        oracledb.logical_reads:
137
          enabled: true
138
          attributes:
139
            - oracle.db.pdb
140
        oracledb.physical_reads:
141
          enabled: true
142
          attributes:
143
            - oracle.db.pdb
144
        oracledb.physical_reads_direct:
145
          enabled: true
146
          attributes:
147
            - oracle.db.pdb
148
        oracledb.physical_writes:
149
          enabled: true
150
          attributes:
151
            - oracle.db.pdb
152
        oracledb.physical_writes_direct:
153
          enabled: true
154
          attributes:
155
            - oracle.db.pdb
156
        oracledb.physical_read_io_requests:
157
          enabled: true
158
          attributes:
159
            - oracle.db.pdb
160
        oracledb.physical_write_io_requests:
161
          enabled: true
162
          attributes:
163
            - oracle.db.pdb
164

165
        # === New Physical I/O Metrics (detailed) ===
166
        oracledb.physical_io.cache_writes:
167
          enabled: true
168
          attributes:
169
            - oracle.db.pdb
170
        oracledb.physical_io.requests:
171
          enabled: true
172
          attributes:
173
            - disk.io.direction
174
            - disk.io.block_size
175
            - oracle.db.pdb
176
        oracledb.physical_io.transferred:
177
          enabled: true
178
          attributes:
179
            - disk.io.direction
180
            - disk.io.type
181
            - oracle.db.pdb
182

183
        # === Network I/O Metrics ===
184
        oracledb.sqlnet.io.transferred:
185
          enabled: true
186
          attributes:
187
            - network.io.direction
188
            - destination.type
189
            - oracle.db.pdb
190

191
        # === Buffer & Cache Metrics ===
192
        oracledb.consistent_gets:
193
          enabled: true
194
          attributes:
195
            - oracle.db.pdb
196
        oracledb.db_block_gets:
197
          enabled: true
198
          attributes:
199
            - oracle.db.pdb
200
        oracledb.buffer_cache.utilization:
201
          enabled: true
202
          attributes:
203
            - oracle.db.pdb
204
        oracledb.library_cache.utilization:
205
          enabled: true
206
          attributes:
207
            - oracle.db.pdb
208
        oracledb.data_dictionary.hit_ratio:
209
          enabled: true
210
        oracledb.shared_pool.utilization:
211
          enabled: true
212
          attributes:
213
            - oracle.db.pdb
214

215
        # === Memory Metrics ===
216
        oracledb.pga_memory:
217
          enabled: true
218
          attributes:
219
            - oracle.db.pdb
220
        oracledb.sga.limit:
221
          enabled: true
222
        oracledb.sga.usage:
223
          enabled: true
224
          attributes:
225
            - oracledb.sga.component.name
226

227
        # === Wait & Database Time Metrics ===
228
        oracledb.database.wait.utilization:
229
          enabled: true
230
          attributes:
231
            - oracle.db.pdb
232

233
        # === Lock & Deadlock Metrics ===
234
        oracledb.dml_locks.limit:
235
          enabled: true
236
        oracledb.dml_locks.usage:
237
          enabled: true
238
        oracledb.enqueue_locks.limit:
239
          enabled: true
240
        oracledb.enqueue_locks.usage:
241
          enabled: true
242
        oracledb.enqueue_resources.limit:
243
          enabled: true
244
        oracledb.enqueue_resources.usage:
245
          enabled: true
246
        oracledb.enqueue_deadlocks:
247
          enabled: true
248
          attributes:
249
            - oracle.db.pdb
250
        oracledb.exchange_deadlocks:
251
          enabled: true
252
          attributes:
253
            - oracle.db.pdb
254

255
        # === Process & Session Metrics ===
256
        oracledb.processes.limit:
257
          enabled: true
258
        oracledb.processes.usage:
259
          enabled: true
260
        oracledb.sessions.limit:
261
          enabled: true
262
        oracledb.sessions.usage:
263
          enabled: true
264
          attributes:
265
            - session_type
266
            - session_status
267
            - oracle.db.pdb
268
        oracledb.logons:
269
          enabled: true
270
          attributes:
271
            - oracle.db.pdb
272

273
        # === Transaction Metrics ===
274
        oracledb.transactions.limit:
275
          enabled: true
276
        oracledb.transactions.usage:
277
          enabled: true
278
        oracledb.user_commits:
279
          enabled: true
280
          attributes:
281
            - oracle.db.pdb
282
        oracledb.user_rollbacks:
283
          enabled: true
284
          attributes:
285
            - oracle.db.pdb
286

287
        # === Tablespace Metrics ===
288
        oracledb.tablespace_size.limit:
289
          enabled: true
290
          attributes:
291
            - tablespace_name
292
            - oracle.db.pdb
293
        oracledb.tablespace_size.usage:
294
          enabled: true
295
          attributes:
296
            - tablespace_name
297
            - oracle.db.pdb
298

299
        # === Storage Metrics ===
300
        oracledb.storage.usage:
301
          enabled: true
302
        oracledb.storage.utilization:
303
          enabled: true
304
        oracledb.recycle_bin.limit:
305
          enabled: true
306

307
        # === Parallel Operations Metrics ===
308
        oracledb.queries_parallelized:
309
          enabled: true
310
          attributes:
311
            - oracle.db.pdb
312
        oracledb.ddl_statements_parallelized:
313
          enabled: true
314
          attributes:
315
            - oracle.db.pdb
316
        oracledb.dml_statements_parallelized:
317
          enabled: true
318
          attributes:
319
            - oracle.db.pdb
320
        oracledb.parallel_operations_not_downgraded:
321
          enabled: true
322
          attributes:
323
            - oracle.db.pdb
324
        oracledb.parallel_operations_downgraded_1_to_25_pct:
325
          enabled: true
326
          attributes:
327
            - oracle.db.pdb
328
        oracledb.parallel_operations_downgraded_25_to_50_pct:
329
          enabled: true
330
          attributes:
331
            - oracle.db.pdb
332
        oracledb.parallel_operations_downgraded_50_to_75_pct:
333
          enabled: true
334
          attributes:
335
            - oracle.db.pdb
336
        oracledb.parallel_operations_downgraded_75_to_99_pct:
337
          enabled: true
338
          attributes:
339
            - oracle.db.pdb
340
        oracledb.parallel_operations_downgraded_to_serial:
341
          enabled: true
342
          attributes:
343
            - oracle.db.pdb
344

345
        # === Redo & Sort Metrics ===
346
        oracledb.redo_allocation.utilization:
347
          enabled: true
348
          attributes:
349
            - oracle.db.pdb
350
        oracledb.sort.ratio:
351
          enabled: true
352
          attributes:
353
            - oracledb.sort.type
354
            - oracle.db.pdb
355

356
        # === Response Time Metrics ===
357
        oracledb.sql_service.response.duration:
358
          enabled: true
359
          attributes:
360
            - oracle.db.pdb
361

362
      # Resource attributes attached to all metrics/logs (all enabled by default)
363
      resource_attributes:
364
        host.name:
365
          enabled: true
366
        oracle.db.hosting_type:
367
          enabled: true
368
        oracle.db.open_mode:
369
          enabled: true
370
        oracle.db.pdb:
371
          enabled: true
372
        oracle.db.role:
373
          enabled: true
374
        oracle.db.version:
375
          enabled: true
376
        oracledb.instance.name:
377
          enabled: true
378
        service.instance.id:
379
          enabled: true
380

381
processors:
382
    metricstransform:
383
      transforms:
384
        - include: system.cpu.utilization
385
          action: update
386
          operations:
387
            - action: aggregate_labels
388
              label_set: [ state ]
389
              aggregation_type: mean
390
        - include: system.paging.operations
391
          action: update
392
          operations:
393
            - action: aggregate_labels
394
              label_set: [ direction ]
395
              aggregation_type: sum
396
    filter/exclude_cpu_utilization:
397
      metrics:
398
        datapoint:
399
          - 'metric.name == "system.cpu.utilization" and attributes["state"] == "interrupt"'
400
          - 'metric.name == "system.cpu.utilization" and attributes["state"] == "nice"'
401
          - 'metric.name == "system.cpu.utilization" and attributes["state"] == "softirq"'
402
    filter/exclude_memory_utilization:
403
      metrics:
404
        datapoint:
405
          - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_unreclaimable"'
406
          - 'metric.name == "system.memory.utilization" and attributes["state"] == "inactive"'
407
          - 'metric.name == "system.memory.utilization" and attributes["state"] == "cached"'
408
          - 'metric.name == "system.memory.utilization" and attributes["state"] == "buffered"'
409
          - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_reclaimable"'
410
    filter/exclude_memory_usage:
411
      metrics:
412
        datapoint:
413
          - 'metric.name == "system.memory.usage" and attributes["state"] == "slab_unreclaimable"'
414
          - 'metric.name == "system.memory.usage" and attributes["state"] == "inactive"'
415
    filter/exclude_filesystem_utilization:
416
      metrics:
417
        datapoint:
418
          - 'metric.name == "system.filesystem.utilization" and attributes["type"] == "squashfs"'
419
    filter/exclude_filesystem_usage:
420
      metrics:
421
        datapoint:
422
          - 'metric.name == "system.filesystem.usage" and attributes["type"] == "squashfs"'
423
          - 'metric.name == "system.filesystem.usage" and attributes["state"] == "reserved"'
424
    filter/exclude_filesystem_inodes_usage:
425
      metrics:
426
        datapoint:
427
          - 'metric.name == "system.filesystem.inodes.usage" and attributes["type"] == "squashfs"'
428
          - 'metric.name == "system.filesystem.inodes.usage" and attributes["state"] == "reserved"'
429
    filter/exclude_system_disk:
430
      metrics:
431
        datapoint:
432
          - 'metric.name == "system.disk.operations" and IsMatch(attributes["device"], "^loop.*") == true'
433
          - 'metric.name == "system.disk.merged" and IsMatch(attributes["device"], "^loop.*") == true'
434
          - 'metric.name == "system.disk.io" and IsMatch(attributes["device"], "^loop.*") == true'
435
          - 'metric.name == "system.disk.io_time" and IsMatch(attributes["device"], "^loop.*") == true'
436
          - 'metric.name == "system.disk.operation_time" and IsMatch(attributes["device"], "^loop.*") == true'
437
    filter/exclude_system_paging:
438
      metrics:
439
        datapoint:
440
          - 'metric.name == "system.paging.usage" and attributes["state"] == "cached"'
441
          - 'metric.name == "system.paging.operations" and attributes["type"] == "cached"'
442
    filter/exclude_network:
443
      metrics:
444
        datapoint:
445
          - 'IsMatch(metric.name, "^system.network.*") == true and attributes["device"] == "lo"'
446
    attributes/exclude_system_paging:
447
      include:
448
        match_type: strict
449
        metric_names:
450
          - system.paging.operations
451
      actions:
452
        - key: type
453
          action: delete
454
    transform/clear_metadata:
455
      metric_statements:
456
        - context: metric
457
          statements:
458
            - set(metric.description, "")
459
            - set(metric.unit, "")
460
    transform/host:
461
      metric_statements:
462
        - context: metric
463
          statements:
464
            - set(metric.description, "")
465
            - set(metric.unit, "")
466
    transform:
467
      trace_statements:
468
        - context: span
469
          statements:
470
            - truncate_all(span.attributes, 4095)
471
            - truncate_all(resource.attributes, 4095)
472
      log_statements:
473
        - context: log
474
          statements:
475
            - truncate_all(log.attributes, 4095)
476
            - truncate_all(resource.attributes, 4095)
477
    memory_limiter:
478
      check_interval: 1s
479
      limit_mib: ${env:NEW_RELIC_MEMORY_LIMIT_MIB:-100}
480
    batch:
481
    resource/add_event_name:
482
      attributes:
483
        - key: host.address
484
          value: YOUR_DB_HOST
485
          action: upsert
486
    resourcedetection:
487
      detectors: ["system"]
488
      system:
489
        hostname_sources: ["os"]
490
        resource_attributes:
491
          host.id:
492
            enabled: true
493
    resourcedetection/db_safe:
494
      detectors: ["system"]
495
      override: false
496
      system:
497
        hostname_sources: ["os"]
498
        resource_attributes:
499
          host.id:
500
            enabled: true
501
    resourcedetection/cloud:
502
      detectors: ["gcp", "ec2", "azure"]
503
      timeout: 2s
504
      override: true
505
    resourcedetection/env:
506
      detectors: ["env"]
507
      timeout: 2s
508
      override: true
509
exporters:
510
    otlp:
511
      endpoint: https://otlp.nr-data.net:4318
512
      headers:
513
        api-key: YOUR_LICENSE_KEY
514
      compression: gzip
515
service:
516
    pipelines:
517
      metrics/host:
518
        receivers: [hostmetrics]
519
        processors:
520
          - memory_limiter
521
          - metricstransform
522
          - filter/exclude_cpu_utilization
523
          - filter/exclude_memory_utilization
524
          - filter/exclude_memory_usage
525
          - filter/exclude_filesystem_utilization
526
          - filter/exclude_filesystem_usage
527
          - filter/exclude_filesystem_inodes_usage
528
          - filter/exclude_system_disk
529
          - filter/exclude_network
530
          - attributes/exclude_system_paging
531
          - transform/host
532
          - resourcedetection
533
          - resourcedetection/cloud
534
          - resourcedetection/env
535
          - batch
536
        exporters: [otlp]
537
      traces:
538
        receivers: [otlp]
539
        processors: [memory_limiter, transform, resourcedetection, resourcedetection/cloud, resourcedetection/env, batch]
540
        exporters: [otlp]
541
      metrics:
542
        receivers: [otlp]
543
        processors: [memory_limiter, transform, resourcedetection, resourcedetection/cloud, resourcedetection/env, batch]
544
        exporters: [otlp]
545
      logs:
546
        receivers: [otlp]
547
        processors: [memory_limiter, transform, resourcedetection, resourcedetection/cloud, resourcedetection/env, batch]
548
        exporters: [otlp]
549
      metrics/oracledb:
550
        receivers: [nroracledb]
551
        processors: [resource/add_event_name, batch]
552
        exporters: [otlp]
553
      logs/oracledb:
554
        receivers: [nroracledb]
555
        processors: [resource/add_event_name, batch]
556
        exporters: [otlp]
557
    extensions: [health_check]

This configuration includes both infrastructure host metrics and database monitoring 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
extensions:
2
    health_check:
3
receivers:
4
    otlp:
5
      protocols:
6
        grpc:
7
        http:
8
    hostmetrics:
9
      collection_interval: 60s
10
      scrapers:
11
        cpu:
12
          metrics:
13
            system.cpu.time:
14
              enabled: false
15
            system.cpu.utilization:
16
              enabled: true
17
        load:
18
        memory:
19
          metrics:
20
            system.memory.utilization:
21
              enabled: true
22
        paging:
23
          metrics:
24
            system.paging.utilization:
25
              enabled: false
26
            system.paging.faults:
27
              enabled: false
28
        filesystem:
29
          metrics:
30
            system.filesystem.utilization:
31
              enabled: true
32
        disk:
33
          metrics:
34
            system.disk.merged:
35
              enabled: false
36
            system.disk.pending_operations:
37
              enabled: false
38
            system.disk.weighted_io_time:
39
              enabled: false
40
        network:
41
          metrics:
42
            system.network.connections:
43
              enabled: false
44
        # Uncomment to enable process metrics, which can be noisy but valuable.
45
        # processes:
46
        # process:
47
        #   metrics:
48
        #     process.cpu.utilization:
49
        #       enabled: true
50
        #     process.cpu.time:
51
        #       enabled: false
52
    filelog:
53
      include:
54
        - /var/log/alternatives.log
55
        - /var/log/cloud-init.log
56
        - /var/log/auth.log
57
        - /var/log/dpkg.log
58
        - /var/log/syslog
59
        - /var/log/messages
60
        - /var/log/secure
61
        - /var/log/yum.log
62
    nroracledb:
63
      endpoint: oracle.example.com:1521
64
      username: C##newrelic
65
      password: YOUR_PASSWORD
66
      service: YOUR_CDB_SERVICE_NAME
67
      collection_interval: 10s
68
      events:
69
        db.server.query_sample:
70
          enabled: true
71
        db.server.top_query:
72
          enabled: true
73
        db.server.session.wait_sample:
74
          enabled: true
75

76
      top_query_collection:
77
        max_query_sample_count: 1000
78
        top_query_count: 200
79
        collection_interval: 60s
80
        allowed_comment_keys:
81
          - nr_service_guid
82

83
      query_sample_collection:
84
        max_rows_per_query: 100
85
        allowed_comment_keys:
86
          - nr_service_guid
87

88
      session_wait_event_collection:
89
        max_rows_per_query: 100
90

91
      # Metrics configuration - organized by category
92
      metrics:
93
        # === CPU & Performance Metrics ===
94
        oracledb.cpu_time:
95
          enabled: true
96
          attributes:
97
            - oracle.db.pdb
98
        oracledb.database.cpu.utilization:
99
          enabled: true
100
          attributes:
101
            - oracle.db.pdb
102
        oracledb.host.cpu.utilization:
103
          enabled: true
104
          attributes:
105
            - oracle.db.pdb
106

107
        # === Execution & Parse Metrics ===
108
        oracledb.executions:
109
          enabled: true
110
          attributes:
111
            - oracle.db.pdb
112
        oracledb.execution.utilization:
113
          enabled: true
114
          attributes:
115
            - oracledb.parse.type
116
            - oracle.db.pdb
117
        oracledb.parse_calls:
118
          enabled: true
119
          attributes:
120
            - oracle.db.pdb
121
        oracledb.parse.rate:
122
          enabled: true
123
          attributes:
124
            - oracledb.parse.result
125
            - oracle.db.pdb
126
        oracledb.parse.utilization:
127
          enabled: true
128
          attributes:
129
            - oracle.db.pdb
130
        oracledb.hard_parses:
131
          enabled: true
132
          attributes:
133
            - oracle.db.pdb
134

135
        # === I/O & Physical Read/Write Metrics ===
136
        oracledb.logical_reads:
137
          enabled: true
138
          attributes:
139
            - oracle.db.pdb
140
        oracledb.physical_reads:
141
          enabled: true
142
          attributes:
143
            - oracle.db.pdb
144
        oracledb.physical_reads_direct:
145
          enabled: true
146
          attributes:
147
            - oracle.db.pdb
148
        oracledb.physical_writes:
149
          enabled: true
150
          attributes:
151
            - oracle.db.pdb
152
        oracledb.physical_writes_direct:
153
          enabled: true
154
          attributes:
155
            - oracle.db.pdb
156
        oracledb.physical_read_io_requests:
157
          enabled: true
158
          attributes:
159
            - oracle.db.pdb
160
        oracledb.physical_write_io_requests:
161
          enabled: true
162
          attributes:
163
            - oracle.db.pdb
164

165
        # === New Physical I/O Metrics (detailed) ===
166
        oracledb.physical_io.cache_writes:
167
          enabled: true
168
          attributes:
169
            - oracle.db.pdb
170
        oracledb.physical_io.requests:
171
          enabled: true
172
          attributes:
173
            - disk.io.direction
174
            - disk.io.block_size
175
            - oracle.db.pdb
176
        oracledb.physical_io.transferred:
177
          enabled: true
178
          attributes:
179
            - disk.io.direction
180
            - disk.io.type
181
            - oracle.db.pdb
182

183
        # === Network I/O Metrics ===
184
        oracledb.sqlnet.io.transferred:
185
          enabled: true
186
          attributes:
187
            - network.io.direction
188
            - destination.type
189
            - oracle.db.pdb
190

191
        # === Buffer & Cache Metrics ===
192
        oracledb.consistent_gets:
193
          enabled: true
194
          attributes:
195
            - oracle.db.pdb
196
        oracledb.db_block_gets:
197
          enabled: true
198
          attributes:
199
            - oracle.db.pdb
200
        oracledb.buffer_cache.utilization:
201
          enabled: true
202
          attributes:
203
            - oracle.db.pdb
204
        oracledb.library_cache.utilization:
205
          enabled: true
206
          attributes:
207
            - oracle.db.pdb
208
        oracledb.data_dictionary.hit_ratio:
209
          enabled: true
210
        oracledb.shared_pool.utilization:
211
          enabled: true
212
          attributes:
213
            - oracle.db.pdb
214

215
        # === Memory Metrics ===
216
        oracledb.pga_memory:
217
          enabled: true
218
          attributes:
219
            - oracle.db.pdb
220
        oracledb.sga.limit:
221
          enabled: true
222
        oracledb.sga.usage:
223
          enabled: true
224
          attributes:
225
            - oracledb.sga.component.name
226

227
        # === Wait & Database Time Metrics ===
228
        oracledb.database.wait.utilization:
229
          enabled: true
230
          attributes:
231
            - oracle.db.pdb
232

233
        # === Lock & Deadlock Metrics ===
234
        oracledb.dml_locks.limit:
235
          enabled: true
236
        oracledb.dml_locks.usage:
237
          enabled: true
238
        oracledb.enqueue_locks.limit:
239
          enabled: true
240
        oracledb.enqueue_locks.usage:
241
          enabled: true
242
        oracledb.enqueue_resources.limit:
243
          enabled: true
244
        oracledb.enqueue_resources.usage:
245
          enabled: true
246
        oracledb.enqueue_deadlocks:
247
          enabled: true
248
          attributes:
249
            - oracle.db.pdb
250
        oracledb.exchange_deadlocks:
251
          enabled: true
252
          attributes:
253
            - oracle.db.pdb
254

255
        # === Process & Session Metrics ===
256
        oracledb.processes.limit:
257
          enabled: true
258
        oracledb.processes.usage:
259
          enabled: true
260
        oracledb.sessions.limit:
261
          enabled: true
262
        oracledb.sessions.usage:
263
          enabled: true
264
          attributes:
265
            - session_type
266
            - session_status
267
            - oracle.db.pdb
268
        oracledb.logons:
269
          enabled: true
270
          attributes:
271
            - oracle.db.pdb
272

273
        # === Transaction Metrics ===
274
        oracledb.transactions.limit:
275
          enabled: true
276
        oracledb.transactions.usage:
277
          enabled: true
278
        oracledb.user_commits:
279
          enabled: true
280
          attributes:
281
            - oracle.db.pdb
282
        oracledb.user_rollbacks:
283
          enabled: true
284
          attributes:
285
            - oracle.db.pdb
286

287
        # === Tablespace Metrics ===
288
        oracledb.tablespace_size.limit:
289
          enabled: true
290
          attributes:
291
            - tablespace_name
292
            - oracle.db.pdb
293
        oracledb.tablespace_size.usage:
294
          enabled: true
295
          attributes:
296
            - tablespace_name
297
            - oracle.db.pdb
298

299
        # === Storage Metrics ===
300
        oracledb.storage.usage:
301
          enabled: true
302
        oracledb.storage.utilization:
303
          enabled: true
304
        oracledb.recycle_bin.limit:
305
          enabled: true
306

307
        # === Parallel Operations Metrics ===
308
        oracledb.queries_parallelized:
309
          enabled: true
310
          attributes:
311
            - oracle.db.pdb
312
        oracledb.ddl_statements_parallelized:
313
          enabled: true
314
          attributes:
315
            - oracle.db.pdb
316
        oracledb.dml_statements_parallelized:
317
          enabled: true
318
          attributes:
319
            - oracle.db.pdb
320
        oracledb.parallel_operations_not_downgraded:
321
          enabled: true
322
          attributes:
323
            - oracle.db.pdb
324
        oracledb.parallel_operations_downgraded_1_to_25_pct:
325
          enabled: true
326
          attributes:
327
            - oracle.db.pdb
328
        oracledb.parallel_operations_downgraded_25_to_50_pct:
329
          enabled: true
330
          attributes:
331
            - oracle.db.pdb
332
        oracledb.parallel_operations_downgraded_50_to_75_pct:
333
          enabled: true
334
          attributes:
335
            - oracle.db.pdb
336
        oracledb.parallel_operations_downgraded_75_to_99_pct:
337
          enabled: true
338
          attributes:
339
            - oracle.db.pdb
340
        oracledb.parallel_operations_downgraded_to_serial:
341
          enabled: true
342
          attributes:
343
            - oracle.db.pdb
344

345
        # === Redo & Sort Metrics ===
346
        oracledb.redo_allocation.utilization:
347
          enabled: true
348
          attributes:
349
            - oracle.db.pdb
350
        oracledb.sort.ratio:
351
          enabled: true
352
          attributes:
353
            - oracledb.sort.type
354
            - oracle.db.pdb
355

356
        # === Response Time Metrics ===
357
        oracledb.sql_service.response.duration:
358
          enabled: true
359
          attributes:
360
            - oracle.db.pdb
361

362

363
        # === ASM (Automatic Storage Management) Metrics ===
364
        # Disabled by default (opt-in). Requires the V_$ASM_DISKGROUP_STAT and
365
        # V_$ASM_DISK_STAT grants from the previous step.
366
        oracledb.asm.disk_group.free:
367
          enabled: false
368
        oracledb.asm.disk_group.capacity:
369
          enabled: false
370
        oracledb.asm.disk_group.usable_free:
371
          enabled: false
372
        oracledb.asm.disk_group.offline_disks:
373
          enabled: false
374
        oracledb.asm.disk.errors:
375
          enabled: false
376

377
      # Resource attributes attached to all metrics/logs (all enabled by default)
378
      resource_attributes:
379
        host.name:
380
          enabled: true
381
        oracle.db.hosting_type:
382
          enabled: true
383
        oracle.db.open_mode:
384
          enabled: true
385
        oracle.db.pdb:
386
          enabled: true
387
        oracle.db.role:
388
          enabled: true
389
        oracle.db.version:
390
          enabled: true
391
        oracledb.instance.name:
392
          enabled: true
393
        service.instance.id:
394
          enabled: true
395

396
processors:
397
    metricstransform:
398
      transforms:
399
        - include: system.cpu.utilization
400
          action: update
401
          operations:
402
            - action: aggregate_labels
403
              label_set: [ state ]
404
              aggregation_type: mean
405
        - include: system.paging.operations
406
          action: update
407
          operations:
408
            - action: aggregate_labels
409
              label_set: [ direction ]
410
              aggregation_type: sum
411
    filter/exclude_cpu_utilization:
412
      metrics:
413
        datapoint:
414
          - 'metric.name == "system.cpu.utilization" and attributes["state"] == "interrupt"'
415
          - 'metric.name == "system.cpu.utilization" and attributes["state"] == "nice"'
416
          - 'metric.name == "system.cpu.utilization" and attributes["state"] == "softirq"'
417
    filter/exclude_memory_utilization:
418
      metrics:
419
        datapoint:
420
          - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_unreclaimable"'
421
          - 'metric.name == "system.memory.utilization" and attributes["state"] == "inactive"'
422
          - 'metric.name == "system.memory.utilization" and attributes["state"] == "cached"'
423
          - 'metric.name == "system.memory.utilization" and attributes["state"] == "buffered"'
424
          - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_reclaimable"'
425
    filter/exclude_memory_usage:
426
      metrics:
427
        datapoint:
428
          - 'metric.name == "system.memory.usage" and attributes["state"] == "slab_unreclaimable"'
429
          - 'metric.name == "system.memory.usage" and attributes["state"] == "inactive"'
430
    filter/exclude_filesystem_utilization:
431
      metrics:
432
        datapoint:
433
          - 'metric.name == "system.filesystem.utilization" and attributes["type"] == "squashfs"'
434
    filter/exclude_filesystem_usage:
435
      metrics:
436
        datapoint:
437
          - 'metric.name == "system.filesystem.usage" and attributes["type"] == "squashfs"'
438
          - 'metric.name == "system.filesystem.usage" and attributes["state"] == "reserved"'
439
    filter/exclude_filesystem_inodes_usage:
440
      metrics:
441
        datapoint:
442
          - 'metric.name == "system.filesystem.inodes.usage" and attributes["type"] == "squashfs"'
443
          - 'metric.name == "system.filesystem.inodes.usage" and attributes["state"] == "reserved"'
444
    filter/exclude_system_disk:
445
      metrics:
446
        datapoint:
447
          - 'metric.name == "system.disk.operations" and IsMatch(attributes["device"], "^loop.*") == true'
448
          - 'metric.name == "system.disk.merged" and IsMatch(attributes["device"], "^loop.*") == true'
449
          - 'metric.name == "system.disk.io" and IsMatch(attributes["device"], "^loop.*") == true'
450
          - 'metric.name == "system.disk.io_time" and IsMatch(attributes["device"], "^loop.*") == true'
451
          - 'metric.name == "system.disk.operation_time" and IsMatch(attributes["device"], "^loop.*") == true'
452
    filter/exclude_system_paging:
453
      metrics:
454
        datapoint:
455
          - 'metric.name == "system.paging.usage" and attributes["state"] == "cached"'
456
          - 'metric.name == "system.paging.operations" and attributes["type"] == "cached"'
457
    filter/exclude_network:
458
      metrics:
459
        datapoint:
460
          - 'IsMatch(metric.name, "^system.network.*") == true and attributes["device"] == "lo"'
461
    attributes/exclude_system_paging:
462
      include:
463
        match_type: strict
464
        metric_names:
465
          - system.paging.operations
466
      actions:
467
        - key: type
468
          action: delete
469
    transform/clear_metadata:
470
      metric_statements:
471
        - context: metric
472
          statements:
473
            - set(metric.description, "")
474
            - set(metric.unit, "")
475
    transform/host:
476
      metric_statements:
477
        - context: metric
478
          statements:
479
            - set(metric.description, "")
480
            - set(metric.unit, "")
481
    transform:
482
      trace_statements:
483
        - context: span
484
          statements:
485
            - truncate_all(span.attributes, 4095)
486
            - truncate_all(resource.attributes, 4095)
487
      log_statements:
488
        - context: log
489
          statements:
490
            - truncate_all(log.attributes, 4095)
491
            - truncate_all(resource.attributes, 4095)
492
    memory_limiter:
493
      check_interval: 1s
494
      limit_mib: ${env:NEW_RELIC_MEMORY_LIMIT_MIB:-100}
495
    batch:
496
    resource/add_event_name:
497
      attributes:
498
        - key: host.address
499
          value: YOUR_DB_HOST
500
          action: upsert
501
    resourcedetection:
502
      detectors: ["system"]
503
      system:
504
        hostname_sources: ["os"]
505
        resource_attributes:
506
          host.id:
507
            enabled: true
508
    resourcedetection/db_safe:
509
      detectors: ["system"]
510
      override: false
511
      system:
512
        hostname_sources: ["os"]
513
        resource_attributes:
514
          host.id:
515
            enabled: true
516
    resourcedetection/cloud:
517
      detectors: ["gcp", "ec2", "azure"]
518
      timeout: 2s
519
      override: true
520
    resourcedetection/env:
521
      detectors: ["env"]
522
      timeout: 2s
523
      override: true
524
exporters:
525
    otlp:
526
      endpoint: https://otlp.nr-data.net:4318
527
      headers:
528
        api-key: YOUR_LICENSE_KEY
529
      compression: gzip
530
service:
531
    pipelines:
532
      metrics/host:
533
        receivers: [hostmetrics]
534
        processors:
535
          - memory_limiter
536
          - metricstransform
537
          - filter/exclude_cpu_utilization
538
          - filter/exclude_memory_utilization
539
          - filter/exclude_memory_usage
540
          - filter/exclude_filesystem_utilization
541
          - filter/exclude_filesystem_usage
542
          - filter/exclude_filesystem_inodes_usage
543
          - filter/exclude_system_disk
544
          - filter/exclude_network
545
          - attributes/exclude_system_paging
546
          - transform/host
547
          - resourcedetection
548
          - resourcedetection/cloud
549
          - resourcedetection/env
550
          - batch
551
        exporters: [otlp]
552
      traces:
553
        receivers: [otlp]
554
        processors: [memory_limiter, transform, resourcedetection, resourcedetection/cloud, resourcedetection/env, batch]
555
        exporters: [otlp]
556
      metrics:
557
        receivers: [otlp]
558
        processors: [memory_limiter, transform, resourcedetection, resourcedetection/cloud, resourcedetection/env, batch]
559
        exporters: [otlp]
560
      logs:
561
        receivers: [otlp]
562
        processors: [memory_limiter, transform, resourcedetection, resourcedetection/cloud, resourcedetection/env, batch]
563
        exporters: [otlp]
564
      metrics/oracledb:
565
        receivers: [nroracledb]
566
        processors: [resource/add_event_name, batch]
567
        exporters: [otlp]
568
      logs/oracledb:
569
        receivers: [nroracledb]
570
        processors: [resource/add_event_name, batch]
571
        exporters: [otlp]
572
    extensions: [health_check]

RDS

This configuration includes both infrastructure host metrics and database monitoring 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
extensions:
2
    health_check:
3
receivers:
4
    otlp:
5
      protocols:
6
        grpc:
7
        http:
8
    hostmetrics:
9
      collection_interval: 60s
10
      scrapers:
11
        cpu:
12
          metrics:
13
            system.cpu.time:
14
              enabled: false
15
            system.cpu.utilization:
16
              enabled: true
17
        load:
18
        memory:
19
          metrics:
20
            system.memory.utilization:
21
              enabled: true
22
        paging:
23
          metrics:
24
            system.paging.utilization:
25
              enabled: false
26
            system.paging.faults:
27
              enabled: false
28
        filesystem:
29
          metrics:
30
            system.filesystem.utilization:
31
              enabled: true
32
        disk:
33
          metrics:
34
            system.disk.merged:
35
              enabled: false
36
            system.disk.pending_operations:
37
              enabled: false
38
            system.disk.weighted_io_time:
39
              enabled: false
40
        network:
41
          metrics:
42
            system.network.connections:
43
              enabled: false
44
        # Uncomment to enable process metrics, which can be noisy but valuable.
45
        # processes:
46
        # process:
47
        #   metrics:
48
        #     process.cpu.utilization:
49
        #       enabled: true
50
        #     process.cpu.time:
51
        #       enabled: false
52
    filelog:
53
      include:
54
        - /var/log/alternatives.log
55
        - /var/log/cloud-init.log
56
        - /var/log/auth.log
57
        - /var/log/dpkg.log
58
        - /var/log/syslog
59
        - /var/log/messages
60
        - /var/log/secure
61
        - /var/log/yum.log
62
    nroracledb:
63
      endpoint: mydb-instance.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com:1521
64
      username: newrelic
65
      password: YOUR_PASSWORD
66
      service: YOUR_SERVICE_NAME
67
      collection_interval: 10s
68
      events:
69
        db.server.query_sample:
70
          enabled: true
71
        db.server.top_query:
72
          enabled: true
73
        db.server.session.wait_sample:
74
          enabled: true
75

76
      top_query_collection:
77
        max_query_sample_count: 1000
78
        top_query_count: 200
79
        collection_interval: 60s
80
        allowed_comment_keys:
81
          - nr_service_guid
82

83
      query_sample_collection:
84
        max_rows_per_query: 100
85
        allowed_comment_keys:
86
          - nr_service_guid
87

88
      session_wait_event_collection:
89
        max_rows_per_query: 100
90

91
      # Metrics configuration - organized by category
92
      metrics:
93
        # === CPU & Performance Metrics ===
94
        oracledb.cpu_time:
95
          enabled: true
96
          attributes:
97
            - oracle.db.pdb
98
        oracledb.database.cpu.utilization:
99
          enabled: true
100
          attributes:
101
            - oracle.db.pdb
102
        oracledb.host.cpu.utilization:
103
          enabled: true
104
          attributes:
105
            - oracle.db.pdb
106

107
        # === Execution & Parse Metrics ===
108
        oracledb.executions:
109
          enabled: true
110
          attributes:
111
            - oracle.db.pdb
112
        oracledb.execution.utilization:
113
          enabled: true
114
          attributes:
115
            - oracledb.parse.type
116
            - oracle.db.pdb
117
        oracledb.parse_calls:
118
          enabled: true
119
          attributes:
120
            - oracle.db.pdb
121
        oracledb.parse.rate:
122
          enabled: true
123
          attributes:
124
            - oracledb.parse.result
125
            - oracle.db.pdb
126
        oracledb.parse.utilization:
127
          enabled: true
128
          attributes:
129
            - oracle.db.pdb
130
        oracledb.hard_parses:
131
          enabled: true
132
          attributes:
133
            - oracle.db.pdb
134

135
        # === I/O & Physical Read/Write Metrics ===
136
        oracledb.logical_reads:
137
          enabled: true
138
          attributes:
139
            - oracle.db.pdb
140
        oracledb.physical_reads:
141
          enabled: true
142
          attributes:
143
            - oracle.db.pdb
144
        oracledb.physical_reads_direct:
145
          enabled: true
146
          attributes:
147
            - oracle.db.pdb
148
        oracledb.physical_writes:
149
          enabled: true
150
          attributes:
151
            - oracle.db.pdb
152
        oracledb.physical_writes_direct:
153
          enabled: true
154
          attributes:
155
            - oracle.db.pdb
156
        oracledb.physical_read_io_requests:
157
          enabled: true
158
          attributes:
159
            - oracle.db.pdb
160
        oracledb.physical_write_io_requests:
161
          enabled: true
162
          attributes:
163
            - oracle.db.pdb
164

165
        # === New Physical I/O Metrics (detailed) ===
166
        oracledb.physical_io.cache_writes:
167
          enabled: true
168
          attributes:
169
            - oracle.db.pdb
170
        oracledb.physical_io.requests:
171
          enabled: true
172
          attributes:
173
            - disk.io.direction
174
            - disk.io.block_size
175
            - oracle.db.pdb
176
        oracledb.physical_io.transferred:
177
          enabled: true
178
          attributes:
179
            - disk.io.direction
180
            - disk.io.type
181
            - oracle.db.pdb
182

183
        # === Network I/O Metrics ===
184
        oracledb.sqlnet.io.transferred:
185
          enabled: true
186
          attributes:
187
            - network.io.direction
188
            - destination.type
189
            - oracle.db.pdb
190

191
        # === Buffer & Cache Metrics ===
192
        oracledb.consistent_gets:
193
          enabled: true
194
          attributes:
195
            - oracle.db.pdb
196
        oracledb.db_block_gets:
197
          enabled: true
198
          attributes:
199
            - oracle.db.pdb
200
        oracledb.buffer_cache.utilization:
201
          enabled: true
202
          attributes:
203
            - oracle.db.pdb
204
        oracledb.library_cache.utilization:
205
          enabled: true
206
          attributes:
207
            - oracle.db.pdb
208
        oracledb.data_dictionary.hit_ratio:
209
          enabled: true
210
        oracledb.shared_pool.utilization:
211
          enabled: true
212
          attributes:
213
            - oracle.db.pdb
214

215
        # === Memory Metrics ===
216
        oracledb.pga_memory:
217
          enabled: true
218
          attributes:
219
            - oracle.db.pdb
220
        oracledb.sga.limit:
221
          enabled: true
222
        oracledb.sga.usage:
223
          enabled: true
224
          attributes:
225
            - oracledb.sga.component.name
226

227
        # === Wait & Database Time Metrics ===
228
        oracledb.database.wait.utilization:
229
          enabled: true
230
          attributes:
231
            - oracle.db.pdb
232

233
        # === Lock & Deadlock Metrics ===
234
        oracledb.dml_locks.limit:
235
          enabled: true
236
        oracledb.dml_locks.usage:
237
          enabled: true
238
        oracledb.enqueue_locks.limit:
239
          enabled: true
240
        oracledb.enqueue_locks.usage:
241
          enabled: true
242
        oracledb.enqueue_resources.limit:
243
          enabled: true
244
        oracledb.enqueue_resources.usage:
245
          enabled: true
246
        oracledb.enqueue_deadlocks:
247
          enabled: true
248
          attributes:
249
            - oracle.db.pdb
250
        oracledb.exchange_deadlocks:
251
          enabled: true
252
          attributes:
253
            - oracle.db.pdb
254

255
        # === Process & Session Metrics ===
256
        oracledb.processes.limit:
257
          enabled: true
258
        oracledb.processes.usage:
259
          enabled: true
260
        oracledb.sessions.limit:
261
          enabled: true
262
        oracledb.sessions.usage:
263
          enabled: true
264
          attributes:
265
            - session_type
266
            - session_status
267
            - oracle.db.pdb
268
        oracledb.logons:
269
          enabled: true
270
          attributes:
271
            - oracle.db.pdb
272

273
        # === Transaction Metrics ===
274
        oracledb.transactions.limit:
275
          enabled: true
276
        oracledb.transactions.usage:
277
          enabled: true
278
        oracledb.user_commits:
279
          enabled: true
280
          attributes:
281
            - oracle.db.pdb
282
        oracledb.user_rollbacks:
283
          enabled: true
284
          attributes:
285
            - oracle.db.pdb
286

287
        # === Tablespace Metrics ===
288
        oracledb.tablespace_size.limit:
289
          enabled: true
290
          attributes:
291
            - tablespace_name
292
            - oracle.db.pdb
293
        oracledb.tablespace_size.usage:
294
          enabled: true
295
          attributes:
296
            - tablespace_name
297
            - oracle.db.pdb
298

299
        # === Storage Metrics ===
300
        oracledb.storage.usage:
301
          enabled: true
302
        oracledb.storage.utilization:
303
          enabled: true
304
        oracledb.recycle_bin.limit:
305
          enabled: true
306

307
        # === Parallel Operations Metrics ===
308
        oracledb.queries_parallelized:
309
          enabled: true
310
          attributes:
311
            - oracle.db.pdb
312
        oracledb.ddl_statements_parallelized:
313
          enabled: true
314
          attributes:
315
            - oracle.db.pdb
316
        oracledb.dml_statements_parallelized:
317
          enabled: true
318
          attributes:
319
            - oracle.db.pdb
320
        oracledb.parallel_operations_not_downgraded:
321
          enabled: true
322
          attributes:
323
            - oracle.db.pdb
324
        oracledb.parallel_operations_downgraded_1_to_25_pct:
325
          enabled: true
326
          attributes:
327
            - oracle.db.pdb
328
        oracledb.parallel_operations_downgraded_25_to_50_pct:
329
          enabled: true
330
          attributes:
331
            - oracle.db.pdb
332
        oracledb.parallel_operations_downgraded_50_to_75_pct:
333
          enabled: true
334
          attributes:
335
            - oracle.db.pdb
336
        oracledb.parallel_operations_downgraded_75_to_99_pct:
337
          enabled: true
338
          attributes:
339
            - oracle.db.pdb
340
        oracledb.parallel_operations_downgraded_to_serial:
341
          enabled: true
342
          attributes:
343
            - oracle.db.pdb
344

345
        # === Redo & Sort Metrics ===
346
        oracledb.redo_allocation.utilization:
347
          enabled: true
348
          attributes:
349
            - oracle.db.pdb
350
        oracledb.sort.ratio:
351
          enabled: true
352
          attributes:
353
            - oracledb.sort.type
354
            - oracle.db.pdb
355

356
        # === Response Time Metrics ===
357
        oracledb.sql_service.response.duration:
358
          enabled: true
359
          attributes:
360
            - oracle.db.pdb
361

362
      # Resource attributes attached to all metrics/logs (all enabled by default)
363
      resource_attributes:
364
        host.name:
365
          enabled: true
366
        oracle.db.hosting_type:
367
          enabled: true
368
        oracle.db.open_mode:
369
          enabled: true
370
        oracle.db.pdb:
371
          enabled: true
372
        oracle.db.role:
373
          enabled: true
374
        oracle.db.version:
375
          enabled: true
376
        oracledb.instance.name:
377
          enabled: true
378
        service.instance.id:
379
          enabled: true
380
processors:
381
    metricstransform:
382
      transforms:
383
        - include: system.cpu.utilization
384
          action: update
385
          operations:
386
            - action: aggregate_labels
387
              label_set: [ state ]
388
              aggregation_type: mean
389
        - include: system.paging.operations
390
          action: update
391
          operations:
392
            - action: aggregate_labels
393
              label_set: [ direction ]
394
              aggregation_type: sum
395
    filter/exclude_cpu_utilization:
396
      metrics:
397
        datapoint:
398
          - 'metric.name == "system.cpu.utilization" and attributes["state"] == "interrupt"'
399
          - 'metric.name == "system.cpu.utilization" and attributes["state"] == "nice"'
400
          - 'metric.name == "system.cpu.utilization" and attributes["state"] == "softirq"'
401
    filter/exclude_memory_utilization:
402
      metrics:
403
        datapoint:
404
          - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_unreclaimable"'
405
          - 'metric.name == "system.memory.utilization" and attributes["state"] == "inactive"'
406
          - 'metric.name == "system.memory.utilization" and attributes["state"] == "cached"'
407
          - 'metric.name == "system.memory.utilization" and attributes["state"] == "buffered"'
408
          - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_reclaimable"'
409
    filter/exclude_memory_usage:
410
      metrics:
411
        datapoint:
412
          - 'metric.name == "system.memory.usage" and attributes["state"] == "slab_unreclaimable"'
413
          - 'metric.name == "system.memory.usage" and attributes["state"] == "inactive"'
414
    filter/exclude_filesystem_utilization:
415
      metrics:
416
        datapoint:
417
          - 'metric.name == "system.filesystem.utilization" and attributes["type"] == "squashfs"'
418
    filter/exclude_filesystem_usage:
419
      metrics:
420
        datapoint:
421
          - 'metric.name == "system.filesystem.usage" and attributes["type"] == "squashfs"'
422
          - 'metric.name == "system.filesystem.usage" and attributes["state"] == "reserved"'
423
    filter/exclude_filesystem_inodes_usage:
424
      metrics:
425
        datapoint:
426
          - 'metric.name == "system.filesystem.inodes.usage" and attributes["type"] == "squashfs"'
427
          - 'metric.name == "system.filesystem.inodes.usage" and attributes["state"] == "reserved"'
428
    filter/exclude_system_disk:
429
      metrics:
430
        datapoint:
431
          - 'metric.name == "system.disk.operations" and IsMatch(attributes["device"], "^loop.*") == true'
432
          - 'metric.name == "system.disk.merged" and IsMatch(attributes["device"], "^loop.*") == true'
433
          - 'metric.name == "system.disk.io" and IsMatch(attributes["device"], "^loop.*") == true'
434
          - 'metric.name == "system.disk.io_time" and IsMatch(attributes["device"], "^loop.*") == true'
435
          - 'metric.name == "system.disk.operation_time" and IsMatch(attributes["device"], "^loop.*") == true'
436
    filter/exclude_system_paging:
437
      metrics:
438
        datapoint:
439
          - 'metric.name == "system.paging.usage" and attributes["state"] == "cached"'
440
          - 'metric.name == "system.paging.operations" and attributes["type"] == "cached"'
441
    filter/exclude_network:
442
      metrics:
443
        datapoint:
444
          - 'IsMatch(metric.name, "^system.network.*") == true and attributes["device"] == "lo"'
445
    attributes/exclude_system_paging:
446
      include:
447
        match_type: strict
448
        metric_names:
449
          - system.paging.operations
450
      actions:
451
        - key: type
452
          action: delete
453
    transform/clear_metadata:
454
      metric_statements:
455
        - context: metric
456
          statements:
457
            - set(metric.description, "")
458
            - set(metric.unit, "")
459
    transform/host:
460
      metric_statements:
461
        - context: metric
462
          statements:
463
            - set(metric.description, "")
464
            - set(metric.unit, "")
465
    transform:
466
      trace_statements:
467
        - context: span
468
          statements:
469
            - truncate_all(span.attributes, 4095)
470
            - truncate_all(resource.attributes, 4095)
471
      log_statements:
472
        - context: log
473
          statements:
474
            - truncate_all(log.attributes, 4095)
475
            - truncate_all(resource.attributes, 4095)
476
    memory_limiter:
477
      check_interval: 1s
478
      limit_mib: ${env:NEW_RELIC_MEMORY_LIMIT_MIB:-100}
479
    batch:
480
    resource/add_event_name:
481
      attributes:
482
        - key: host.address
483
          value: YOUR_DB_HOST
484
          action: upsert
485
    resourcedetection:
486
      detectors: ["system"]
487
      system:
488
        hostname_sources: ["os"]
489
        resource_attributes:
490
          host.id:
491
            enabled: true
492
    resourcedetection/db_safe:
493
      detectors: ["system"]
494
      override: false
495
      system:
496
        hostname_sources: ["os"]
497
        resource_attributes:
498
          host.id:
499
            enabled: true
500
    resourcedetection/cloud:
501
      detectors: ["gcp", "ec2", "azure"]
502
      timeout: 2s
503
      override: true
504
    resourcedetection/env:
505
      detectors: ["env"]
506
      timeout: 2s
507
      override: true
508
exporters:
509
    otlp:
510
      endpoint: https://otlp.nr-data.net:4318
511
      headers:
512
        api-key: YOUR_LICENSE_KEY
513
      compression: gzip
514
service:
515
    pipelines:
516
      metrics/host:
517
        receivers: [hostmetrics]
518
        processors:
519
          - memory_limiter
520
          - metricstransform
521
          - filter/exclude_cpu_utilization
522
          - filter/exclude_memory_utilization
523
          - filter/exclude_memory_usage
524
          - filter/exclude_filesystem_utilization
525
          - filter/exclude_filesystem_usage
526
          - filter/exclude_filesystem_inodes_usage
527
          - filter/exclude_system_disk
528
          - filter/exclude_network
529
          - attributes/exclude_system_paging
530
          - transform/host
531
          - resourcedetection
532
          - resourcedetection/cloud
533
          - resourcedetection/env
534
          - batch
535
        exporters: [otlp]
536
      traces:
537
        receivers: [otlp]
538
        processors: [memory_limiter, transform, resourcedetection, resourcedetection/cloud, resourcedetection/env, batch]
539
        exporters: [otlp]
540
      metrics:
541
        receivers: [otlp]
542
        processors: [memory_limiter, transform, resourcedetection, resourcedetection/cloud, resourcedetection/env, batch]
543
        exporters: [otlp]
544
      logs:
545
        receivers: [otlp]
546
        processors: [memory_limiter, transform, resourcedetection, resourcedetection/cloud, resourcedetection/env, batch]
547
        exporters: [otlp]
548
      metrics/oracledb:
549
        receivers: [nroracledb]
550
        processors: [resource/add_event_name, batch]
551
        exporters: [otlp]
552
      logs/oracledb:
553
        receivers: [nroracledb]
554
        processors: [resource/add_event_name, batch]
555
        exporters: [otlp]
556
    extensions: [health_check]

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.

Configuration reference for Oracle Database monitoring with NRDOT

Important

On-host

For on-host Pluggable Database (PDB)

For on-host Container Database (CDB)

RDS

For Amazon RDS

CDB instrumentation

PDB instrumentation

RDS instrumentation

Configuration reference for Oracle Database monitoring with NRDOT

Important

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

For on-host Container Database (CDB)

RDS

For Amazon RDS

Related documentation

CDB instrumentation

PDB instrumentation

RDS instrumentation

On-host