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 empower your team to monitor your Oracle database performance using New Relic Distribution of OpenTelemetry (NRDOT) with New Relic's 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:

Valid New Relic license key
Supported architecture: Linux with AMD64 and ARM64
Network connectivity to New Relic's OTLP endpoint
Oracle Database 19c or later
On the Oracle database, you've Oracle Instant Client on the machine running the NRDOT collector

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. Select the appropriate configuration based on your database environment and follow the steps.

Sugerencia

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

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:

Installation method

Select the appropriate installation distribution method for your Linux environment:

Importante

It is recommended to install the NRDOT Collector on the same host as your Oracle Database instance to view infra-level metrics for query performance monitoring.

For Debian/Ubuntu system, run:
bash
```
$curl -L -o nrdot-collector-host-linux-amd64-latest https://download.newrelic.com/database-monitoring/nrdot-collector/nrdot-collector-host-linux-amd64-latest.deb
$sudo dpkg -i nrdot-collector-host-linux-amd64-latest
```

For RHEL/CentOS/OEL system, run:

bash

$curl -L -o nrdot-collector-host-linux-amd64-latest https://download.newrelic.com/database-monitoring/nrdot-collector/nrdot-collector-host-linux-amd64-latest.rpm
$sudo rpm -ivh nrdot-collector-host-linux-amd64-latest

For Debian/Ubuntu system, run:

bash

$curl -L -o nrdot-collector-host-linux-arm64-latest https://download.newrelic.com/database-monitoring/nrdot-collector/nrdot-collector-host-linux-arm64-latest.deb
$sudo dpkg -i nrdot-collector-host-linux-arm64-latest

For RHEL/CentOS/OEL system, run:

bash

$curl -L -o nrdot-collector-host-linux-arm64-latest https://download.newrelic.com/database-monitoring/nrdot-collector/nrdot-collector-host-linux-arm64-latest.rpm
$sudo rpm -ivh nrdot-collector-host-linux-arm64-latest

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.

Log in to the root database as an administrator:
```
CREATE USER c##<YOUR_DB_USERNAME> IDENTIFIED BY "<USER_PASSWORD>";
```
Sugerencia
Ensure that your USER_PASSWORD meets with Oracle new user's password requirements.

Grant monitoring privileges for multitenant database

Execute the following SQL statements to grant monitoring privileges. Use the correct username format with C## prefix for multitenant database:

ALTER USER c##<YOUR_DB_USERNAME> SET CONTAINER_DATA=ALL CONTAINER=CURRENT;
GRANT CREATE SESSION TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SET CONTAINER TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT CONNECT TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.V_$SESSION TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.V_$SYSSTAT TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.V_$SESSTAT TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.V_$STATNAME TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.V_$SYSTEM_EVENT TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.V_$SHARED_SERVER TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.V_$DISPATCHER TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.V_$CIRCUIT TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.V_$RESOURCE_LIMIT TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.V_$LOCK TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.V_$DATABASE TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.V_$PARAMETER TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.V_$SQLAREA TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.V_$SQL TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.V_$SQL_PLAN TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.V_$PDBS TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$INSTANCE TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$SGA TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$SESSTAT TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$STATNAME TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$SYSSTAT TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$SQLAREA TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$LIBRARYCACHE TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$ROWCACHE TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$PGASTAT TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$CONTAINERS TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$PDBS TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$CON_SYSMETRIC TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$SYSMETRIC TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$FILESTAT TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$SYSTEM_EVENT TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$ACTIVE_SERVICES TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$SESSION TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$SESSION_WAIT TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$ROLLSTAT TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON DBA_OBJECTS TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON DBA_TABLESPACES TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON DBA_TABLESPACE_USAGE_METRICS TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON DBA_DATA_FILES TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON DBA_USERS TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON CDB_SERVICES TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON CDB_DATA_FILES TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON CDB_TABLESPACE_USAGE_METRICS TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON CDB_USERS TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON CDB_PDBS TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON ALL_USERS TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON ALL_VIEWS TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;
GRANT SELECT ON GLOBAL_NAME TO c##<YOUR_DB_USERNAME> CONTAINER=ALL;

Configure NRDOT Collector

Edit your config.yaml file available at /etc/nrdot-collector-host/, then add the following code snippet:

Importante

If you're an existing NRDOT Collector user, ensure to merge the above configuration with your existing config.yaml file. This includes adding the new receivers, processors, and exporters for Oracle Database monitoring while retaining your current configurations.

extensions:
  health_check:
receivers:
  otlp:
    protocols:
      grpc:
      http:
  hostmetrics:
    collection_interval: 60s
    scrapers:
      cpu:
        metrics:
          system.cpu.time:
            enabled: false
          system.cpu.utilization:
            enabled: true
      load:
      memory:
        metrics:
          system.memory.utilization:
            enabled: true
      paging:
        metrics:
          system.paging.utilization:
            enabled: false
          system.paging.faults:
            enabled: false
      filesystem:
        metrics:
          system.filesystem.utilization:
            enabled: true
      disk:
        metrics:
          system.disk.merged:
            enabled: false
          system.disk.pending_operations:
            enabled: false
          system.disk.weighted_io_time:
            enabled: false
      network:
        metrics:
          system.network.connections:
            enabled: false
      # Uncomment to enable process metrics, which can be noisy but valuable.
      # processes:
      # process:
      #   metrics:
      #     process.cpu.utilization:
      #       enabled: true
      #     process.cpu.time:
      #       enabled: false
  filelog:
    include:
      - /var/log/alternatives.log
      - /var/log/cloud-init.log
      - /var/log/auth.log
      - /var/log/dpkg.log
      - /var/log/syslog
      - /var/log/messages
      - /var/log/secure
      - /var/log/yum.log
  newrelicoracledb/cdb:
    endpoint: "<YOUR_DB_HOST>:<YOUR_DB_PORT>"
    username: "<USERNAME>"
    password: "<PASSWORD>"
    service: "<YOUR_CDB_SERVICE_NAME>"
    collection_interval: 30s
    timeout: 30s
    # enable_tablespace_scraper: true
    # enable_core_scraper: true
    # enable_system_scraper: true
    # enable_connection_scraper: true
    # enable_container_scraper: true
    # enable_database_info_scraper: true
  newrelicoracledb/pdb:
    endpoint: "<YOUR_DB_HOST>:<YOUR_DB_PORT>"
    username: "<USERNAME>"
    password: "<PASSWORD>"
    service: "<YOUR_CDB_SERVICE_NAME>"
    collection_interval: 30s
    timeout: 30s
    pdb_services: ["ALL"]
    # query_monitoring_response_time_threshold: 500
    # query_monitoring_count_threshold: 30
    # enable_query_monitoring: true
    # enable_pdb_scraper: true

