Install & configure NRDOT Collector for ADB monitoring

Preview

We're still working on this feature, but we'd love for you to try it out!

This feature is currently provided as part of a preview pursuant to our pre-release policies.

Get comprehensive insights into your Oracle Autonomous Database (ADB) performance with database monitoring, query analysis, and system health metrics using the New Relic Distribution of OpenTelemetry (NRDOT) collector.

Guided installation

To install through the New Relic UI instead, go to one.newrelic.com > Integrations & Agents > Oracle (OpenTelemetry) . This page covers the CLI install path only.

Prerequisites

Before you begin, ensure you have the following:

Valid New Relic license key
Supported architecture: Linux with AMD64 and ARM64
Network connectivity to New Relic OTLP endpoint
Oracle Database 19c or later

Enroll to preview

This integration is available as part of the New Relic public preview program. Contact your Organization Manager to opt in from the Previews & Trials page.

Install NRDOT Collector

Select the appropriate installation distribution method for your Linux environment:

For Debian/Ubuntu system, run:
bash
```
$NRDOT_VERSION=$(curl -s https://api.github.com/repos/newrelic/nrdot-collector-releases/releases/latest | grep '"tag_name":' | awk -F'"' '{print $4}') && curl -L "https://github.com/newrelic/nrdot-collector-releases/releases/download/${NRDOT_VERSION}/nrdot-collector_${NRDOT_VERSION}_linux_amd64.deb" --output nrdot-collector.deb && sudo dpkg -i nrdot-collector.deb
```

For RHEL/CentOS/OEL system, run:

bash

