• /
  • EnglishEspañolFrançais日本語한국어Português
  • ログイン今すぐ開始

Oracle Database monitoring with NRDOT

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.

New Relic now empowers your team to monitor your Oracle Database performance using New Relic Distribution of OpenTelemetry (NRDOT) with New Relic database monitoring capabilities. This integration provides comprehensive insights into database metrics, query performance, and system health using the NRDOT collector.

This NRDOT-based approach complements our existing On-Host Integration (OHI) by leveraging OpenTelemetry standards for database monitoring, making it easier to integrate with your existing observability stack.

Prerequisites

Before you begin, ensure you have the following:

Set-up the NRDOT Collector for Oracle Database monitoring

You can set up Oracle Database monitoring using the NRDOT Collector in on-host (multitenant) or RDS environments. You can configure NRDOT Collector using the following methods:

  • Guided install: The guided install method provides step-by-step instructions on the New Relic platform to help you install and configure the NRDOT Collector for Oracle Database monitoring.
  • Manual install: The manual install method allows you to set up the NRDOT Collector on your own by following the instructions in this documentation. You can manually configure in following environments:
    • On-host (multitenant) environment: Install the NRDOT Collector on the same host as your Oracle Database instance to collect both infrastructure and database telemetry data.
    • RDS environment: Install the NRDOT Collector in an RDS environment to monitor your Oracle Database instances running in Amazon RDS.

ヒント

The NRDOT Collector collects both infrastructure and database related telemetry data, so you can have a unified observability solution for your Oracle Database environment in New Relic.

To install the NRDOT Collector:

  1. Log in to your New Relic account.

  2. Go to left navigation pane > + Integration & Agents > Oracle (OpenTelemetry).

  3. On the Select an account screen, select the account you want to install the Oracle Database integration on, and click Continue.

  4. On the Enter your credential screen, select one of the following options, then click Continue:

    • Use an existing key: If you already have a license key, provide the license key. For more information, refer to User keys.
    • Create a new key: If you don't have a license key, click Create a new key to create one.

  5. On the Compatibility and requirements screen, ensure that all the requirements are met, and click Continue.

  6. On the Database user configuration screen, select your deployment type to install the integration.

  7. Follow the on-screen instructions to set up the integration for the selected environment.

  8. After installation, on the Test your integration screen, click Test connection to verify that the NRDOT Collector can connect to your Oracle Database instance and send data to New Relic. If the test's successful, you'll see a confirmation message.

Set up APM-database correlation

To correlate your application performance with database operations, you can set up database service identification. This feature allows you to see exactly which applications are generating specific database workloads. For more information, refer to set up database service identification to get APM-database correlation in New Relic.

重要

To view database performance data in APM, both entities must be in the same New Relic account. If the entities are in different New Relic accounts, you must have access to both accounts to view the data.

Find and use your data

Once your data is being collected, you can access comprehensive Oracle Database monitoring through New Relic UI.

To find your Oracle Database entity in New Relic:

  1. Go to https://one.newrelic.com > All Capabilities > Databases.
  2. Set the search criteria as instrumentation.provider = opentelemetry.
  3. Select your Oracle Database from the list of entities.

You can set up Oracle Database monitoring using the NRDOT Collector in on-host or multitenant environments. To install the NRDOT Collector in on-host (multitenant) environments, follow these steps:

Note: All PDBs under this CDB will be monitored.

Installation method

Select the appropriate installation distribution method for your Linux environment:

Configure database user

