Oracle Database

Supported Platforms

PlatformMetricsLogsTraces
Linux
Windows
macOS

Metrics Requirements

To collect metrics from OracleDB, a user with SELECT access to the relevant views is required. To create a new user with those permissions, run the following SQL script as a user with sufficient permissions connected to the Oracle DB instance as SYSDBA or SYSOPER.

  -- Create the monitoring user "bindplane"
  CREATE USER bindplane IDENTIFIED BY <authentication password>;

  -- Grant the "bindplane" user the required permissions
  GRANT CONNECT TO bindplane;
  GRANT SELECT ON SYS.GV_$DATABASE to bindplane;
  GRANT SELECT ON SYS.GV_$INSTANCE to bindplane;
  GRANT SELECT ON SYS.GV_$PROCESS to bindplane;
  GRANT SELECT ON SYS.GV_$RESOURCE_LIMIT to bindplane;
  GRANT SELECT ON SYS.GV_$SYSMETRIC to bindplane;
  GRANT SELECT ON SYS.GV_$SYSSTAT to bindplane;
  GRANT SELECT ON SYS.GV_$SYSTEM_EVENT to bindplane;
  GRANT SELECT ON SYS.V_$RMAN_BACKUP_JOB_DETAILS to bindplane;
  GRANT SELECT ON SYS.V_$SORT_SEGMENT to bindplane;
  GRANT SELECT ON SYS.V_$TABLESPACE to bindplane;
  GRANT SELECT ON SYS.V_$TEMPFILE to bindplane;
  GRANT SELECT ON SYS.DBA_DATA_FILES to bindplane;
  GRANT SELECT ON SYS.DBA_FREE_SPACE to bindplane;
  GRANT SELECT ON SYS.DBA_TABLESPACE_USAGE_METRICS to bindplane;
  GRANT SELECT ON SYS.DBA_TABLESPACES to bindplane;
  GRANT SELECT ON SYS.GLOBAL_NAME to bindplane;

Configuration Table

ParameterTypeDefaultDescription
enable_metricsbooltrueEnable to collect metrics.
hoststringlocalhostHost to scrape metrics from.
portint1521Port of host to scrape metrics from.
username*stringDatabase user to run metric queries with.
passwordstringPassword for user.
sidstringSite Identifier. One or both of sid or service_name must be specified.
service_namestringOracleDB Service Name. One or both of sid or service_name must be specified.
walletstringOracleDB Wallet file location (must be URL encoded).
collection_intervalint60How often (seconds) to scrape for metrics.
enable_logsbooltrueEnable to collect logs.
enable_audit_logbooltrueEnable to collect audit logs.
audit_log_pathstrings"/u01/app/oracle/product//dbhome_1/admin//adump/*.aud"File paths to audit logs.
enable_alert_logbooltrue
alert_log_pathstrings"/u01/app/oracle/product//dbhome_1/diag/rdbms//_/trace/alert__.log"File paths to alert logs.
enable_listener_logbooltrue
listener_log_pathstrings"/u01/app/oracle/product//dbhome_1/diag/tnslsnr//listener/alert/log.xml"File paths to listener logs.
start_atenumendStart reading file from 'beginning' or 'end'.

*required field