$NRDOT_VERSION=$(curl -s https://api.github.com/repos/newrelic/nrdot-collector-releases/releases/latest | grep '"tag_name":' | awk -F'"' '{print $4}') && curl -L "https://github.com/newrelic/nrdot-collector-releases/releases/download/${NRDOT_VERSION}/nrdot-collector_${NRDOT_VERSION}_linux_x86_64.rpm" --output nrdot-collector.rpm && sudo rpm -ivh nrdot-collector.rpm

For Debian/Ubuntu system, run:

bash

$NRDOT_VERSION=$(curl -s https://api.github.com/repos/newrelic/nrdot-collector-releases/releases/latest | grep '"tag_name":' | awk -F'"' '{print $4}') && curl -L "https://github.com/newrelic/nrdot-collector-releases/releases/download/${NRDOT_VERSION}/nrdot-collector_${NRDOT_VERSION}_linux_arm64.deb" --output nrdot-collector.deb && sudo dpkg -i nrdot-collector.deb

For RHEL/CentOS/OEL system, run:

bash

$NRDOT_VERSION=$(curl -s https://api.github.com/repos/newrelic/nrdot-collector-releases/releases/latest | grep '"tag_name":' | awk -F'"' '{print $4}') && curl -L "https://github.com/newrelic/nrdot-collector-releases/releases/download/${NRDOT_VERSION}/nrdot-collector_${NRDOT_VERSION}_linux_aarch64.rpm" --output nrdot-collector.rpm && sudo rpm -ivh nrdot-collector.rpm

Configure database user

Create a monitoring user with the necessary privileges for your ADB Oracle Database instance. Run the following statements as SYS inside your target ADB to create a local monitoring user:

CREATE USER <USER_NAME> IDENTIFIED BY "<YOUR_PASSWORD>";
GRANT CREATE SESSION TO <USER_NAME>;

Grant monitoring privileges for Autonomous Database

Run these commands as an admin inside your ADB. This gives the monitoring tool the basic access it needs to collect metrics, track events, and find your database instances.

GRANT SELECT ON SYS.V_$INSTANCE   TO <USER_NAME>;
GRANT SELECT ON SYS.V_$DATABASE   TO <USER_NAME>;
GRANT SELECT ON SYS.V_$CONTAINERS TO <USER_NAME>;
GRANT SELECT ON SYS.V_$DATAFILE   TO <USER_NAME>;
GRANT SELECT ON SYS.V_$PDBS       TO <USER_NAME>; 
GRANT SELECT ON SYS.V_$SYSSTAT                    TO <USER_NAME>;
GRANT SELECT ON SYS.V_$SYSMETRIC                  TO <USER_NAME>;
GRANT SELECT ON SYS.V_$SESSION                    TO <USER_NAME>;
GRANT SELECT ON SYS.V_$RESOURCE_LIMIT             TO <USER_NAME>;
GRANT SELECT ON SYS.V_$OSSTAT                     TO <USER_NAME>;
GRANT SELECT ON SYS.V_$SGAINFO                    TO <USER_NAME>;
GRANT SELECT ON SYS.V_$ROWCACHE                   TO <USER_NAME>;
GRANT SELECT ON SYS.V_$PARAMETER                  TO <USER_NAME>;
GRANT SELECT ON SYS.DBA_TABLESPACE_USAGE_METRICS  TO <USER_NAME>;
GRANT SELECT ON SYS.DBA_TABLESPACES               TO <USER_NAME>;
GRANT SELECT ON SYS.DBA_DATA_FILES                TO <USER_NAME>;
GRANT SELECT ON SYS.DBA_FREE_SPACE                TO <USER_NAME>;
GRANT SELECT ON SYS.DBA_RECYCLEBIN                TO <USER_NAME>;
GRANT SELECT ON SYS.V_$SQL            TO <USER_NAME>;
GRANT SELECT ON SYS.V_$SQL_PLAN_STATISTICS_ALL       TO <USER_NAME>;
GRANT SELECT ON SYS.V_$LOCK           TO <USER_NAME>;
GRANT SELECT ON SYS.V_$SESSION_EVENT  TO <USER_NAME>;
GRANT SELECT ON SYS.DBA_PROCEDURES    TO <USER_NAME>;
GRANT SELECT ON SYS.DBA_OBJECTS       TO <USER_NAME>;

Configure NRDOT Collector

Configure the NRDOT Collector with your ADB-specific settings. Create a configuration file (e.g., adb-config.yaml) with the following content:

Database Username

Database Password

Oracle ADB Hostname

Oracle ADB Port

Service Name

New Relic OTLP Endpoint

New Relic License Key

adb-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: 10s
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

13
      top_query_collection:
14
        max_query_sample_count: 1000
15
        top_query_count: 200
16
        collection_interval: 60s
17
        allowed_comment_keys:
18
          - nr_service_guid
19

20
      query_sample_collection:
21
        max_rows_per_query: 100
22
        allowed_comment_keys:
23
          - nr_service_guid
24

25
      session_wait_event_collection:
26
        max_rows_per_query: 100
27

28
      metrics:
29
        oracledb.cpu_time:
30
          enabled: true
31
        oracledb.executions:
32
          enabled: true
33
        oracledb.parse_calls:
34
          enabled: true
35
        oracledb.hard_parses:
36
          enabled: true
37
        oracledb.logical_reads:
38
          enabled: true
39
        oracledb.physical_reads:
40
          enabled: true
41
        oracledb.physical_reads_direct:
42
          enabled: true
43
        oracledb.physical_writes:
44
          enabled: true
45
        oracledb.physical_writes_direct:
46
          enabled: true
47
        oracledb.physical_read_io_requests:
48
          enabled: true
49
        oracledb.physical_write_io_requests:
50
          enabled: true
51
        oracledb.physical_io.cache_writes:
52
          enabled: true
53
        oracledb.physical_io.requests:
54
          enabled: true
55
          attributes:
56
            - disk.io.direction
57
            - disk.io.block_size
58
        oracledb.physical_io.transferred:
59
          enabled: true
60
          attributes:
61
            - disk.io.direction
62
            - disk.io.type
63
        oracledb.sqlnet.io.transferred:
64
          enabled: true
65
          attributes:
66
            - network.io.direction
67
            - destination.type
68
        oracledb.consistent_gets:
69
          enabled: true
70
        oracledb.db_block_gets:
71
          enabled: true
72
        oracledb.data_dictionary.hit_ratio:
73
          enabled: true
74
        oracledb.pga_memory:
75
          enabled: true
76
        oracledb.enqueue_deadlocks:
77
          enabled: true
78
        oracledb.exchange_deadlocks:
79
          enabled: true
80
        oracledb.sessions.usage:
81
          enabled: true
82
          attributes:
83
            - session_type
84
            - session_status
85
        oracledb.logons:
86
          enabled: true
87
        oracledb.user_commits:
88
          enabled: true
89
        oracledb.user_rollbacks:
90
          enabled: true
91
        oracledb.tablespace_size.limit:
92
          enabled: true
93
          attributes:
94
            - tablespace_name
95
        oracledb.tablespace_size.usage:
96
          enabled: true
97
          attributes:
98
            - tablespace_name
99
        oracledb.storage.usage:
100
          enabled: true
101
        oracledb.storage.utilization:
102
          enabled: true
103
        oracledb.recycle_bin.limit:
104
          enabled: true
105
        oracledb.queries_parallelized:
106
          enabled: true
107
        oracledb.ddl_statements_parallelized:
108
          enabled: true
109
        oracledb.dml_statements_parallelized:
110
          enabled: true
111
        oracledb.parallel_operations_not_downgraded:
112
          enabled: true
113
        oracledb.parallel_operations_downgraded_1_to_25_pct:
114
          enabled: true
115
        oracledb.parallel_operations_downgraded_25_to_50_pct:
116
          enabled: true
117
        oracledb.parallel_operations_downgraded_50_to_75_pct:
118
          enabled: true
119
        oracledb.parallel_operations_downgraded_75_to_99_pct:
120
          enabled: true
121
        oracledb.parallel_operations_downgraded_to_serial:
122
          enabled: true
123

124
processors:
125
    batch:
126
    resource/add_event_name:
127
      attributes:
128
        - key: host.address
129
          value: YOUR_DB_HOST
130
          action: upsert
131

132
exporters:
133
    otlphttp/newrelic:
134
      endpoint: https://otlp.nr-data.net:4318
135
      headers:
136
        api-key: YOUR_LICENSE_KEY
137
      compression: gzip
138
      retry_on_failure:
139
        enabled: true
140
        initial_interval: 5s
141
        max_interval: 30s
142
        max_elapsed_time: 300s
143

144
service:
145
    telemetry:
146
      metrics:
147
        level: none
148
    pipelines:
149
      metrics/oracledb:
150
        receivers: [nroracledb/adb]
151
        processors: [resource/add_event_name, batch]
152
        exporters: [otlphttp/newrelic]
153
      logs/oracledb:
154
        receivers: [nroracledb/adb]
155
        processors: [resource/add_event_name, batch]
156
        exporters: [otlphttp/newrelic]

The following metrics are not supported in ADB:

oracledb.database.cpu.utilization
oracledb.database.wait.utilization
oracledb.host.cpu.utilization
oracledb.execution.utilization
oracledb.parse.rate
oracledb.parse.utilization
oracledb.sort.ratio
oracledb.sql_service.response.duration
oracledb.buffer_cache.utilization
oracledb.library_cache.utilization
oracledb.shared_pool.utilization
oracledb.redo_allocation.utilization
oracledb.processes.limit
oracledb.processes.usage
oracledb.sessions.limit
oracledb.transactions.limit
oracledb.transactions.usage
oracledb.dml_locks.limit
oracledb.dml_locks.usage
oracledb.enqueue_locks.limit
oracledb.enqueue_locks.usage
oracledb.enqueue_resources.limit
oracledb.enqueue_resources.usage

Dica

You can also:

Configure multiple receivers: To monitor multiple Oracle Database instances from one collector.
Configure SQL Query Receiver: To collect custom metrics from your Oracle Database.
Link your Oracle Database with APM: To correlate your application performance with database operations. This allows you to see exactly which applications are generating specific database workloads.
Set up secret management: To securely manage sensitive information, such as database credentials. This helps to enhance the security of your monitoring setup by avoiding hardcoding sensitive data in configuration files.

Restart NRDOT Collector

After configuring the collector, restart the NRDOT Collector service to apply the changes:

bash

$sudo systemctl restart nrdot-collector

To verify that the collector is running properly, check the service status:

bash

$sudo systemctl status nrdot-collector

Dica

Always restart the NRDOT Collector after making configuration changes to ensure the new settings take effect.

Find and use your data

After you set up the Oracle ADB integration, you can start monitoring and analyzing your database performance in New Relic:

Go to one.newrelic.com > All Entities.
Filter by Oracle to find your database entities.
Select your Oracle ADB entity to view dashboards, metrics, and logs.

For more information about monitoring Oracle databases, refer to our database monitoring documentation.

Troubleshooting

Learn how to troubleshoot your Oracle ADB monitoring setup in New Relic.

Metrics reference

Learn about the available metrics collected by the NRDOT Collector.

RDS instrumentation

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

Install & configure NRDOT Collector for ADB monitoring

Preview

Guided installation

Prerequisites

Enroll to preview

Install NRDOT Collector

For AMD64 architecture

For ARM64 architecture

Configure database user

Grant monitoring privileges for Autonomous Database

Configure NRDOT Collector

ADB Unsupported Metrics

Dica

Restart NRDOT Collector

Dica

Find and use your data

Troubleshooting

Metrics reference

RDS instrumentation

Install & configure NRDOT Collector for ADB monitoring

Preview

Guided installation

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

Enroll to preview

Install NRDOT Collector

For ARM64 architecture

Configure database user

Grant monitoring privileges for Autonomous Database

Configure NRDOT Collector

ADB Unsupported Metrics

Dica

Restart NRDOT Collector

Dica

Find and use your data

Related articles

Troubleshooting

Metrics reference

RDS instrumentation

Prerequisites