cat /opt/prom_exporters/database_exporter.yml
# Global defaults.
global:
  # Subtracted from Prometheus' scrape_timeout to give us some headroom and prevent Prometheus from timing out first.
  scrape_timeout_offset: 500ms
  # Minimum interval between collector runs: by default (0s) collectors are executed on every scrape.
  min_interval: 0s
  # Maximum number of open connections to any one target. Metric queries will run concurrently on multiple connections,
  # as will concurrent scrapes.
  max_connections: 3
  # Maximum number of idle connections to any one target. Unless you use very long collection intervals, this should
  # always be the same as max_connections.
  max_idle_connections: 3

jobs:
- job_name: main
  static_configs:
  - targets:
      instance: 'oracle://user/pass@host:1521/sid'

  collectors: [base]

# Collector files specifies a list of globs. One collector definition is read from each matching file.
collector_files:
  - '/opt/prom_exporters/config/oracle_collectors/*.collector.yml'

cat /opt/prom_exporters/config/oracle_collectors/oracle.collector.yml
# A collector defining standard metrics for Oracle Database Server.
#
#

collector_name: base

# Similar to global.min_interval, but applies to the queries defined by this collector only.
#min_interval: 0s

metrics:
  - metric_name: version
    type: gauge
    help: 'help'
    values:
      - VERSION
    query: |
      SELECT VERSION FROM DUAL;