NRDOTを使用したOracle Database監視の設定リファレンス

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]

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]