NRDOT를 사용한 오라클 데이터베이스 모니터링 설정 참조

이 참조는 뉴렐릭 OpenTelemetry 배포판(NRDOT) Collector를 사용한 오라클 데이터베이스 모니터링을 위한 포괄적인 YAML 설정을 제공합니다. 이 모든 기능을 갖춘 설정에는 온호스트, RDS 및 ADB 배포 전반의 운영 환경을 위한 완전한 오라클 데이터베이스 메트릭 카탈로그가 포함되어 있습니다.

중요

빠르게 시작하고 싶으십니까? 프로덕션 사용을 위한 고급 설정입니다. 오라클 데이터베이스 모니터링을 처음 설정하는 경우, 설정 가이드의 표준 설정으로 시작하여 기본 기능을 확인한 후 이러한 포괄적인 설정으로 돌아올 것을 권장합니다.

온호스트

이 설정은 개별 플러거블 데이터베이스를 모니터링할 때 포괄적인 가시성을 확보할 수 있도록 모든 메트릭이 활성화된 전체 오라클 데이터베이스 메트릭 카탈로그를 포함합니다.

오라클 PDB 호스트명/IP

오라클 PDB 포트

데이터베이스 사용자 이름

데이터베이스 비밀번호

PDB 서비스 이름

뉴렐릭 OTLP 엔드포인트

뉴렐릭 라이선스 키

oracle-config.yaml

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

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

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

32
   session_wait_event_collection:
33
     max_rows_per_query: 100
34

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

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

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

이 설정에는 전체 컨테이너 데이터베이스와 모든 플러거블 데이터베이스를 모니터링할 때 포괄적인 가시성을 확보할 수 있도록 모든 메트릭이 활성화된 완전한 오라클 데이터베이스 메트릭 카탈로그가 포함되어 있습니다.

오라클 CDB 호스트명/IP

오라클 CDB 포트

데이터베이스 사용자 이름(C## 접두사 제외)

데이터베이스 비밀번호

CDB 서비스 이름

뉴렐릭 OTLP 엔드포인트

뉴렐릭 라이선스 키

oracle-config.yaml

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

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

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

32
   session_wait_event_collection:
33
     max_rows_per_query: 100
34

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

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

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

RDS

이 설정에는 Amazon RDS에서 실행되는 오라클 데이터베이스 인스턴스를 모니터링할 때 포괄적인 가시성을 확보할 수 있도록 모든 메트릭이 활성화된 완전한 오라클 데이터베이스 메트릭 카탈로그가 포함되어 있습니다.

오라클 RDS 엔드포인트

오라클 RDS 포트

데이터베이스 사용자 이름

데이터베이스 비밀번호

서비스 이름

뉴렐릭 OTLP 엔드포인트

뉴렐릭 라이선스 키

oracle-config.yaml

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

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

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

32
   session_wait_event_collection:
33
     max_rows_per_query: 100
34

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

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

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

ADB

이 설정은 오라클 Autonomous 데이터베이스 인스턴스를 모니터링할 때 포괄적인 가시성을 확보할 수 있도록, 모든 메트릭이 활성화된 전체 오라클 데이터베이스 메트릭 카탈로그를 포함합니다.

데이터베이스 사용자 이름

데이터베이스 비밀번호

오라클 ADB 호스트명

오라클 ADB 포트

서비스 이름

뉴렐릭 OTLP 엔드포인트

뉴렐릭 라이선스 키

oracle-config.yaml

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

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

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

29
   session_wait_event_collection:
30
     max_rows_per_query: 100
31

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

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

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

CDB 계측

뉴렐릭에서 CDB 모니터링을 위해 오라클 데이터베이스를 설정하는 방법을 알아보십시오.

PDB 계측

뉴렐릭에서 PDB 모니터링을 위해 오라클 데이터베이스를 설정하는 방법을 알아보십시오.

RDS 계측

뉴렐릭에서 RDS 모니터링을 위해 오라클 데이터베이스를 설정하는 방법을 알아보십시오.

ADB 계측

뉴렐릭에서 오라클 Autonomous 데이터베이스를 모니터링하도록 설정하는 방법을 알아보십시오.

사용자의 편의를 위해 제공되는 기계 번역입니다.

NRDOT를 사용한 오라클 데이터베이스 모니터링 설정 참조

중요

온호스트

온호스트 플러그형 데이터베이스(PDB)용

온호스트 컨테이너 데이터베이스(CDB)의 경우

RDS

Amazon RDS의 경우

ADB

Autonomous Database(ADB)용

CDB 계측

PDB 계측

RDS 계측

ADB 계측

사용자의 편의를 위해 제공되는 기계 번역입니다.

NRDOT를 사용한 오라클 데이터베이스 모니터링 설정 참조

중요

온호스트 .css-21sua1{background:none;border:none;width:0;padding:0;}

온호스트 컨테이너 데이터베이스(CDB)의 경우

RDS

Amazon RDS의 경우

ADB

Autonomous Database(ADB)용

관련 문서

CDB 계측

PDB 계측

RDS 계측

ADB 계측

온호스트