Autonomous 데이터베이스를 사용한 오라클 모니터링을 위한 NRDOT 설치 및 구성

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 configuration - This baseline configuration captures essential metrics. To enable advanced monitoring and extended telemetry, refer to the full configuration documentation
38
metrics:
39
   oracledb.buffer_cache.utilization:
40
     enabled: true
41
     attributes:
42
       - oracle.db.pdb
43
   oracledb.consistent_gets:
44
     enabled: true
45
     attributes:
46
       - oracle.db.pdb
47
   oracledb.cpu_time:
48
     enabled: true
49
     attributes:
50
       - oracle.db.pdb
51
   oracledb.database.cpu.utilization:
52
     enabled: true
53
     attributes:
54
       - oracle.db.pdb
55
   oracledb.database.wait.utilization:
56
     enabled: true
57
     attributes:
58
       - oracle.db.pdb
59
   oracledb.db_block_gets:
60
     enabled: true
61
     attributes:
62
       - oracle.db.pdb
63
   oracledb.enqueue_deadlocks:
64
     enabled: true
65
     attributes:
66
       - oracle.db.pdb
67
   oracledb.execution.utilization:
68
     enabled: true
69
     attributes:
70
       - oracledb.parse.type
71
       - oracle.db.pdb
72
   oracledb.executions:
73
     enabled: true
74
     attributes:
75
       - oracle.db.pdb
76
   oracledb.hard_parses:
77
     enabled: true
78
     attributes:
79
       - oracle.db.pdb
80
   oracledb.host.cpu.utilization:
81
     enabled: true
82
     attributes:
83
       - oracle.db.pdb
84
   oracledb.library_cache.utilization:
85
     enabled: true
86
     attributes:
87
       - oracle.db.pdb
88
   oracledb.logical_reads:
89
     enabled: true
90
     attributes:
91
       - oracle.db.pdb
92
   oracledb.logons:
93
     enabled: true
94
     attributes:
95
       - oracle.db.pdb
96
   oracledb.parse.rate:
97
     enabled: true
98
     attributes:
99
       - oracledb.parse.result
100
       - oracle.db.pdb
101
   oracledb.parse_calls:
102
     enabled: true
103
     attributes:
104
       - oracle.db.pdb
105
   oracledb.pga_memory:
106
     enabled: true
107
     attributes:
108
       - oracle.db.pdb
109
   oracledb.physical_io.requests:
110
     enabled: true
111
     attributes:
112
       - disk.io.direction
113
       - disk.io.block_size
114
       - oracle.db.pdb
115
   oracledb.physical_reads:
116
     enabled: true
117
     attributes:
118
       - oracle.db.pdb
119
   oracledb.physical_writes:
120
     enabled: true
121
     attributes:
122
       - oracle.db.pdb
123
   oracledb.processes.usage:
124
     enabled: true
125
   oracledb.sessions.usage:
126
     enabled: true
127
     attributes:
128
       - session_type
129
       - session_status
130
       - oracle.db.pdb
131
   oracledb.sga.usage:
132
     enabled: true
133
     attributes:
134
       - oracledb.sga.component.name
135
   oracledb.shared_pool.utilization:
136
     enabled: true
137
     attributes:
138
       - oracle.db.pdb
139
   oracledb.sql_service.response.duration:
140
     enabled: true
141
     attributes:
142
       - oracle.db.pdb
143
   oracledb.sqlnet.io.transferred:
144
     enabled: true
145
     attributes:
146
       - network.io.direction
147
       - destination.type
148
       - oracle.db.pdb
149
   oracledb.tablespace_size.usage:
150
     enabled: true
151
     attributes:
152
       - tablespace_name
153
       - oracle.db.pdb
154
   oracledb.transactions.usage:
155
     enabled: true
156
   oracledb.user_commits:
157
     enabled: true
158
     attributes:
159
       - oracle.db.pdb
160
   oracledb.user_rollbacks:
161
     enabled: true
162
     attributes:
163
       - oracle.db.pdb
164

165
  # Resource attributes attached to all metrics/logs (all enabled by default)
166
resource_attributes:
167
   oracle.db.edition:
168
     enabled: true
169
exporters:
170
  otlp/newrelic:
171
  endpoint: https://otlp.nr-data.net:4318
172
headers:
173
   api-key: YOUR_LICENSE_KEY
174
  compression: gzip
175
retry_on_failure:
176
   enabled: true
177
   initial_interval: 5s
178
   max_interval: 30s
179
   max_elapsed_time: 300s
180
sending_queue:
181
   enabled: true
182
   sizer: bytes
183
   queue_size: 100_000_000
184
   num_consumers: 10
185
   batch:
186
     sizer: bytes
187
     max_size: 1_000_000
188
     min_size: 0
189
     flush_timeout: 5s
190
service:
191
pipelines:
192
  metrics/oracledb:
193
   receivers: [nroracledb/adb]
194
   exporters: [otlp/newrelic]
195
  logs/oracledb:
196
   receivers: [nroracledb/adb]
197
   exporters: [otlp/newrelic]