Monitoramento do Oracle Database com NRDOT

Método de instalação

Selecione o método de distribuição de instalação adequado para o seu ambiente Linux:

Configurar usuário do banco de dados

Crie um usuário de monitoramento com os privilégios necessários para o seu banco de dados Oracle multitenant. Isso requer a criação de um usuário comum com o prefixo C##.

1. Antes de criar o usuário do banco de dados ou executar quaisquer concessões de atribuição, você deve executar a seguinte instrução como um usuário SYS para definir seu contexto de contêiner ativo atual para CDB$ROOT:

   ALTER SESSION SET CONTAINER = CDB$ROOT;

   Copiar

2. Para bancos de dados multilocatários, login no banco de dados raiz como administrador. Use CREATE USER para adicionar um novo usuário ao banco de dados. O nome de usuário especificado será um 'usuário comum' e precisa ser prefixado com c## conforme recomendado pela Oracle.

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

   Copiar

3. Execute a seguinte instrução como SYSDBA na raiz do CDB. Isso permite que o usuário de monitoramento veja as linhas de cada PDB nas visualizações de dados do contêiner, o que é necessário para métricas e eventos por PDB.

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

   Copiar

   Dica

   Certifique-se de que sua USER_PASSWORD atenda aos requisitos de senha de novo usuário da Oracle.

Conceder privilégios de monitoramento para banco de dados multitenant

Execute as seguintes instruções GRANT como SYSDBA na raiz do CDB. Estas abrangem a detecção de instância, a coleta de métricas, o monitoramento por PDB e a coleta de eventos. Você pode executá-las juntas como um único script ou executar cada instrução individualmente.

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_STATISTICS_ALL       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;
GRANT SELECT ON V_$PDBS           TO c##<USER_NAME> CONTAINER=ALL;
GRANT SELECT ON CDB_SERVICES      TO c##<USER_NAME> CONTAINER=ALL;

Configurar o NRDOT Collector

1. Crie o arquivo de configuração. O nome do arquivo deve ser oracle-config.yaml.

   bash

   Copiar

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