processors:
  metricstransform:
    transforms:
      - include: system.cpu.utilization
        action: update
        operations:
          - action: aggregate_labels
            label_set: [ state ]
            aggregation_type: mean
      - include: system.paging.operations
        action: update
        operations:
          - action: aggregate_labels
            label_set: [ direction ]
            aggregation_type: sum
  filter/exclude_cpu_utilization:
    metrics:
      datapoint:
        - 'metric.name == "system.cpu.utilization" and attributes["state"] == "interrupt"'
        - 'metric.name == "system.cpu.utilization" and attributes["state"] == "nice"'
        - 'metric.name == "system.cpu.utilization" and attributes["state"] == "softirq"'
  filter/exclude_memory_utilization:
    metrics:
      datapoint:
        - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_unreclaimable"'
        - 'metric.name == "system.memory.utilization" and attributes["state"] == "inactive"'
        - 'metric.name == "system.memory.utilization" and attributes["state"] == "cached"'
        - 'metric.name == "system.memory.utilization" and attributes["state"] == "buffered"'
        - 'metric.name == "system.memory.utilization" and attributes["state"] == "slab_reclaimable"'
  filter/exclude_memory_usage:
    metrics:
      datapoint:
        - 'metric.name == "system.memory.usage" and attributes["state"] == "slab_unreclaimable"'
        - 'metric.name == "system.memory.usage" and attributes["state"] == "inactive"'
  filter/exclude_filesystem_utilization:
    metrics:
      datapoint:
        - 'metric.name == "system.filesystem.utilization" and attributes["type"] == "squashfs"'
  filter/exclude_filesystem_usage:
    metrics:
      datapoint:
        - 'metric.name == "system.filesystem.usage" and attributes["type"] == "squashfs"'
        - 'metric.name == "system.filesystem.usage" and attributes["state"] == "reserved"'
  filter/exclude_filesystem_inodes_usage:
    metrics:
      datapoint:
        - 'metric.name == "system.filesystem.inodes.usage" and attributes["type"] == "squashfs"'
        - 'metric.name == "system.filesystem.inodes.usage" and attributes["state"] == "reserved"'
  filter/exclude_system_disk:
    metrics:
      datapoint:
        - 'metric.name == "system.disk.operations" and IsMatch(attributes["device"], "^loop.*") == true'
        - 'metric.name == "system.disk.merged" and IsMatch(attributes["device"], "^loop.*") == true'
        - 'metric.name == "system.disk.io" and IsMatch(attributes["device"], "^loop.*") == true'
        - 'metric.name == "system.disk.io_time" and IsMatch(attributes["device"], "^loop.*") == true'
        - 'metric.name == "system.disk.operation_time" and IsMatch(attributes["device"], "^loop.*") == true'
  filter/exclude_system_paging:
    metrics:
      datapoint:
        - 'metric.name == "system.paging.usage" and attributes["state"] == "cached"'
        - 'metric.name == "system.paging.operations" and attributes["type"] == "cached"'
  filter/exclude_network:
    metrics:
      datapoint:
        - 'IsMatch(metric.name, "^system.network.*") == true and attributes["device"] == "lo"'
  attributes/exclude_system_paging:
    include:
      match_type: strict
      metric_names:
        - system.paging.operations
    actions:
      - key: type
        action: delete
  transform/clear_metadata:
    metric_statements:
      - context: metric
        statements:
          - set(metric.description, "")
          - set(metric.unit, "")
  filter/exec_plan_and_query_details_include:
    metrics:
      include:
        match_type: strict
        metric_names:
          - newrelicoracledb.execution_plan
          - newrelicoracledb.slow_queries.query_details
  filter/exec_plan_and_query_details_exclude:
    metrics:
      exclude:
        match_type: strict
        metric_names:
          - newrelicoracledb.execution_plan
          - newrelicoracledb.slow_queries.query_details
  cumulativetodelta/oracle:
    include:
      match_type: strict
      metrics:
        - newrelicoracledb.connection.bytes_received
        - newrelicoracledb.connection.bytes_sent
        - newrelicoracledb.connection.execute_count
        - newrelicoracledb.connection.logons_cumulative
        - newrelicoracledb.connection.parse_count_hard
        - newrelicoracledb.connection.parse_count_total
        - newrelicoracledb.connection.sqlnet_roundtrips
        - newrelicoracledb.connection.user_commits
        - newrelicoracledb.connection.user_rollbacks
  transform/host:
    metric_statements:
      - context: metric
        statements:
          - set(metric.description, "")
          - set(metric.unit, "")
  transform:
    trace_statements:
      - context: span
        statements:
          - truncate_all(span.attributes, 4095)
          - truncate_all(resource.attributes, 4095)
    log_statements:
      - context: log
        statements:
          - truncate_all(log.attributes, 4095)
          - truncate_all(resource.attributes, 4095)
  memory_limiter:
    check_interval: 1s
    limit_mib: ${env:NEW_RELIC_MEMORY_LIMIT_MIB:-100}
  batch:
  resourcedetection:
    detectors: ["system"]
    system:
      hostname_sources: ["os"]
      resource_attributes:
        host.id:
          enabled: true
  resourcedetection/db_safe:
    detectors: ["system"]
    override: false
    system:
      hostname_sources: ["os"]
      resource_attributes:
        host.id:
          enabled: true
  resourcedetection/cloud:
    detectors: ["gcp", "ec2", "azure"]
    timeout: 2s
    override: true
  resourcedetection/env:
    detectors: ["env"]
    timeout: 2s
    override: true

connectors:
  metricsaslogs:
    include_resource_attributes: true
    include_scope_info: true

exporters:
  otlp:
    endpoint: "<YOUR_NEWRELIC_OTLP_ENDPOINT>"
    headers:
      api-key: "<YOUR_NEWRELIC_API_KEY>"
    compression: gzip