Create a monitoring user with necessary privileges for your multitenant Oracle Database. This requires creating a common user with the C## prefix.

  1. Before creating the database user or running any assignment grants, you must execute the following statement as a SYS user to set your current active container context to CDB$ROOT:

    ALTER SESSION SET CONTAINER = CDB$ROOT;

  2. For multitenant databases, log in to the root database as an administrator. Use CREATE USER to add a new user to the database. Specified username will be a 'common user' and needs to be prefixed with c## as recommended by Oracle.

    CREATE USER c##<YOUR_DB_USERNAME> IDENTIFIED BY "<USER_PASSWORD>" CONTAINER=ALL;
    GRANT CREATE SESSION TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;

  3. Run the following statement as SYSDBA on the CDB root. This allows the monitoring user to see every PDB's rows in container-data views, which is required for per-PDB metrics and events.

    ALTER USER c##<YOUR_DB_USERNAME> SET CONTAINER_DATA=ALL CONTAINER=CURRENT;

    ヒント

    Ensure your USER_PASSWORD meets Oracle new user password requirements.

Grant monitoring privileges for multitenant database

Run the following GRANT statements as SYSDBA on the CDB root. These cover instance detection, metrics collection, per-PDB monitoring, and events collection. You can execute them together as a single script or run each statement individually.

GRANT SELECT ON V_$INSTANCE   TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON V_$DATABASE   TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON V_$CONTAINERS TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON V_$DATAFILE   TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON V_$SYSSTAT                    TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON V_$CON_SYSSTAT                TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON V_$SYSMETRIC                  TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON V_$CON_SYSMETRIC              TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON V_$SESSION                    TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON V_$RESOURCE_LIMIT             TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON V_$OSSTAT                     TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON V_$SGAINFO                    TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON V_$ROWCACHE                   TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON V_$PARAMETER                  TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON CDB_TABLESPACE_USAGE_METRICS  TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON CDB_TABLESPACES               TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON DBA_DATA_FILES                TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON DBA_FREE_SPACE                TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON DBA_RECYCLEBIN                TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON V_$SQL            TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON V_$SQL_PLAN       TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON V_$LOCK           TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON V_$SESSION_EVENT  TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON DBA_PROCEDURES    TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON DBA_OBJECTS       TO c##<USER_NAME> CONTAINER=ALL;

Configure NRDOT Collector

  1. Create the configuration file. The filename must be oracle-config.yaml.

    bash
    $
    sudo nano /etc/nrdot-collector/oracle-config.yaml

  2. Add the configuration content below to the oracle-config.yaml file you created in the previous step.

  3. Update the NRDOT collector configuration to use your oracle-config.yaml file.

    bash
    $
    sudo sed -i 's|OTELCOL_OPTIONS="--config=/etc/nrdot-collector/config.yaml"|OTELCOL_OPTIONS="--config=/etc/nrdot-collector/oracle-config.yaml"|' /etc/nrdot-collector/nrdot-collector.conf

  4. Set the following required parameters in the configuration file:

    Parameter

    Description

    <YOUR_DB_HOST>

    Enter your Oracle Database hostname.

    <YOUR_DB_PORT>

    Enter your Oracle Database port.

    <USERNAME>

    Enter your database username.

    <PASSWORD>

    Enter your database password.

    <YOUR_SERVICE_NAME>

    Enter your Oracle service name.

    <YOUR_NEWRELIC_OTLP_ENDPOINT>

    Enter the New Relic OTLP endpoint. For more information, refer to New Relic OTLP endpoints documentation.

    <YOUR_NEWRELIC_LICENSE_KEY>

    Enter your New Relic API key.

  5. Under the Events section, enable these event types to collect their metrics:

    Event

    Description

    db.server.query_sample

    Per-session active query samples capturing current SQL, wait state, and blocking details.

    db.server.top_query

    Top N SQL statements by CPU or elapsed time, including execution stats and query plans.

    db.server.session.wait_sample

    Per-session cumulative wait counts and durations from v$session_event.

  6. Configure the collection settings for each event type:

    Configuration Section

    Parameter

    Default Value

    top_query_collection

    max_query_sample_count

    1000

    top_query_collection

    top_query_count

    200

    top_query_collection

    collection_interval

    60s

    query_sample_collection

    max_rows_per_query

    100

    session_wait_event_collection

    max_rows_per_query

    100