2. Adicione o conteúdo de configuração abaixo ao arquivo oracle-config.yaml que você criou na etapa anterior.

   Host NRDOT com configuração de banco de dados

   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
     nroracledb:
       endpoint: "<YOUR_DB_HOST>:<YOUR_DB_PORT>"
       username: "C##<YOUR_DB_USERNAME>"
       password: "<YOUR_DB_PASSWORD>"
       service: "<YOUR_CDB_SERVICE_NAME>"
       collection_interval: 10s
       events:
         db.server.query_sample:
           enabled: true
         db.server.top_query:
           enabled: true
         db.server.session.wait_sample:
           enabled: true
   
       top_query_collection:
         max_query_sample_count: 1000
         top_query_count: 200
         collection_interval: 60s
         allowed_comment_keys:
           - nr_service_guid
   
       query_sample_collection:
         max_rows_per_query: 100
         allowed_comment_keys:
           - nr_service_guid
   
       session_wait_event_collection:
         max_rows_per_query: 100
   
       # Metrics configuration - organized by category
       metrics:
         # === CPU & Performance Metrics ===
         oracledb.cpu_time:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.database.cpu.utilization:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.host.cpu.utilization:
           enabled: true
           attributes:
             - oracle.db.pdb
         # === Execution & Parse Metrics ===
         oracledb.executions:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.execution.utilization:
           enabled: true
           attributes:
             - oracledb.parse.type
             - oracle.db.pdb
         oracledb.parse_calls:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.parse.rate:
           enabled: true
           attributes:
             - oracledb.parse.result
             - oracle.db.pdb
         oracledb.parse.utilization:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.hard_parses:
           enabled: true
           attributes:
             - oracle.db.pdb
   
         # === I/O & Physical Read/Write Metrics ===
         oracledb.logical_reads:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.physical_reads:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.physical_reads_direct:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.physical_writes:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.physical_writes_direct:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.physical_read_io_requests:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.physical_write_io_requests:
           enabled: true
           attributes:
             - oracle.db.pdb
   
         # === New Physical I/O Metrics (detailed) ===
         oracledb.physical_io.cache_writes:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.physical_io.requests:
           enabled: true
           attributes:
             - disk.io.direction
             - disk.io.block_size
             - oracle.db.pdb
         oracledb.physical_io.transferred:
           enabled: true
           attributes:
             - disk.io.direction
             - disk.io.type
             - oracle.db.pdb
   
         # === Network I/O Metrics ===
         oracledb.sqlnet.io.transferred:
           enabled: true
           attributes:
             - network.io.direction
             - destination.type
             - oracle.db.pdb
   
         # === Buffer & Cache Metrics ===
         oracledb.consistent_gets:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.db_block_gets:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.buffer_cache.utilization:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.library_cache.utilization:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.data_dictionary.hit_ratio:
           enabled: true
         oracledb.shared_pool.utilization:
           enabled: true
           attributes:
             - oracle.db.pdb
   
         # === Memory Metrics ===
         oracledb.pga_memory:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.sga.limit:
           enabled: true
         oracledb.sga.usage:
           enabled: true
           attributes:
             - oracledb.sga.component.name
   
         # === Wait & Database Time Metrics ===
         oracledb.database.wait.utilization:
           enabled: true
           attributes:
             - oracle.db.pdb
   
         # === Lock & Deadlock Metrics ===
         oracledb.dml_locks.limit:
           enabled: true
         oracledb.dml_locks.usage:
           enabled: true
         oracledb.enqueue_locks.limit:
           enabled: true
         oracledb.enqueue_locks.usage:
           enabled: true
         oracledb.enqueue_resources.limit:
           enabled: true
         oracledb.enqueue_resources.usage:
           enabled: true
         oracledb.enqueue_deadlocks:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.exchange_deadlocks:
           enabled: true
           attributes:
             - oracle.db.pdb
   
         # === Process & Session Metrics ===
         oracledb.processes.limit:
           enabled: true
         oracledb.processes.usage:
           enabled: true
         oracledb.sessions.limit:
           enabled: true
         oracledb.sessions.usage:
           enabled: true
           attributes:
             - session_type
             - session_status
             - oracle.db.pdb
         oracledb.logons:
           enabled: true
           attributes:
             - oracle.db.pdb
   
         # === Transaction Metrics ===
         oracledb.transactions.limit:
           enabled: true
         oracledb.transactions.usage:
           enabled: true
         oracledb.user_commits:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.user_rollbacks:
           enabled: true
           attributes:
             - oracle.db.pdb
   
         # === Tablespace Metrics ===
         oracledb.tablespace_size.limit:
           enabled: true
           attributes:
             - tablespace_name
             - oracle.db.pdb
         oracledb.tablespace_size.usage:
           enabled: true
           attributes:
             - tablespace_name
             - oracle.db.pdb
   
         # === Storage Metrics ===
         oracledb.storage.usage:
           enabled: true
         oracledb.storage.utilization:
           enabled: true
         oracledb.recycle_bin.limit:
           enabled: true
   
         # === Parallel Operations Metrics ===
         oracledb.queries_parallelized:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.ddl_statements_parallelized:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.dml_statements_parallelized:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.parallel_operations_not_downgraded:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.parallel_operations_downgraded_1_to_25_pct:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.parallel_operations_downgraded_25_to_50_pct:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.parallel_operations_downgraded_50_to_75_pct:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.parallel_operations_downgraded_75_to_99_pct:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.parallel_operations_downgraded_to_serial:
           enabled: true
           attributes:
             - oracle.db.pdb
   
         # === Redo & Sort Metrics ===
         oracledb.redo_allocation.utilization:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.sort.ratio:
           enabled: true
           attributes:
             - oracledb.sort.type
             - oracle.db.pdb
   
         # === Response Time Metrics ===
         oracledb.sql_service.response.duration:
           enabled: true
           attributes:
             - oracle.db.pdb
   
       # Resource attributes attached to all metrics/logs (all enabled by default)
       resource_attributes:
         host.name:
           enabled: true
         oracle.db.hosting_type:
           enabled: true
         oracle.db.open_mode:
           enabled: true
         oracle.db.pdb:
           enabled: true
         oracle.db.role:
           enabled: true
         oracle.db.version:
           enabled: true
         oracledb.instance.name:
           enabled: true
         service.instance.id:
           enabled: 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, "")
     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:
     resource/add_event_name:
       attributes:
         - key: host.address
           value: "<YOUR_DB_HOST>"
           action: upsert
     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
   
   exporters:
     otlp:
       endpoint: "<YOUR_NEWRELIC_OTLP_ENDPOINT>"
       headers:
         api-key: "<YOUR_NEWRELIC_LICENSE_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
           - 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: [nroracledb]
         processors: [resource/add_event_name, batch]
         exporters: [otlp]
       logs/oracledb:
         receivers: [nroracledb]
         processors: [resource/add_event_name, batch]
         exporters: [otlp]
     extensions: [health_check]

   Copiar

   Configuração do banco de dados

   receivers:
     nroracledb:
       endpoint: "<YOUR_DB_HOST>:<YOUR_DB_PORT>"
       username: "C##<YOUR_DB_USERNAME>"
       password: "<YOUR_DB_PASSWORD>"
       service: "<YOUR_CDB_SERVICE_NAME>"
       collection_interval: 10s
       events:
         db.server.query_sample:
           enabled: true
         db.server.top_query:
           enabled: true
         db.server.session.wait_sample:
           enabled: true
   
       top_query_collection:
         max_query_sample_count: 1000
         top_query_count: 200
         collection_interval: 60s
         allowed_comment_keys:
           - nr_service_guid
   
       query_sample_collection:
         max_rows_per_query: 100
         allowed_comment_keys:
           - nr_service_guid
   
       session_wait_event_collection:
         max_rows_per_query: 100
   
       # Metrics configuration - organized by category
       metrics:
         # === CPU & Performance Metrics ===
         oracledb.cpu_time:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.database.cpu.utilization:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.host.cpu.utilization:
           enabled: true
           attributes:
             - oracle.db.pdb
         # === Execution & Parse Metrics ===
         oracledb.executions:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.execution.utilization:
           enabled: true
           attributes:
             - oracledb.parse.type
             - oracle.db.pdb
         oracledb.parse_calls:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.parse.rate:
           enabled: true
           attributes:
             - oracledb.parse.result
             - oracle.db.pdb
         oracledb.parse.utilization:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.hard_parses:
           enabled: true
           attributes:
             - oracle.db.pdb
   
         # === I/O & Physical Read/Write Metrics ===
         oracledb.logical_reads:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.physical_reads:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.physical_reads_direct:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.physical_writes:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.physical_writes_direct:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.physical_read_io_requests:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.physical_write_io_requests:
           enabled: true
           attributes:
             - oracle.db.pdb
   
         # === New Physical I/O Metrics (detailed) ===
         oracledb.physical_io.cache_writes:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.physical_io.requests:
           enabled: true
           attributes:
             - disk.io.direction
             - disk.io.block_size
             - oracle.db.pdb
         oracledb.physical_io.transferred:
           enabled: true
           attributes:
             - disk.io.direction
             - disk.io.type
             - oracle.db.pdb
   
         # === Network I/O Metrics ===
         oracledb.sqlnet.io.transferred:
           enabled: true
           attributes:
             - network.io.direction
             - destination.type
             - oracle.db.pdb
   
         # === Buffer & Cache Metrics ===
         oracledb.consistent_gets:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.db_block_gets:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.buffer_cache.utilization:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.library_cache.utilization:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.data_dictionary.hit_ratio:
           enabled: true
         oracledb.shared_pool.utilization:
           enabled: true
           attributes:
             - oracle.db.pdb
   
         # === Memory Metrics ===
         oracledb.pga_memory:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.sga.limit:
           enabled: true
         oracledb.sga.usage:
           enabled: true
           attributes:
             - oracledb.sga.component.name
   
         # === Wait & Database Time Metrics ===
         oracledb.database.wait.utilization:
           enabled: true
           attributes:
             - oracle.db.pdb
   
         # === Lock & Deadlock Metrics ===
         oracledb.dml_locks.limit:
           enabled: true
         oracledb.dml_locks.usage:
           enabled: true
         oracledb.enqueue_locks.limit:
           enabled: true
         oracledb.enqueue_locks.usage:
           enabled: true
         oracledb.enqueue_resources.limit:
           enabled: true
         oracledb.enqueue_resources.usage:
           enabled: true
         oracledb.enqueue_deadlocks:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.exchange_deadlocks:
           enabled: true
           attributes:
             - oracle.db.pdb
   
         # === Process & Session Metrics ===
         oracledb.processes.limit:
           enabled: true
         oracledb.processes.usage:
           enabled: true
         oracledb.sessions.limit:
           enabled: true
         oracledb.sessions.usage:
           enabled: true
           attributes:
             - session_type
             - session_status
             - oracle.db.pdb
         oracledb.logons:
           enabled: true
           attributes:
             - oracle.db.pdb
   
         # === Transaction Metrics ===
         oracledb.transactions.limit:
           enabled: true
         oracledb.transactions.usage:
           enabled: true
         oracledb.user_commits:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.user_rollbacks:
           enabled: true
           attributes:
             - oracle.db.pdb
   
         # === Tablespace Metrics ===
         oracledb.tablespace_size.limit:
           enabled: true
           attributes:
             - tablespace_name
             - oracle.db.pdb
         oracledb.tablespace_size.usage:
           enabled: true
           attributes:
             - tablespace_name
             - oracle.db.pdb
   
         # === Storage Metrics ===
         oracledb.storage.usage:
           enabled: true
         oracledb.storage.utilization:
           enabled: true
         oracledb.recycle_bin.limit:
           enabled: true
   
         # === Parallel Operations Metrics ===
         oracledb.queries_parallelized:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.ddl_statements_parallelized:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.dml_statements_parallelized:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.parallel_operations_not_downgraded:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.parallel_operations_downgraded_1_to_25_pct:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.parallel_operations_downgraded_25_to_50_pct:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.parallel_operations_downgraded_50_to_75_pct:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.parallel_operations_downgraded_75_to_99_pct:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.parallel_operations_downgraded_to_serial:
           enabled: true
           attributes:
             - oracle.db.pdb
   
         # === Redo & Sort Metrics ===
         oracledb.redo_allocation.utilization:
           enabled: true
           attributes:
             - oracle.db.pdb
         oracledb.sort.ratio:
           enabled: true
           attributes:
             - oracledb.sort.type
             - oracle.db.pdb
   
         # === Response Time Metrics ===
         oracledb.sql_service.response.duration:
           enabled: true
           attributes:
             - oracle.db.pdb
   
       # Resource attributes attached to all metrics/logs (all enabled by default)
       resource_attributes:
         host.name:
           enabled: true
         oracle.db.hosting_type:
           enabled: true
         oracle.db.open_mode:
           enabled: true
         oracle.db.pdb:
           enabled: true
         oracle.db.role:
           enabled: true
         oracle.db.version:
           enabled: true
         oracledb.instance.name:
           enabled: true
         service.instance.id:
           enabled: true
           
   processors:
     batch:
     resource/add_event_name:
       attributes:
         - key: host.address
           value: "<YOUR_DB_HOST>"
           action: upsert
   
   exporters:
     otlp/newrelic:
       endpoint: "<YOUR_NEWRELIC_OTLP_ENDPOINT>"
       headers:
         api-key: "<YOUR_NEWRELIC_LICENSE_KEY>"
       compression: gzip
       retry_on_failure:
         enabled: true
         initial_interval: 5s
         max_interval: 30s
         max_elapsed_time: 300s
   
   service:
     pipelines:
       metrics/oracledb:
         receivers: [nroracledb]
         processors: [resource/add_event_name, batch]
         exporters: [otlp/newrelic]
       logs/oracledb:
         receivers: [nroracledb]
         processors: [resource/add_event_name, batch]
         exporters: [otlp/newrelic]

   Copiar