service:
  pipelines:
    metrics/host:
      receivers: [hostmetrics]
      processors:
        - memory_limiter
        - metricstransform
        - filter/exclude_cpu_utilization
        - filter/exclude_memory_utilization
        - filter/exclude_memory_usage
        - filter/exclude_filesystem_utilization
        - filter/exclude_filesystem_usage
        - filter/exclude_filesystem_inodes_usage
        - filter/exclude_system_disk
        - filter/exclude_network
        - attributes/exclude_system_paging
        - transform/host
        - resourcedetection
        - resourcedetection/cloud
        - resourcedetection/env
        - cumulativetodelta/oracle
        - batch
      exporters: [otlp]
    traces:
      receivers: [otlp]
      processors: [memory_limiter, transform, resourcedetection, resourcedetection/cloud, resourcedetection/env, batch]
      exporters: [otlp]
    metrics:
      receivers: [otlp]
      processors: [memory_limiter, transform, resourcedetection, resourcedetection/cloud, resourcedetection/env, batch]
      exporters: [otlp]
    logs:
      receivers: [otlp]
      processors: [memory_limiter, transform, resourcedetection, resourcedetection/cloud, resourcedetection/env, batch]
      exporters: [otlp]
    metrics/oracledb:
      receivers: [newrelicoracledb/cdb, newrelicoracledb/pdb]
      processors: [memory_limiter, resourcedetection/db_safe, batch, transform/clear_metadata, filter/exec_plan_and_query_details_exclude]
      exporters: [otlp]
    metrics/exec_plan_and_query_details_to_logs:
      receivers: [newrelicoracledb/cdb, newrelicoracledb/pdb]
      processors: [filter/exec_plan_and_query_details_include]
      exporters: [metricsaslogs]
    logs/oracledb:
      receivers: [metricsaslogs]
      processors: [memory_limiter, resourcedetection/db_safe, batch]
      exporters: [otlp]
  extensions: [health_check]

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_CDB_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_API_KEY>`	Enter your New Relic API key.
`pdb_services`	Choose the PDB services to monitor from the following options: Empty or nil: Collect only specified service data `["ALL"]`: Collect all PDB services (excluding CDB) `["pdb1", "pdb2"]`: Collect only specified PDB services
`enable_query_monitoring`	Obtain query monitoring metrics such as, slow, active, wait, blocking sessions, and execution plan. The default value is set to `false`
`query_monitoring_response_time_threshold`	Set the threshold for query response time (in ms). Captures the queries which crosses to this threshold. The default value is set to 500ms.
`query_monitoring_count_threshold`	The number of records for each query performance metrics. The default value is set to 30

Sugerencia

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-host
$sudo systemctl status nrdot-collector-host

Sugerencia

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

(Optional) Multi-receiver configuration

The nrdot-collector-host binary supports a multi-receiver configuration within a single config.yaml to monitor multiple Oracle database instances using unique credentials. The sameple config.yaml below demonstrates how to set up multiple receivers for different on-host (multitenant) instances while sharing common processors and exporters.

receivers:
  newrelicoracledb/cdb1:
    endpoint: "<YOUR_DB_HOST>:<YOUR_DB_PORT>"
    username: "<USERNAME>"
    password: "<PASSWORD>"
    service: "<YOUR_CDB1_SERVICE_NAME>"
    collection_interval: 30s
    timeout: 30s
    # enable_tablespace_scraper: true
    # enable_core_scraper: true
    # enable_system_scraper: true
    # enable_connection_scraper: true
    # enable_container_scraper: true
    # enable_database_info_scraper: true

  # First CDB's PDB configuration
  newrelicoracledb/pdb1:
    endpoint: "<YOUR_DB_HOST>:<YOUR_DB_PORT>"
    username: "<USERNAME>"
    password: "<PASSWORD>"
    service: "<YOUR_CDB2_SERVICE_NAME>"
    collection_interval: 30s
    timeout: 30s
    pdb_services: ["ALL"]
    # query_monitoring_response_time_threshold: 500
    # query_monitoring_count_threshold: 30
    # enable_query_monitoring: true
    # enable_pdb_scraper: true

  # Second CDB configuration
  newrelicoracledb/cdb2:
    endpoint: "<YOUR_DB_HOST>:<YOUR_DB_PORT>"
    username: "<USERNAME>"
    password: "<PASSWORD>"
    service: "<YOUR_CDB2_SERVICE_NAME>"
    collection_interval: 30s
    timeout: 30s
    # enable_tablespace_scraper: true
    # enable_core_scraper: true
    # enable_system_scraper: true
    # enable_connection_scraper: true
    # enable_container_scraper: true
    # enable_database_info_scraper: true

  # Second CDB's PDB configuration
  newrelicoracledb/pdb2:
    endpoint: "<YOUR_DB_HOST>:<YOUR_DB_PORT>"
    username: "<USERNAME>"
    password: "<PASSWORD>"
    service: "<YOUR_CDB2_SERVICE_NAME>"
    collection_interval: 30s
    timeout: 30s
    pdb_services: ["ALL"]
    # query_monitoring_response_time_threshold: 500
    # query_monitoring_count_threshold: 30
    # enable_query_monitoring: true
    # enable_pdb_scraper: true

processors:
  memory_limiter/oracle:
    check_interval: 1s
    limit_mib: ${env:NEW_RELIC_MEMORY_LIMIT_MIB:-100}

  cumulativetodelta/oracle:
    include:
      match_type: strict
      metrics:
        - newrelicoracledb.connection.bytes_received
        - newrelicoracledb.connection.bytes_sent
        - newrelicoracledb.connection.execute_count
        - newrelicoracledb.connection.logons_cumulative
        - newrelicoracledb.connection.parse_count_hard
        - newrelicoracledb.connection.parse_count_total
        - newrelicoracledb.connection.sqlnet_roundtrips
        - newrelicoracledb.connection.user_commits
        - newrelicoracledb.connection.user_rollbacks

  transform/oracle_clear_metadata:
    metric_statements:
      - context: metric
        statements:
          - set(metric.description, "")
          - set(metric.unit, "")
    log_statements:
      - context: log
        statements:
          - set(body, "")

  filter/exec_plan_and_query_details_include:
    metrics:
      include:
        match_type: strict
        metric_names:
          - newrelicoracledb.execution_plan
          - newrelicoracledb.slow_queries.query_details

  filter/exec_plan_and_query_details_exclude:
    metrics:
      exclude:
        match_type: strict
        metric_names:
          - newrelicoracledb.execution_plan
          - newrelicoracledb.slow_queries.query_details

  resourcedetection/oracle_db_safe:
    detectors: ["system"]
    override: false
    system:
      hostname_sources: ["os"]
      resource_attributes:
        host.id:
          enabled: true

connectors:
  metricsaslogs/oracle:
    include_resource_attributes: true
    include_scope_info: true

service:
  pipelines:
    metrics/oracledb:
      receivers: [newrelicoracledb/cdb1, newrelicoracledb/pdb1, newrelicoracledb/cdb2, newrelicoracledb/pdb2]
      processors: [memory_limiter/oracle, cumulativetodelta/oracle, transform/oracle_clear_metadata, filter/exec_plan_and_query_details_exclude, resourcedetection/oracle_db_safe]
      exporters: [otlp]

    metrics/oracle_query_to_logs:
      receivers: [newrelicoracledb/cdb1, newrelicoracledb/pdb1, newrelicoracledb/cdb2, newrelicoracledb/pdb2]
      processors: [memory_limiter/oracle, filter/exec_plan_and_query_details_include]
      exporters: [metricsaslogs/oracle]

    logs/oracledb:
      receivers: [metricsaslogs/oracle]
      processors: [memory_limiter/oracle, transform/oracle_clear_metadata, resourcedetection/oracle_db_safe]
      exporters: [otlp]

Sugerencia

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.

Importante

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's UI.

To find your Oracle database entity in New Relic:

Go to https://one.newrelic.com > All Capabilities > Databases.
Set the search criteria as instrumentation.provider = opentelemetry.
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:

For Debian/Ubuntu system, run:

bash

$curl -L -o nrdot-collector-host-linux-amd64-latest https://download.newrelic.com/database-monitoring/nrdot-collector/nrdot-collector-host-linux-amd64-latest.deb
$sudo dpkg -i nrdot-collector-host-linux-amd64-latest

For RHEL/CentOS/OEL system, run:

bash

$curl -L -o nrdot-collector-host-linux-amd64-latest https://download.newrelic.com/database-monitoring/nrdot-collector/nrdot-collector-host-linux-amd64-latest.rpm
$sudo rpm -ivh nrdot-collector-host-linux-amd64-latest

For Debian/Ubuntu system, run:

bash

$curl -L -o nrdot-collector-host-linux-arm64-latest https://download.newrelic.com/database-monitoring/nrdot-collector/nrdot-collector-host-linux-arm64-latest.deb
$sudo dpkg -i nrdot-collector-host-linux-arm64-latest

For RHEL/CentOS/OEL system, run:

bash

$curl -L -o nrdot-collector-host-linux-arm64-latest https://download.newrelic.com/database-monitoring/nrdot-collector/nrdot-collector-host-linux-arm64-latest.rpm
$sudo rpm -ivh nrdot-collector-host-linux-arm64-latest

Configure database user

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

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

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:

SET SERVEROUTPUT ON;
BEGIN
    FOR r IN (SELECT column_value as view_name FROM table(sys.odcivarchar2list(
                'V_$SESSION', 'V_$SYSSTAT', 'V_$SESSTAT', 'V_$STATNAME', 
                'V_$SYSTEM_EVENT', 'V_$SHARED_SERVER', 'V_$DISPATCHER', 
                'V_$RESOURCE_LIMIT', 'V_$LOCK', 'V_$DATABASE', 
                'V_$PARAMETER', 'V_$SQLAREA', 'V_$SQL', 'V_$SQL_PLAN', 
                'V_$PDBS', 'GV_$INSTANCE', 'GV_$SGA', 'GV_$SESSTAT', 
                'GV_$STATNAME', 'GV_$SYSSTAT', 'GV_$SQLAREA', 
                'GV_$LIBRARYCACHE', 'GV_$ROWCACHE', 'GV_$PGASTAT', 
                'GV_$CONTAINERS', 'GV_$PDBS', 'GV_$CON_SYSMETRIC', 
                'GV_$SYSMETRIC', 'GV_$FILESTAT', 'GV_$SYSTEM_EVENT', 
                'GV_$ACTIVE_SERVICES', 'GV_$SESSION', 'GV_$SESSION_WAIT', 
                'GV_$ROLLSTAT', 'DBA_OBJECTS', 'DBA_TABLESPACES', 
                'DBA_TABLESPACE_USAGE_METRICS', 'DBA_DATA_FILES', 'DBA_USERS', 
                'CDB_SERVICES', 'CDB_DATA_FILES', 'CDB_TABLESPACE_USAGE_METRICS', 
                'CDB_USERS', 'CDB_PDBS', 'ALL_USERS', 'ALL_VIEWS', 'GLOBAL_NAME'
            ))) LOOP
      BEGIN
          rdsadmin.rdsadmin_util.grant_sys_object(
            p_obj_name  => r.view_name, 
            p_grantee   => '<USERNAME_IN_UPPERCASE>', 
            p_privilege => 'SELECT'
          );
      EXCEPTION 
          WHEN OTHERS THEN 
            DBMS_OUTPUT.PUT_LINE('FAILED: ' || r.view_name || ' | Error: ' || SQLERRM);
      END;
    END LOOP;
END;
/

Configure NRDOT Collector

Edit your config.yaml file available at /etc/nrdot-collector-host/, then add the following code snippet:

Importante

receivers:
  newrelicoracledb/pdb:
    endpoint: "<YOUR_DB_HOST>:<YOUR_DB_PORT>"
    username: "<USERNAME>"
    password: "<PASSWORD>"
    service: "<PDB_NAME>"
    collection_interval: 30s
    timeout: 30s
    # pdb_services: ['PDB1','PDB2'] #for multiple pdbs
    # query_monitoring_response_time_threshold: 500
    # query_monitoring_count_threshold: 30
    # enable_query_monitoring: true
    # enable_pdb_scraper: true
    # enable_tablespace_scraper: true
    # enable_core_scraper: true
    # enable_system_scraper: true
    # enable_connection_scraper: true
    # enable_container_scraper: true
    # enable_database_info_scraper: true
processors:
  transform/clear_metadata:
    metric_statements:
      - context: metric
        statements:
          - set(metric.description, "")
          - set(metric.unit, "")
    log_statements:
      - context: log
        statements:
          - set(log.body, "")
  filter/exec_plan_and_query_details_include:
    metrics:
      include:
        match_type: strict
        metric_names:
          - newrelicoracledb.execution_plan
          - newrelicoracledb.slow_queries.query_details
  filter/exec_plan_and_query_details_exclude:
    metrics:
      exclude:
        match_type: strict
        metric_names:
          - newrelicoracledb.execution_plan
          - newrelicoracledb.slow_queries.query_details
  cumulativetodelta:
    include:
      match_type: strict
      metrics:
        - newrelicoracledb.connection.bytes_received
        - newrelicoracledb.connection.bytes_sent
        - newrelicoracledb.connection.execute_count
        - newrelicoracledb.connection.logons_cumulative
        - newrelicoracledb.connection.parse_count_hard
        - newrelicoracledb.connection.parse_count_total
        - newrelicoracledb.connection.sqlnet_roundtrips
        - newrelicoracledb.connection.user_commits
        - newrelicoracledb.connection.user_rollbacks        
connectors:
  metricsaslogs:
    include_resource_attributes: true
    include_scope_info: true 
exporters:
  otlp:
    endpoint: "<YOUR_NEWRELIC_OTLP_ENDPOINT>" 
    headers:
      api-key: "<YOUR_NEWRELIC_API_KEY>"
    compression: gzip
service:
  pipelines:
    metrics:
      receivers: [newrelicoracledb/pdb]
      processors: [transform/clear_metadata, filter/exec_plan_and_query_details_exclude, cumulativetodelta]
      exporters: [otlp]
    metrics/exec_plan_and_query_details_to_logs:
      receivers: [newrelicoracledb/pdb]
      processors: [filter/exec_plan_and_query_details_include]
      exporters: [metricsaslogs]
    logs/newrelicoracledb:
      receivers: [metricsaslogs]
      processors: [transform/clear_metadata]
      exporters: [otlp]

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.
`<PDB_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_API_KEY>`	Enter your New Relic API key.
`pdb_services`	Choose the PDB services to monitor from the following options: Empty or nil: Collect only specified service data `["pdb1", "pdb2"]`: Collect only specified PDB services
`enable_query_monitoring`	Obtain query monitoring metrics such as, slow, active, wait, blocking sessions, and execution plan. The default value is set to `false`
`query_monitoring_response_time_threshold`	Set the threshold for query response time (in ms). Captures the queries which crosses to this threshold. The default value is set to 500ms.
`query_monitoring_count_threshold`	The number of records for each query performance metrics. The default value is set to 30

Restart NRDOT collector

After updating your configuration, restart the NRDOT collector:

bash

$sudo systemctl restart nrdot-collector-host
$sudo systemctl status nrdot-collector-host

Sugerencia

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

(Optional) Multi-receiver configuration

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

receivers:
  # First RDS Instance
  newrelicoracledb/pdb/rds1:
    endpoint: "<YOUR_DB_HOST_1>:<YOUR_DB_PORT_1>"
    username: "<USERNAME_1>"
    password: "<PASSWORD_1>"
    service: "<PDB_NAME_1>"
    collection_interval: 30s
    timeout: 30s
    # query_monitoring_response_time_threshold: 500
    # query_monitoring_count_threshold: 30
    # enable_query_monitoring: true

  # Second RDS Instance
  newrelicoracledb/pdb/rds2:
    endpoint: "<YOUR_DB_HOST_2>:<YOUR_DB_PORT_2>"
    username: "<USERNAME_2>"
    password: "<PASSWORD_2>"
    service: "<PDB_NAME_2>"
    collection_interval: 30s
    timeout: 30s
    # query_monitoring_response_time_threshold: 500
    # query_monitoring_count_threshold: 30
    # enable_query_monitoring: true

processors:
  transform/clear_metadata:
    metric_statements:
      - context: metric
        statements:
          - set(metric.description, "")
          - set(metric.unit, "")
    log_statements:
      - context: log
        statements:
          - set(log.body, "")

  filter/exec_plan_and_query_details_include:
    metrics:
      include:
        match_type: strict
        metric_names:
          - newrelicoracledb.execution_plan
          - newrelicoracledb.slow_queries.query_details

  filter/exec_plan_and_query_details_exclude:
    metrics:
      exclude:
        match_type: strict
        metric_names:
          - newrelicoracledb.execution_plan
          - newrelicoracledb.slow_queries.query_details

connectors:
  metricsaslogs:
    include_resource_attributes: true
    include_scope_info: true

exporters:
  otlp:
    endpoint: "<YOUR_NEWRELIC_OTLP_ENDPOINT>"
    headers:
      api-key: "<YOUR_NEWRELIC_API_KEY>"
    compression: gzip

service:
  pipelines:
    # Separate metrics pipelines to apply unique resource names
    metrics/rds1:
      receivers: [newrelicoracledb/pdb/rds1]
      processors: [transform/clear_metadata, filter/exec_plan_and_query_details_exclude]
      exporters: [otlp]
    
    metrics/rds2:
      receivers: [newrelicoracledb/pdb/rds2]
      processors: [transform/clear_metadata, filter/exec_plan_and_query_details_exclude]
      exporters: [otlp]

    # Combined logs pipeline for execution plans and query details
    metrics/exec_plan_and_query_details_to_logs:
      receivers: [newrelicoracledb/pdb/rds1, newrelicoracledb/pdb/rds2]
      processors: [filter/exec_plan_and_query_details_include]
      exporters: [metricsaslogs]

    logs/newrelicoracledb:
      receivers: [metricsaslogs]
      processors: [transform/clear_metadata]
      exporters: [otlp]

Sugerencia

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

Importante

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

Find and use your data

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

To find your Oracle database entity in New Relic:

Go to https://one.newrelic.com > All Capabilities > Databases.
Set the search criteria as instrumentation.provider = opentelemetry.
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.

To validate installation status:
- For Debian/Ubuntu-based distributions:
  bash
```
$dpkg -l | grep nrdot-collector-host
```
- For RHEL/CentOS-based distributions:
  bash
```
$rpm -q nrdot-collector-host || ls /etc/nrdot-collector-host
```
To restart NRDOT Collector:

bash

$sudo systemctl restart nrdot-collector-host

To check NRDOT Collector status:

bash

$sudo systemctl status nrdot-collector-host

To view NRDOT Collector logs:

bash

$sudo journalctl -u nrdot-collector-host -n 50 --no-pager

To delete NRDOT Collector service:
- For Debian/Ubuntu-based distributions:
  bash
```
$sudo apt purge nrdot-collector-host
```
- For RHEL/CentOS-based distributions:
  bash
```
$sudo yum erase nrdot-collector-host
```
To clean up configuration files:

bash

$# Clean up configuration and reload systemd
$sudo rm -rf /etc/nrdot-collector-host/
$sudo systemctl daemon-reload

Available metrics

Monitor your Oracle database performance with metrics organized by configuration flags. Default metrics are collected automatically for New Relic UI functionality. You can also use provided additional metrics to gain advanced and deeper insights when you enable specific scrapers.

Default metrics

These metrics are essential for New Relic's Oracle database monitoring features and are collected automatically regardless of your configuration.

Metric name	Description
`newrelicoracledb.child_cursors.details`	Details about child cursors in the Oracle database
`newrelicoracledb.child_cursors.elapsed_time`	Elapsed time for child cursor operations
`newrelicoracledb.connection.active_sessions`	Number of active Oracle database sessions
`newrelicoracledb.connection.execute_count`	Number of SQL executions
`newrelicoracledb.connection.inactive_sessions`	Number of inactive Oracle database sessions
`newrelicoracledb.connection.total_sessions`	Total number of Oracle database sessions
`newrelicoracledb.memory.pga_max_size_bytes`	Global memory bound for PGA in bytes
`newrelicoracledb.sessions.count`	Total number of active Oracle database sessions
`newrelicoracledb.sga_hit_ratio`	SGA hit ratio (buffer cache efficiency)
`newrelicoracledb.sga_shared_pool_library_cache_hit_ratio`	Library cache hit ratio for SQL AREA namespace
`newrelicoracledb.slow_queries.execution_count`	Count of slow query executions
`newrelicoracledb.slow_queries.interval_avg_cpu_time`	Average CPU time for slow queries in the interval
`newrelicoracledb.slow_queries.interval_avg_elapsed_time`	Average elapsed time for slow queries in the interval
`newrelicoracledb.slow_queries.interval_buffer_gets`	Buffer gets for slow queries in the interval
`newrelicoracledb.slow_queries.interval_cpu_time`	CPU time for slow queries in the interval
`newrelicoracledb.slow_queries.interval_elapsed_time`	Elapsed time for slow queries in the interval
`newrelicoracledb.slow_queries.interval_execution_count`	Execution count for slow queries in the interval
`newrelicoracledb.slow_queries.interval_rows_processed`	Rows processed for slow queries in the interval
`newrelicoracledb.slow_queries.interval_wait_time`	Wait time for slow queries in the interval
`newrelicoracledb.slow_queries.query_details`	Detailed information about slow queries
`newrelicoracledb.slow_queries.total_cpu_time`	Total CPU time for slow queries
`newrelicoracledb.slow_queries.total_elapsed_time`	Total elapsed time for slow queries
`newrelicoracledb.slow_queries.total_rows_examined`	Total rows examined by slow queries
`newrelicoracledb.slow_queries.total_rows_returned`	Total rows returned by slow queries
`newrelicoracledb.slow_queries.total_wait_time`	Total wait time for slow queries
`newrelicoracledb.system.average_active_sessions`	Average concurrent active sessions
`newrelicoracledb.system.buffer_cache_hit_ratio`	Buffer Cache Hit Ratio
`newrelicoracledb.system.database_cpu_time_ratio`	Database CPU Time Ratio
`newrelicoracledb.system.enqueue_waits_per_second`	Enqueue contention rate
`newrelicoracledb.system.executions_per_second`	SQL execution rate
`newrelicoracledb.system.hard_parse_count_per_second`	Hard parse rate
`newrelicoracledb.system.host_cpu_utilization`	Host CPU usage percentage
`newrelicoracledb.system.io_megabytes_per_second`	I/O throughput in MB/s
`newrelicoracledb.system.physical_reads_per_second`	Physical read rate
`newrelicoracledb.system.physical_writes_per_second`	Physical write rate
`newrelicoracledb.system.redo_generated_bytes_per_second`	Redo generation rate
`newrelicoracledb.system.response_time_per_transaction`	Response time per transaction
`newrelicoracledb.system.transactions_per_second`	Transaction rate per second
`newrelicoracledb.wait_events.current_wait_time_ms`	Current wait time for database events in milliseconds

Additional metrics

Enable these additional metrics as required for deeper insights into your Oracle database performance and health.

Enable enable_tablespace_scraper: true to collect these metrics:

Metric name	Description
`newrelicoracledb.tablespace.space_consumed_bytes`	Used space in bytes per tablespace
`newrelicoracledb.tablespace.space_reserved_bytes`	Total allocated space in bytes per tablespace
`newrelicoracledb.tablespace.space_used_percentage`	Usage percentage per tablespace
`newrelicoracledb.tablespace.is_offline`	Tablespace offline status (1=offline, 0=online)
`newrelicoracledb.tablespace.global_name`	Global database name tagged by tablespace
`newrelicoracledb.tablespace.db_id`	Database ID tagged by tablespace
`newrelicoracledb.tablespace.offline_cdb_datafiles`	Count of offline datafiles in CDB tablespaces
`newrelicoracledb.tablespace.offline_pdb_datafiles`	Count of offline datafiles in PDB tablespaces
`newrelicoracledb.tablespace.pdb_non_write_mode`	Count of PDB tablespaces not in write mode

Enable enable_core_scraper: true to collect these metrics:

Metric name	Description
`newrelicoracledb.memory.pga_in_use_bytes`	Total PGA memory currently in use in bytes
`newrelicoracledb.memory.pga_allocated_bytes`	Total PGA memory allocated in bytes
`newrelicoracledb.memory.pga_freeable_bytes`	Total freeable PGA memory in bytes
`newrelicoracledb.memory.sga_uga_total_bytes`	Total SGA UGA memory in bytes
`newrelicoracledb.memory.sga_shared_pool_library_cache_sharable_bytes`	SGA shared pool library cache sharable memory in bytes
`newrelicoracledb.memory.sga_shared_pool_library_cache_user_bytes`	SGA shared pool library cache shareable memory per user in bytes
`newrelicoracledb.sga_shared_pool_library_cache_reload_ratio`	Library cache reload ratio (reloads/pins)
`newrelicoracledb.sga_shared_pool_dict_cache_miss_ratio`	Dictionary cache miss ratio (getmisses/gets)
`newrelicoracledb.sga_log_buffer_space_waits`	Number of sessions waiting for log buffer space
`newrelicoracledb.sga_log_allocation_retries_ratio`	Log allocation retries ratio
`newrelicoracledb.sga_fixed_size_bytes`	SGA fixed size memory in bytes
`newrelicoracledb.sga_redo_buffers_bytes`	SGA redo buffers memory in bytes
`newrelicoracledb.disk.reads`	Number of physical disk reads
`newrelicoracledb.disk.writes`	Number of physical disk writes
`newrelicoracledb.disk.blocks_read`	Number of physical blocks read from disk
`newrelicoracledb.disk.blocks_written`	Number of physical blocks written to disk
`newrelicoracledb.disk.read_time_milliseconds`	Time spent reading from disk in milliseconds
`newrelicoracledb.disk.write_time_milliseconds`	Time spent writing to disk in milliseconds
`newrelicoracledb.global_name`	Oracle database global name information
`newrelicoracledb.db_id`	Oracle database ID information
`newrelicoracledb.locked_accounts`	Count of locked user accounts in the database
`newrelicoracledb.long_running_queries`	Number of long running queries
`newrelicoracledb.sga_log_buffer_redo_allocation_retries`	Number of redo buffer allocation retries
`newrelicoracledb.sga_log_buffer_redo_entries`	Number of redo entries
`newrelicoracledb.sorts_memory`	Number of sorts performed in memory
`newrelicoracledb.sorts_disk`	Number of sorts performed on disk
`newrelicoracledb.rollback_segments_gets`	Number of gets on rollback segments
`newrelicoracledb.rollback_segments_waits`	Number of waits on rollback segments
`newrelicoracledb.rollback_segments_wait_ratio`	Rollback segments wait ratio (waits/gets)
`newrelicoracledb.redo_log_parallel_write_waits`	Number of waits for log file parallel write events
`newrelicoracledb.redo_log_switch_completion_waits`	Number of waits for log file switch completion events
`newrelicoracledb.redo_log_switch_checkpoint_incomplete_waits`	Number of waits for log file switch (checkpoint incomplete) events
`newrelicoracledb.redo_log_switch_archiving_needed_waits`	Number of waits for log file switch (archiving needed) events
`newrelicoracledb.sga_buffer_busy_waits`	Number of buffer busy waits events
`newrelicoracledb.sga_free_buffer_waits`	Number of free buffer waits events
`newrelicoracledb.sga_free_buffer_inspected_waits`	Number of free buffer inspected waits events

Enable enable_system_scraper: true to collect these metrics:

Metric name	Description
`newrelicoracledb.system.active_parallel_sessions`	Active Parallel Sessions
`newrelicoracledb.system.active_serial_sessions`	Active Serial Sessions
`newrelicoracledb.system.background_checkpoints_per_second`	Background Checkpoints Per Sec
`newrelicoracledb.system.background_cpu_usage_per_second`	Background CPU Usage Per Sec
`newrelicoracledb.system.background_time_per_second`	Background Time Per Sec
`newrelicoracledb.system.branch_node_splits_per_second`	Branch Node Splits Per Sec
`newrelicoracledb.system.branch_node_splits_per_transaction`	Branch Node Splits Per Txn
`newrelicoracledb.system.captured_user_calls`	Captured user calls
`newrelicoracledb.system.consistent_read_changes_per_second`	Consistent Read Changes Per Sec
`newrelicoracledb.system.consistent_read_changes_per_transaction`	Consistent Read Changes Per Txn
`newrelicoracledb.system.consistent_read_gets_per_second`	Consistent Read Gets Per Sec
`newrelicoracledb.system.consistent_read_gets_per_transaction`	Consistent Read Gets Per Txn
`newrelicoracledb.system.cpu_usage_per_second`	CPU Usage Per Sec
`newrelicoracledb.system.cpu_usage_per_transaction`	CPU Usage Per Txn
`newrelicoracledb.system.cr_blocks_created_per_second`	CR Blocks Created Per Sec
`newrelicoracledb.system.cr_blocks_created_per_transaction`	CR Blocks Created Per Txn
`newrelicoracledb.system.cr_undo_records_applied_per_second`	CR Undo Records Applied Per Sec
`newrelicoracledb.system.cr_undo_records_applied_per_transaction`	CR Undo Records Applied Per Txn
`newrelicoracledb.system.current_logons_count`	Current Logons Count
`newrelicoracledb.system.current_open_cursors_count`	Current Open Cursors Count
`newrelicoracledb.system.current_os_load`	Current OS Load
`newrelicoracledb.system.cursor_cache_hit_ratio`	Cursor Cache Hit Ratio
`newrelicoracledb.system.database_time_per_second`	Database Time Per Sec
`newrelicoracledb.system.database_wait_time_ratio`	Database Wait Time Ratio
`newrelicoracledb.system.db_block_changes_per_second`	DB Block Changes Per Sec
`newrelicoracledb.system.db_block_changes_per_transaction`	DB Block Changes Per Txn
`newrelicoracledb.system.db_block_changes_per_user_call`	DB Block Changes Per User Call
`newrelicoracledb.system.db_block_gets_per_second`	DB Block Gets Per Sec
`newrelicoracledb.system.db_block_gets_per_transaction`	DB Block Gets Per Txn
`newrelicoracledb.system.db_block_gets_per_user_call`	DB Block Gets Per User Call
`newrelicoracledb.system.dbwr_checkpoints_per_second`	DBWR Checkpoints Per Sec
`newrelicoracledb.system.disk_sort_per_second`	Disk Sort Per Sec
`newrelicoracledb.system.disk_sort_per_transaction`	Disk Sort Per Txn
`newrelicoracledb.system.enqueue_deadlocks_per_second`	Enqueue Deadlocks Per Sec
`newrelicoracledb.system.enqueue_deadlocks_per_transaction`	Enqueue Deadlocks Per Txn
`newrelicoracledb.system.enqueue_requests_per_second`	Enqueue Requests Per Sec
`newrelicoracledb.system.enqueue_requests_per_transaction`	Enqueue Requests Per Txn
`newrelicoracledb.system.enqueue_timeouts_per_second`	Enqueue Timeouts Per Sec
`newrelicoracledb.system.enqueue_timeouts_per_transaction`	Enqueue Timeouts Per Txn
`newrelicoracledb.system.enqueue_waits_per_transaction`	Enqueue Waits Per Txn
`newrelicoracledb.system.execute_without_parse_ratio`	Execute without parse ratio
`newrelicoracledb.system.executions_per_transaction`	Executions per transaction
`newrelicoracledb.system.executions_per_user_call`	Executions per user call
`newrelicoracledb.system.full_index_scans_per_second`	Full Index Scans Per Sec
`newrelicoracledb.system.full_index_scans_per_transaction`	Full Index Scans Per Txn
`newrelicoracledb.system.gc_cr_block_received_per_second`	GC CR Block Received Per Sec (RAC)
`newrelicoracledb.system.gc_cr_block_received_per_transaction`	GC CR Block Received Per Txn (RAC)
`newrelicoracledb.system.gc_current_block_received_per_second`	GC Current Block Received Per Sec (RAC)
`newrelicoracledb.system.gc_current_block_received_per_transaction`	GC Current Block Received Per Txn (RAC)
`newrelicoracledb.system.global_cache_average_cr_get_time`	Global Cache Average CR Get Time (RAC)
`newrelicoracledb.system.global_cache_average_current_get_time`	Global Cache Average Current Get Time (RAC)
`newrelicoracledb.system.global_cache_blocks_corrupted`	Global Cache Blocks Corrupted (RAC)
`newrelicoracledb.system.global_cache_blocks_lost`	Global Cache Blocks Lost (RAC)
`newrelicoracledb.system.hard_parse_count_per_transaction`	Hard Parse Count Per Txn
`newrelicoracledb.system.host_cpu_usage_per_second`	Host CPU Usage Per Sec
`newrelicoracledb.system.io_requests_per_second`	I/O Requests Per Sec
`newrelicoracledb.system.leaf_node_splits_per_second`	Leaf Node Splits Per Sec
`newrelicoracledb.system.leaf_node_splits_per_transaction`	Leaf Node Splits Per Txn
`newrelicoracledb.system.library_cache_hit_ratio`	Library Cache Hit Ratio
`newrelicoracledb.system.library_cache_miss_ratio`	Library Cache Miss Ratio
`newrelicoracledb.system.logical_reads_per_second`	Logical Reads Per Sec
`newrelicoracledb.system.logical_reads_per_transaction`	Logical Reads Per Txn
`newrelicoracledb.system.logical_reads_per_user_call`	Logical Reads Per User Call
`newrelicoracledb.system.logons_per_second`	Logons Per Sec
`newrelicoracledb.system.logons_per_transaction`	Logons Per Txn
`newrelicoracledb.system.long_table_scans_per_second`	Long Table Scans Per Sec
`newrelicoracledb.system.long_table_scans_per_transaction`	Long Table Scans Per Txn
`newrelicoracledb.system.memory_sorts_ratio`	Memory Sorts Ratio
`newrelicoracledb.system.network_traffic_volume_per_second`	Network Traffic Volume Per Sec
`newrelicoracledb.system.open_cursors_per_second`	Open Cursors Per Sec
`newrelicoracledb.system.open_cursors_per_transaction`	Open Cursors Per Txn
`newrelicoracledb.system.parse_failure_count_per_second`	Parse Failure Count Per Sec
`newrelicoracledb.system.parse_failure_count_per_transaction`	Parse Failure Count Per Txn
`newrelicoracledb.system.pga_cache_hit_percentage`	PGA Cache Hit Percentage
`newrelicoracledb.system.physical_lobs_reads_per_second`	Physical LOBs Reads Per Sec
`newrelicoracledb.system.physical_lobs_reads_per_transaction`	Physical LOBs Reads Per Txn
`newrelicoracledb.system.physical_lobs_writes_per_second`	Physical LOBs Writes Per Sec
`newrelicoracledb.system.physical_lobs_writes_per_transaction`	Physical LOBs Writes Per Txn
`newrelicoracledb.system.physical_read_bytes_per_second`	Physical Read Bytes Per Sec
`newrelicoracledb.system.physical_read_io_requests_per_second`	Physical Read IO Requests Per Sec
`newrelicoracledb.system.physical_read_total_bytes_per_second`	Physical Read Total Bytes Per Sec
`newrelicoracledb.system.physical_read_total_io_requests_per_second`	Physical Read Total IO Requests Per Sec
`newrelicoracledb.system.physical_reads_direct_per_second`	Physical Reads Direct Per Sec
`newrelicoracledb.system.physical_reads_direct_per_transaction`	Physical Reads Direct Per Txn
`newrelicoracledb.system.physical_reads_per_transaction`	Physical Reads Per Txn
`newrelicoracledb.system.physical_write_bytes_per_second`	Physical Write Bytes Per Sec
`newrelicoracledb.system.physical_write_io_requests_per_second`	Physical Write IO Requests Per Sec
`newrelicoracledb.system.physical_write_total_bytes_per_second`	Physical Write Total Bytes Per Sec
`newrelicoracledb.system.physical_write_total_io_requests_per_second`	Physical Write Total IO Requests Per Sec
`newrelicoracledb.system.physical_writes_direct_per_second`	Physical Writes Direct Per Sec
`newrelicoracledb.system.physical_writes_direct_per_transaction`	Physical Writes Direct Per Txn
`newrelicoracledb.system.physical_writes_per_transaction`	Physical Writes Per Txn
`newrelicoracledb.system.process_limit_percentage`	Process Limit Percentage
`newrelicoracledb.system.recursive_calls_per_second`	Recursive Calls Per Sec
`newrelicoracledb.system.recursive_calls_per_transaction`	Recursive Calls Per Txn
`newrelicoracledb.system.redo_allocation_hit_ratio`	Redo Allocation Hit Ratio
`newrelicoracledb.system.redo_generated_bytes_per_transaction`	Redo Generated Bytes Per Txn
`newrelicoracledb.system.redo_writes_per_second`	Redo Writes Per Sec
`newrelicoracledb.system.redo_writes_per_transaction`	Redo Writes Per Txn
`newrelicoracledb.system.row_cache_hit_ratio`	Row Cache Hit Ratio
`newrelicoracledb.system.row_cache_miss_ratio`	Row Cache Miss Ratio
`newrelicoracledb.system.rows_per_sort`	Rows Per Sort
`newrelicoracledb.system.session_count`	Session Count
`newrelicoracledb.system.session_limit_percentage`	Session Limit Percentage
`newrelicoracledb.system.shared_pool_free_percentage`	Shared Pool Free Percentage
`newrelicoracledb.system.soft_parse_ratio`	Soft Parse Ratio
`newrelicoracledb.system.sql_service_response_time`	SQL Service Response Time
`newrelicoracledb.system.streams_pool_usage_percentage`	Streams Pool Usage Percentage
`newrelicoracledb.system.temp_space_used`	Temporary Space Used
`newrelicoracledb.system.total_index_scans_per_second`	Total Index Scans Per Sec
`newrelicoracledb.system.total_index_scans_per_transaction`	Total Index Scans Per Txn
`newrelicoracledb.system.total_parse_count_per_second`	Total Parse Count Per Sec
`newrelicoracledb.system.total_parse_count_per_transaction`	Total Parse Count Per Txn
`newrelicoracledb.system.total_sorts_per_user_call`	Total Sorts Per User Call
`newrelicoracledb.system.total_table_scans_per_second`	Total Table Scans Per Sec
`newrelicoracledb.system.total_table_scans_per_transaction`	Total Table Scans Per Txn
`newrelicoracledb.system.total_table_scans_per_user_call`	Total Table Scans Per User Call
`newrelicoracledb.system.transactions_per_logon`	Transactions Per Logon
`newrelicoracledb.system.transactions_per_second`	Transactions Per Sec
`newrelicoracledb.system.user_calls_per_second`	User Calls Per Sec
`newrelicoracledb.system.user_calls_per_transaction`	User Calls Per Txn
`newrelicoracledb.system.user_calls_ratio`	User Calls Ratio
`newrelicoracledb.system.user_commits_percentage`	User Commits Percentage
`newrelicoracledb.system.user_limit_percentage`	User Limit Percentage
`newrelicoracledb.system.user_rollback_undo_records_applied_per_second`	User Rollback Undo Records Applied Per Sec
`newrelicoracledb.system.user_rollback_undo_records_applied_per_transaction`	User Rollback Undo Records Applied Per Txn
`newrelicoracledb.system.user_rollbacks_per_second`	User Rollbacks Per Sec
`newrelicoracledb.system.user_rollbacks_percentage`	User Rollbacks Percentage

Enable enable_connection_scraper: true to collect these metrics:

Metric name	Description
`newrelicoracledb.connection.sessions_by_status`	Number of sessions grouped by status
`newrelicoracledb.connection.sessions_by_type`	Number of sessions grouped by type
`newrelicoracledb.connection.logons_cumulative`	Cumulative number of logons since instance startup
`newrelicoracledb.connection.logons_current`	Current number of active logons
`newrelicoracledb.connection.shared_servers`	Number of shared servers
`newrelicoracledb.connection.dispatchers`	Number of dispatchers
`newrelicoracledb.connection.circuits`	Number of active circuits
`newrelicoracledb.connection.resource_current_utilization`	Current utilization of Oracle resources
`newrelicoracledb.connection.resource_max_utilization`	Maximum utilization of Oracle resources since startup
`newrelicoracledb.connection.resource_limit`	Limit value for Oracle resources
`newrelicoracledb.connection.user_commits`	Number of user commits
`newrelicoracledb.connection.user_rollbacks`	Number of user rollbacks
`newrelicoracledb.connection.parse_count_total`	Total number of parse calls
`newrelicoracledb.connection.parse_count_hard`	Number of hard parse calls
`newrelicoracledb.connection.sqlnet_roundtrips`	Number of SQL*Net roundtrips to/from client
`newrelicoracledb.connection.bytes_sent`	Bytes sent via SQL*Net to client
`newrelicoracledb.connection.bytes_received`	Bytes received via SQL*Net from client

Enable enable_pdb_scraper: true to collect these PDB (Pluggable Database) metrics:

Metric name	Description
`newrelicoracledb.pdb.active_parallel_sessions`	Number of active parallel sessions in PDB
`newrelicoracledb.pdb.active_serial_sessions`	Number of active serial sessions in PDB
`newrelicoracledb.pdb.average_active_sessions`	Average number of active sessions in PDB
`newrelicoracledb.pdb.background_cpu_usage_per_second`	Background CPU usage per second in PDB
`newrelicoracledb.pdb.background_time_per_second`	Background time per second in PDB
`newrelicoracledb.pdb.block_changes_per_second`	DB block changes per second in PDB
`newrelicoracledb.pdb.block_changes_per_transaction`	DB block changes per transaction in PDB
`newrelicoracledb.pdb.cpu_time_ratio`	Database CPU time ratio in PDB
`newrelicoracledb.pdb.cpu_usage_per_second`	CPU usage per second in PDB
`newrelicoracledb.pdb.cpu_usage_per_transaction`	CPU usage per transaction in PDB
`newrelicoracledb.pdb.current_logons`	Current number of logons in PDB
`newrelicoracledb.pdb.current_open_cursors`	Current number of open cursors in PDB
`newrelicoracledb.pdb.db_physical_read_bytes_per_second`	Physical read bytes per second in PDB
`newrelicoracledb.pdb.db_physical_reads_per_second`	Physical reads per second in PDB
`newrelicoracledb.pdb.db_physical_write_bytes_per_second`	Physical write bytes per second in PDB
`newrelicoracledb.pdb.db_physical_writes_per_second`	Physical writes per second in PDB
`newrelicoracledb.pdb.execute_without_parse_ratio`	Execute without parse ratio in PDB
`newrelicoracledb.pdb.executions_per_second`	Executions per second in PDB
`newrelicoracledb.pdb.executions_per_transaction`	Executions per transaction in PDB
`newrelicoracledb.pdb.hard_parse_count_per_second`	Hard parse count per second in PDB
`newrelicoracledb.pdb.hard_parse_count_per_transaction`	Hard parse count per transaction in PDB
`newrelicoracledb.pdb.logical_reads_per_second`	Logical reads per second in PDB
`newrelicoracledb.pdb.logical_reads_per_transaction`	Logical reads per transaction in PDB
`newrelicoracledb.pdb.logons_per_second`	Logons per second in PDB
`newrelicoracledb.pdb.logons_per_transaction`	Logons per transaction in PDB
`newrelicoracledb.pdb.network_traffic_byte_per_second`	Network traffic volume per second in bytes in PDB
`newrelicoracledb.pdb.open_cursors_per_second`	Open cursors per second in PDB
`newrelicoracledb.pdb.open_cursors_per_transaction`	Open cursors per transaction in PDB
`newrelicoracledb.pdb.parse_failure_count_per_second`	Parse failure count per second in PDB
`newrelicoracledb.pdb.physical_read_bytes_per_second`	Physical read total bytes per second in PDB
`newrelicoracledb.pdb.physical_reads_per_transaction`	Physical reads per transaction in PDB
`newrelicoracledb.pdb.physical_write_bytes_per_second`	Physical write total bytes per second in PDB
`newrelicoracledb.pdb.physical_writes_per_transaction`	Physical writes per transaction in PDB
`newrelicoracledb.pdb.redo_generated_bytes_per_second`	Redo generated per second in bytes in PDB
`newrelicoracledb.pdb.redo_generated_bytes_per_transaction`	Redo generated per transaction in bytes in PDB
`newrelicoracledb.pdb.response_time_per_transaction`	Response time per transaction in PDB
`newrelicoracledb.pdb.session_count`	Session count in PDB
`newrelicoracledb.pdb.soft_parse_ratio`	Soft parse ratio in PDB
`newrelicoracledb.pdb.sql_service_response_time`	SQL service response time in PDB
`newrelicoracledb.pdb.total_parse_count_per_second`	Total parse count per second in PDB
`newrelicoracledb.pdb.total_parse_count_per_transaction`	Total parse count per transaction in PDB
`newrelicoracledb.pdb.transactions_per_second`	User transactions per second in PDB
`newrelicoracledb.pdb.user_calls_per_second`	User calls per second in PDB
`newrelicoracledb.pdb.user_calls_per_transaction`	User calls per transaction in PDB
`newrelicoracledb.pdb.user_commits_per_second`	User commits per second in PDB
`newrelicoracledb.pdb.user_commits_percentage`	User commits percentage in PDB
`newrelicoracledb.pdb.user_rollbacks_per_second`	User rollbacks per second in PDB
`newrelicoracledb.pdb.user_rollbacks_percentage`	User rollbacks percentage in PDB
`newrelicoracledb.pdb.wait_time_ratio`	Database wait time ratio in PDB

Enable enable_container_scraper: true to collect these container metrics for CDB environments:

Metric name	Description
`newrelicoracledb.container.status`	Container open mode status (1=READ WRITE 0=other)
`newrelicoracledb.container.restricted`	Container restricted mode (1=YES 0=NO)
`newrelicoracledb.pdb.open_mode`	PDB open mode (1=READ WRITE 0=other)
`newrelicoracledb.pdb.total_size_bytes`	Total size of PDB in bytes
`newrelicoracledb.tablespace.used_bytes`	Used bytes per tablespace in CDB
`newrelicoracledb.tablespace.total_bytes`	Total bytes per tablespace in CDB
`newrelicoracledb.tablespace.used_percent`	Usage percentage per tablespace in CDB
`newrelicoracledb.datafile.size_bytes`	Size of data file in bytes
`newrelicoracledb.datafile.used_bytes`	Used bytes in data file
`newrelicoracledb.datafile.autoextensible`	Data file autoextensible status (1=YES 0=NO)
`newrelicoracledb.service.status`	Oracle service status (1=active 0=inactive)
`newrelicoracledb.service.count`	Count of services per container

Enable enable_rac_scraper: true to collect these RAC (Real Application Clusters) metrics:

Metric name	Description
`newrelicoracledb.asm.diskgroup.total_mb`	Total capacity of the ASM disk group in MB
`newrelicoracledb.asm.diskgroup.free_mb`	Available free space in the ASM disk group in MB
`newrelicoracledb.asm.diskgroup.offline_disks`	Number of offline disks in the ASM disk group
`newrelicoracledb.rac.wait_time`	Rate of cluster wait time in microseconds per second
`newrelicoracledb.rac.total_waits`	Total number of cluster wait events
`newrelicoracledb.rac.instance.status`	RAC instance status (1=OPEN 0=other)
`newrelicoracledb.rac.instance.uptime_seconds`	Instance uptime in seconds since startup
`newrelicoracledb.rac.instance.database_status`	Database status indicator (1=ACTIVE 0=other)
`newrelicoracledb.rac.instance.active_state`	Instance active state indicator (1=NORMAL 0=other)
`newrelicoracledb.rac.instance.logins_allowed`	Instance login status indicator (1=ALLOWED 0=RESTRICTED)
`newrelicoracledb.rac.instance.archiver_started`	Archiver status indicator (1=STARTED 0=STOPPED)
`newrelicoracledb.rac.instance.version_info`	Oracle database version information (always 1 version in attributes)
`newrelicoracledb.rac.service.instance_id`	Instance ID where the service is currently running
`newrelicoracledb.rac.service.network_config`	Service network configuration (always 1 config in attributes)
`newrelicoracledb.rac.service.clb_config`	Connection load balancing configuration (always 1 config in attributes)
`newrelicoracledb.rac.service.goal_config`	Service goal configuration (always 1 goal in attributes)
`newrelicoracledb.rac.service.blocked_status`	Service blocked indicator (1=blocked 0=not blocked)
`newrelicoracledb.rac.service.fan_enabled`	Fast Application Notification (FAN) enabled indicator (1=enabled 0=disabled)
`newrelicoracledb.rac.service.transaction_guard_enabled`	Transaction Guard enabled indicator (1=enabled 0=disabled)
`newrelicoracledb.rac.service.drain_timeout_seconds`	Session drain timeout in seconds before service stop
`newrelicoracledb.rac.service.replay_timeout_seconds`	Application Continuity replay initiation timeout in seconds

Enable enable_database_info_scraper: true to collect these database information metrics:

Metric name	Description
`newrelicoracledb.database.info`	Database version and configuration information
`newrelicoracledb.hosting.info`	Database hosting and platform information
`newrelicoracledb.database.role`	Database role and Data Guard configuration

Enable enable_query_monitoring: true to collect these slow query monitoring metrics:

Metric name	Description
`newrelicoracledb.slow_queries.execution_count`	Number of executions for slow queries
`newrelicoracledb.slow_queries.total_elapsed_time`	Total cumulative elapsed time for slow queries
`newrelicoracledb.slow_queries.total_cpu_time`	Total cumulative CPU time for slow queries
`newrelicoracledb.slow_queries.total_wait_time`	Total cumulative wait time for slow queries (elapsed_time - cpu_time)
`newrelicoracledb.slow_queries.total_rows_examined`	Total cumulative rows examined for slow queries (buffer gets/logical reads)
`newrelicoracledb.slow_queries.total_rows_returned`	Total cumulative rows returned for slow queries (rows processed)
`newrelicoracledb.slow_queries.total_disk_reads`	Total cumulative disk reads for slow queries
`newrelicoracledb.slow_queries.total_disk_writes`	Total cumulative direct writes for slow queries - writes bypassing buffer cache
`newrelicoracledb.slow_queries.interval_execution_count`	Number of new executions since last scrape (delta metric)
`newrelicoracledb.slow_queries.interval_elapsed_time`	Total elapsed time in the last polling interval (delta metric not averaged)
`newrelicoracledb.slow_queries.interval_cpu_time`	Total CPU time in the last polling interval (delta metric not averaged)
`newrelicoracledb.slow_queries.interval_wait_time`	Total wait time in the last polling interval (delta metric not averaged)
`newrelicoracledb.slow_queries.interval_buffer_gets`	Total buffer gets (logical reads) in the last polling interval (delta metric not averaged)
`newrelicoracledb.slow_queries.interval_rows_processed`	Total rows processed (returned) in the last polling interval (delta metric not averaged)
`newrelicoracledb.slow_queries.interval_disk_reads`	Total disk reads in the last polling interval (delta metric not averaged)
`newrelicoracledb.slow_queries.interval_disk_writes`	Total direct writes in the last polling interval - writes bypassing buffer cache (delta metric not averaged)
`newrelicoracledb.slow_queries.interval_avg_elapsed_time`	Average elapsed time per execution in the last polling interval (delta metric)
`newrelicoracledb.slow_queries.interval_avg_cpu_time`	Average CPU time per execution in the last polling interval (delta metric)
`newrelicoracledb.slow_queries.interval_avg_wait_time`	Average wait time per execution in the last polling interval (delta metric)
`newrelicoracledb.slow_queries.interval_avg_buffer_gets`	Average buffer gets (logical reads) per execution in the last polling interval (delta metric)
`newrelicoracledb.slow_queries.interval_avg_rows_processed`	Average rows processed (returned) per execution in the last polling interval (delta metric)
`newrelicoracledb.slow_queries.interval_avg_disk_reads`	Average disk reads per execution in the last polling interval (delta metric)
`newrelicoracledb.slow_queries.interval_avg_disk_writes`	Average direct writes per execution in the last polling interval - writes bypassing buffer cache (delta metric)
`newrelicoracledb.slow_queries.query_details`	Slow Query Details count
`newrelicoracledb.child_cursors.elapsed_time`	Average elapsed time per execution for this child cursor (in milliseconds)
`newrelicoracledb.child_cursors.cpu_time`	Average CPU time per execution for this child cursor (in milliseconds)
`newrelicoracledb.child_cursors.user_io_wait_time`	Average user I/O wait time per execution for this child cursor (in milliseconds)
`newrelicoracledb.child_cursors.buffer_gets`	Average number of buffer gets per execution for this child cursor
`newrelicoracledb.child_cursors.disk_reads`	Average number of disk reads per execution for this child cursor
`newrelicoracledb.child_cursors.executions`	Total number of executions of this child cursor
`newrelicoracledb.child_cursors.invalidations`	Number of times this child cursor was invalidated
`newrelicoracledb.child_cursors.details`	Child cursor details including load times
`newrelicoracledb.execution_plan`	Oracle SQL execution plan details including operation costs cardinality and resource estimates

What's next

After setting up Oracle database monitoring with NRDOT:

Create custom dashboards to visualize your database metrics
Set up alerts for critical database performance thresholds
Explore your data using New Relic's query capabilities

Preview

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

Set-up the NRDOT Collector for Oracle Database monitoring

Sugerencia

Installation method

Importante

For ARM64 architecture

Configure database user

Sugerencia

Grant monitoring privileges for multitenant database

Configure NRDOT Collector

Importante

Sugerencia

Restart NRDOT collector

Sugerencia

(Optional) Multi-receiver configuration

Sugerencia

(Optional) Set up APM-database correlation

Importante

(Optional) Configure secret management

Find and use your data

Installation method

For AMD64 architecture

For ARM64 architecture

Configure database user

Grant monitoring privileges for RDS database

Configure NRDOT Collector

Importante

Restart NRDOT collector

Sugerencia

(Optional) Multi-receiver configuration

Sugerencia

(Optional) Set up APM-database correlation

Importante

(Optional) Configure secret management

Find and use your data

NRDOT collector supported commands

NRDOT Collector commands

Available metrics

Default metrics

Default metrics collected by NRDOT Collector

Additional metrics

Tablespace metrics

Core metrics

System metrics

Connection metrics

PDB metrics

Container metrics

RAC metrics

Database info metrics

Query monitoring metrics

What's next

Prerequisites