ヒント

For more detailed information about New Relic OTLP endpoint configuration and OpenTelemetry best practices, refer to the OpenTelemetry OTLP documentation.

Restart NRDOT collector

After updating your configuration, restart the NRDOT collector:

bash
$
sudo systemctl restart nrdot-collector.service
$
sudo systemctl status nrdot-collector.service

ヒント

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

(Optional) Multi-receiver configuration

The nrdot-collector binary supports a multi-receiver configuration within a single oracle-config.yaml to monitor multiple Oracle Database instances using unique credentials.

ヒント

  • This configuration allows you to monitor multiple Oracle databases instances simultaneously. Each instance gets its own receiver configuration with unique credentials, while sharing common processors and exporters. Adjust the collection_interval and other parameters based on your monitoring requirements.

  • Restart the NRDOT collector after updating the configuration to apply changes.

(Optional) Set up APM-database correlation

To correlate your application performance with database operations, you can set up database service identification. This feature allows you to see exactly which applications are generating specific database workloads. For more information, refer to set up database service identification to get APM-database correlation in New Relic.

重要

To view database performance data in APM, both entities must be in the same New Relic account. If the entities are in different New Relic accounts, you must have access to both accounts to view the data.

(Optional) Configure secret management

The secret management feature allows you 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. For more information, refer to secret management.

Find and use your data

Once your data is being collected, you can access comprehensive Oracle Database monitoring through New Relic UI.

To find your Oracle Database entity in New Relic:

  1. Go to https://one.newrelic.com > All Capabilities > Databases.
  2. Set the search criteria as instrumentation.provider = opentelemetry.
  3. Select your Oracle Database from the list of entities.

To install the NRDOT Collector for PDB environments, follow these steps:

Installation method

Select the appropriate installation distribution method for your Linux environment:

Configure database user

Create a monitoring user with the necessary privileges for your PDB Oracle Database instance.

  1. Run the following statement as SYS before creating the user or running any grants:
    ALTER SESSION SET CONTAINER = "<YOUR_PDB>";
  2. Run the following statements as SYS inside your target PDB to create a local monitoring user:
    CREATE USER <USER_NAME> IDENTIFIED BY "<YOUR_PASSWORD>";
    GRANT CREATE SESSION TO <USER_NAME>;

Grant monitoring privileges for multitenant database

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

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

Configure NRDOT Collector

Configure the NRDOT Collector with your PDB-specific settings.

  1. Create the configuration file. The filename must be oracle-config.yaml.

    bash
    $
    sudo nano /etc/nrdot-collector/oracle-config.yaml

  2. Add the configuration content below to the oracle-config.yaml file you created in the previous step.

  3. Update the NRDOT collector configuration to use your oracle-config.yaml file.

    bash
    $
    sudo sed -i 's|OTELCOL_OPTIONS="--config=/etc/nrdot-collector/config.yaml"|OTELCOL_OPTIONS="--config=/etc/nrdot-collector/oracle-config.yaml"|' /etc/nrdot-collector/nrdot-collector.conf

  4. Set the following required parameters in the configuration file:

    Parameter

    Description

    <YOUR_DB_HOST>

    Enter your Oracle Database hostname.

    <YOUR_DB_PORT>

    Enter your Oracle Database port.

    <USERNAME>

    Enter your database username.

    <PASSWORD>

    Enter your database password.

    <YOUR_SERVICE_NAME>

    Enter your Oracle service name.

    <YOUR_NEWRELIC_OTLP_ENDPOINT>

    Enter the New Relic OTLP endpoint. For more information, refer to New Relic OTLP endpoints documentation.

    <YOUR_NEWRELIC_LICENSE_KEY>

    Enter your New Relic API key.

  5. Under the Events section, enable these event types to collect their metrics:

    Event

    Description

    db.server.query_sample

    Per-session active query samples capturing current SQL, wait state, and blocking details.

    db.server.top_query

    Top N SQL statements by CPU or elapsed time, including execution stats and query plans.

    db.server.session.wait_sample

    Per-session cumulative wait counts and durations from v$session_event.

  6. Configure the collection settings for each event type:

    Configuration Section

    Parameter

    Value

    top_query_collection

    max_query_sample_count

    1000

    top_query_collection

    top_query_count

    200

    top_query_collection

    collection_interval

    60s

    query_sample_collection

    max_rows_per_query

    100

    session_wait_event_collection

    max_rows_per_query

    100

    ヒント

    For more detailed information about New Relic OTLP endpoint configuration and OpenTelemetry best practices, refer to the OpenTelemetry OTLP documentation.