3. Atualize a configuração do coletor NRDOT para usar seu arquivo oracle-config.yaml.

   bash

   Copiar

   $
   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. Defina os seguintes parâmetros obrigatórios no arquivo de configuração:

   Parâmetro	Descrição
   <YOUR_DB_HOST>	Insira o nome do host do banco de dados Oracle.
   <YOUR_DB_PORT>	Insira a porta do seu banco de dados Oracle.
   <USERNAME>	Insira seu nome de usuário do banco de dados.
   <PASSWORD>	Insira a senha do seu banco de dados.
   <YOUR_SERVICE_NAME>	Insira o nome do serviço Oracle.
   <YOUR_NEWRELIC_OTLP_ENDPOINT>	Insira o endpoint OTLP da New Relic. Para mais informações, consulte a documentação dos endpoints OTLP da New Relic.
   <YOUR_NEWRELIC_LICENSE_KEY>	Insira sua chave de API da New Relic.

5. Na seção Eventos, ative estes tipos de evento para coletar suas métricas:

   Evento	Descrição
   db.server.query_sample	Amostras de consultas ativas por sessão capturando o SQL atual, estado de espera e detalhes de bloqueio.
   db.server.top_query	As N principais instruções SQL por CPU ou tempo decorrido, incluindo estatísticas de execução e planos de consulta.
   db.server.session.wait_sample	Contagens e durações de espera cumulativas por sessão de v$session_event .

6. Configure as configurações de coleta para cada tipo de evento:

   Seção de configuração	Parâmetro	Valor padrão
   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

(Opcional) Configurar o receptor de consulta SQL

Você pode configurar o receptor de consulta SQL para coletar métricas personalizadas do seu banco de dados Oracle. Para obter mais informações, consulte a documentação do receptor de consulta SQL.

Reiniciar o coletor NRDOT

Após atualizar a configuração, reinicie o coletor NRDOT:

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

(Opcional) Configuração de multirreceptor

O binário nrdot-collector suporta uma configuração de múltiplos receptores em um único oracle-config.yaml para monitorar várias instâncias de banco de dados Oracle usando credenciais exclusivas.

receivers:
  # First CDB configuration (anchor — pdb1/cdb2/pdb2 inherit via merge key)
  nroracledb/cdb1: &nroracledb-common
    endpoint: "<YOUR_DB_HOST>:<YOUR_DB_PORT>"
    username: "C##<user_name>"
    password: "<password>"
    service: "<YOUR_CDB1_SERVICE_NAME>"
    collection_interval: 30s

    events:
      db.server.query_sample:
        enabled: true
      db.server.top_query:
        enabled: true
      db.server.session.wait_sample:
        enabled: true

    top_query_collection:
      max_query_sample_count: 1000
      top_query_count: 200
      collection_interval: 60s
      allowed_comment_keys:
        - nr_service_guid

    query_sample_collection:
      max_rows_per_query: 100
      allowed_comment_keys:
        - nr_service_guid

    session_wait_event_collection:
      max_rows_per_query: 100

    # Metrics configuration - organized by category
    metrics:
      # === CPU & Performance Metrics ===
      oracledb.cpu_time:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.database.cpu.utilization:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.host.cpu.utilization:
        enabled: true
        attributes:
          - oracle.db.pdb

      # === Execution & Parse Metrics ===
      oracledb.executions:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.execution.utilization:
        enabled: true
        attributes:
          - oracledb.parse.type
          - oracle.db.pdb
      oracledb.parse_calls:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.parse.rate:
        enabled: true
        attributes:
          - oracledb.parse.result
          - oracle.db.pdb
      oracledb.parse.utilization:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.hard_parses:
        enabled: true
        attributes:
          - oracle.db.pdb

      # === I/O & Physical Read/Write Metrics ===
      oracledb.logical_reads:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.physical_reads:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.physical_reads_direct:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.physical_writes:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.physical_writes_direct:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.physical_read_io_requests:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.physical_write_io_requests:
        enabled: true
        attributes:
          - oracle.db.pdb

      # === New Physical I/O Metrics (detailed) ===
      oracledb.physical_io.cache_writes:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.physical_io.requests:
        enabled: true
        attributes:
          - disk.io.direction
          - disk.io.block_size
          - oracle.db.pdb
      oracledb.physical_io.transferred:
        enabled: true
        attributes:
          - disk.io.direction
          - disk.io.type
          - oracle.db.pdb

      # === Network I/O Metrics ===
      oracledb.sqlnet.io.transferred:
        enabled: true
        attributes:
          - network.io.direction
          - destination.type
          - oracle.db.pdb

      # === Buffer & Cache Metrics ===
      oracledb.consistent_gets:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.db_block_gets:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.buffer_cache.utilization:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.library_cache.utilization:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.data_dictionary.hit_ratio:
        enabled: true
      oracledb.shared_pool.utilization:
        enabled: true
        attributes:
          - oracle.db.pdb

      # === Memory Metrics ===
      oracledb.pga_memory:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.sga.limit:
        enabled: true
      oracledb.sga.usage:
        enabled: true
        attributes:
          - oracledb.sga.component.name

      # === Wait & Database Time Metrics ===
      oracledb.database.wait.utilization:
        enabled: true
        attributes:
          - oracle.db.pdb

      # === Lock & Deadlock Metrics ===
      oracledb.dml_locks.limit:
        enabled: true
      oracledb.dml_locks.usage:
        enabled: true
      oracledb.enqueue_locks.limit:
        enabled: true
      oracledb.enqueue_locks.usage:
        enabled: true
      oracledb.enqueue_resources.limit:
        enabled: true
      oracledb.enqueue_resources.usage:
        enabled: true
      oracledb.enqueue_deadlocks:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.exchange_deadlocks:
        enabled: true
        attributes:
          - oracle.db.pdb

      # === Process & Session Metrics ===
      oracledb.processes.limit:
        enabled: true
      oracledb.processes.usage:
        enabled: true
      oracledb.sessions.limit:
        enabled: true
      oracledb.sessions.usage:
        enabled: true
        attributes:
          - session_type
          - session_status
          - oracle.db.pdb
      oracledb.logons:
        enabled: true
        attributes:
          - oracle.db.pdb

      # === Transaction Metrics ===
      oracledb.transactions.limit:
        enabled: true
      oracledb.transactions.usage:
        enabled: true
      oracledb.user_commits:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.user_rollbacks:
        enabled: true
        attributes:
          - oracle.db.pdb

      # === Tablespace Metrics ===
      oracledb.tablespace_size.limit:
        enabled: true
        attributes:
          - tablespace_name
          - oracle.db.pdb
      oracledb.tablespace_size.usage:
        enabled: true
        attributes:
          - tablespace_name
          - oracle.db.pdb

      # === Storage Metrics ===
      oracledb.storage.usage:
        enabled: true
      oracledb.storage.utilization:
        enabled: true
      oracledb.recycle_bin.limit:
        enabled: true

      # === Parallel Operations Metrics ===
      oracledb.queries_parallelized:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.ddl_statements_parallelized:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.dml_statements_parallelized:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.parallel_operations_not_downgraded:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.parallel_operations_downgraded_1_to_25_pct:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.parallel_operations_downgraded_25_to_50_pct:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.parallel_operations_downgraded_50_to_75_pct:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.parallel_operations_downgraded_75_to_99_pct:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.parallel_operations_downgraded_to_serial:
        enabled: true
        attributes:
          - oracle.db.pdb

      # === Redo & Sort Metrics ===
      oracledb.redo_allocation.utilization:
        enabled: true
        attributes:
          - oracle.db.pdb
      oracledb.sort.ratio:
        enabled: true
        attributes:
          - oracledb.sort.type
          - oracle.db.pdb

      # === Response Time Metrics ===
      oracledb.sql_service.response.duration:
        enabled: true
        attributes:
          - oracle.db.pdb

    # Resource attributes attached to all metrics/logs
    resource_attributes:
      host.name:
        enabled: true
      oracle.db.hosting_type:
        enabled: true
      oracle.db.open_mode:
        enabled: true
      oracle.db.pdb:
        enabled: true
      oracle.db.role:
        enabled: true
      oracle.db.version:
        enabled: true
      oracledb.instance.name:
        enabled: true
      service.instance.id:
        enabled: true

  # First CDB's PDB configuration
  nroracledb/pdb1:
    <<: *nroracledb-common
    service: "<YOUR_PDB1_SERVICE_NAME>"

  # Second CDB configuration
  nroracledb/cdb2:
    <<: *nroracledb-common
    endpoint: "<YOUR_DB2_HOST>:<YOUR_DB2_PORT>"
    service: "<YOUR_CDB2_SERVICE_NAME>"

  # Second CDB's PDB configuration
  nroracledb/pdb2:
    <<: *nroracledb-common
    endpoint: "<YOUR_DB2_HOST>:<YOUR_DB2_PORT>"
    service: "<YOUR_PDB2_SERVICE_NAME>"

processors:
  batch:
  resource/add_event_name:
    attributes:
      - key: host.address
        value: "<host_address>"
        action: upsert

exporters:
  otlp/newrelic:
    endpoint: "<otlp_endpoint>"
    headers:
      api-key: "<license_key>"
    compression: gzip
    retry_on_failure:
      enabled: true
      initial_interval: 5s
      max_interval: 30s
      max_elapsed_time: 300s

service:
  pipelines:
    metrics/oracledb:
      receivers: [nroracledb/cdb1, nroracledb/pdb1, nroracledb/cdb2, nroracledb/pdb2]
      processors: [resource/add_event_name, batch]
      exporters: [otlp/newrelic]
    logs/oracledb:
      receivers: [nroracledb/cdb1, nroracledb/pdb1, nroracledb/cdb2, nroracledb/pdb2]
      processors: [resource/add_event_name, batch]
      exporters: [otlp/newrelic]