Restart NRDOT collector

After updating your configuration, restart the NRDOT collector:

bash
$
sudo systemctl restart nrdot-collector.service
$
sudo systemctl status nrdot-collector.service

ヒント

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

(Optional) Multi-receiver configuration

The nrdot-collector binary supports a multi-receiver configuration within a single oracle-config.yaml to monitor multiple Oracle Database instances using unique credentials.

ヒント

  • This configuration allows you to monitor multiple Oracle databases instances simultaneously. Each instance gets its own receiver configuration with unique credentials, while sharing common processors and exporters. Adjust the collection_interval and other parameters based on your monitoring requirements.

  • Restart the NRDOT collector after updating the configuration to apply changes.

(Optional) Set up APM-database correlation

To correlate your application performance with database operations, you can set up database service identification. This feature allows you to see exactly which applications are generating specific database workloads. For more information, refer to set up database service identification to get APM-database correlation in New Relic.

重要

To view database performance data in APM, both entities must be in the same New Relic account. If the entities are in different New Relic accounts, you must have access to both accounts to view the data.

(Optional) Configure secret management

The secret management feature allows you 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. For more information, refer to secret management.

Find and use your data

Once your data is being collected, you can access comprehensive Oracle Database monitoring through New Relic UI.

To find your Oracle Database entity in New Relic:

  1. Go to https://one.newrelic.com > All Capabilities > Databases.
  2. Set the search criteria as instrumentation.provider = opentelemetry.
  3. Select your Oracle Database from the list of entities.

To install the NRDOT Collector in RDS environments, follow these steps:

Installation method

Select the appropriate installation distribution method for your Linux environment:

Configure database user

Create a monitoring user with necessary privileges for your RDS Oracle Database.

  1. Log in to the root database as an administrator:

    CREATE USER <USERNAME> IDENTIFIED BY "<USER_PASSWORD>";

  2. Grant CONNECT privileges to newly created user:

    GRANT CONNECT TO <USERNAME>;

Grant monitoring privileges for RDS database

Execute the following SQL statements to grant monitoring privileges. Replace <USERNAME_IN_UPPERCASE> with your username in uppercase:

EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$SYSMETRIC',      '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$CON_SYSMETRIC',  '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$CONTAINERS',     '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$SESSION',        '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$SESSION_EVENT',  '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$SYSSTAT',        '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$CON_SYSSTAT',    '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$OSSTAT',         '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$SGAINFO',        '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$SQL',            '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$SQLSTATS',       '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$SQL_PLAN',       '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$PARAMETER',      '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$ROWCACHE',       '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$RESOURCE_LIMIT', '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$LOCK',           '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$DATABASE',       '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$INSTANCE',       '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$DATAFILE',       '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('V_$PDBS',           '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('DBA_DATA_FILES',               '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('DBA_FREE_SPACE',               '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('DBA_RECYCLEBIN',               '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('DBA_TABLESPACES',              '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('DBA_TABLESPACE_USAGE_METRICS', '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('DBA_PROCEDURES',               '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('DBA_OBJECTS',                  '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('CDB_TABLESPACE_USAGE_METRICS', '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('CDB_TABLESPACES',              '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
EXEC rdsadmin.rdsadmin_util.grant_sys_object('CDB_SERVICES',                 '<USERNAME_IN_UPPERCASE>', 'SELECT', false);
GRANT CREATE SESSION TO <USERNAME_IN_UPPERCASE>;

Configure NRDOT Collector

  1. Create the configuration file. The filename must be oracle-config.yaml.

    bash
    $
    sudo nano /etc/nrdot-collector/oracle-config.yaml

  2. Add the configuration content below to the oracle-config.yaml file you created in the previous step.

  3. Set the following required parameters in the configuration file:

    Parameter

    Description

    <YOUR_DB_HOST>

    Enter your Oracle Database hostname.

    <YOUR_DB_PORT>

    Enter your Oracle Database port.

    <USERNAME>

    Enter your database username.

    <PASSWORD>

    Enter your database password.

    <YOUR_SERVICE_NAME>

    Enter your PDB service name.

    <YOUR_NEWRELIC_OTLP_ENDPOINT>

    Enter the New Relic OTLP endpoint. For more information, refer to New Relic OTLP endpoints documentation.

    <YOUR_NEWRELIC_LICENSE_KEY>

    Enter your New Relic license key.

  4. Under the Events section, enable these event types to collect their metrics:

    Event

    Description

    db.server.query_sample

    Per-session active query samples capturing current SQL, wait state, and blocking details.

    db.server.top_query

    Top N SQL statements by CPU or elapsed time, including execution stats and query plans.

    db.server.session.wait_sample

    Per-session cumulative wait counts and durations from v$session_event.

  5. Configure the collection settings for each event type:

    Configuration Section

    Parameter

    Value

    top_query_collection

    max_query_sample_count

    1000

    top_query_collection

    top_query_count

    200

    top_query_collection

    collection_interval

    60s

    query_sample_collection

    max_rows_per_query

    100

    session_wait_event_collection

    max_rows_per_query

    100

(Optional) Multi-receiver configuration

The nrdot-collector binary supports a multi-receiver configuration within a single oracle-config.yaml to monitor multiple Oracle Database instances using unique credentials. The sample oracle-config.yaml below demonstrates how to set up multiple receivers for different RDS instances while sharing common processors and exporters.

ヒント

  • This configuration allows you to monitor multiple Oracle RDS instances simultaneously. Each instance gets its own receiver configuration with unique credentials, while sharing common processors and exporters. Adjust the collection_interval and other parameters based on your monitoring requirements.

  • Restart the NRDOT collector after updating the configuration to apply changes.

(Optional) Set up APM-database correlation

To correlate your application performance with database operations, you can set up database service identification. This feature allows you to see exactly which applications are generating specific database workloads. For more information, refer to set up database service identification to get APM-database correlation in New Relic.

重要

To view database performance data in APM, both entities must be in the same New Relic account. If the entities are in different accounts, you must have access to both accounts to view the data.

(Optional) Configure secret management

The secret management feature allows you 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. For more information, refer to secret management.

Find and use your data

Once your data is being collected, you can access comprehensive Oracle Database monitoring through New Relic UI.

To find your Oracle Database entity in New Relic:

  1. Go to https://one.newrelic.com > All Capabilities > Databases.
  2. Set the search criteria as instrumentation.provider = opentelemetry.
  3. Select your Oracle Database from the list of entities.

NRDOT collector supported commands

This section provides a list of common commands for managing the NRDOT Collector service on your system.

Available metrics

The following metrics are available for Oracle Database monitoring with NRDOT. Enable the relevant scrapers in your configuration to collect them.

Troubleshooting

If you encounter issues during setup, use this troubleshooting guide to diagnose and resolve common problems.

What's next

After setting up Oracle Database monitoring with NRDOT:

Copyright © 2026 New Relic株式会社。
採用情報サービス利用規約DMCAポリシープライバシー通知Website Terms特許通知英国現代奴隷法

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.