Complimentary Gartner® Report! 'A CTO's Guide to Open-Source Software: Answering the Top 10 FAQs.'Read more

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.

sql
1-- Create the monitoring user "bindplane"
2  CREATE USER bindplane IDENTIFIED BY <authentication password>;
3
4  -- Grant the "bindplane" user the required permissions
5  GRANT CONNECT TO bindplane;
6  GRANT SELECT ON SYS.GV_$DATABASE to bindplane;
7  GRANT SELECT ON SYS.GV_$INSTANCE to bindplane;
8  GRANT SELECT ON SYS.GV_$PROCESS to bindplane;
9  GRANT SELECT ON SYS.GV_$RESOURCE_LIMIT to bindplane;
10  GRANT SELECT ON SYS.GV_$SYSMETRIC to bindplane;
11  GRANT SELECT ON SYS.GV_$SYSSTAT to bindplane;
12  GRANT SELECT ON SYS.GV_$SYSTEM_EVENT to bindplane;
13  GRANT SELECT ON SYS.V_$RMAN_BACKUP_JOB_DETAILS to bindplane;
14  GRANT SELECT ON SYS.V_$SORT_SEGMENT to bindplane;
15  GRANT SELECT ON SYS.V_$TABLESPACE to bindplane;
16  GRANT SELECT ON SYS.V_$TEMPFILE to bindplane;
17  GRANT SELECT ON SYS.DBA_DATA_FILES to bindplane;
18  GRANT SELECT ON SYS.DBA_FREE_SPACE to bindplane;
19  GRANT SELECT ON SYS.DBA_TABLESPACE_USAGE_METRICS to bindplane;
20  GRANT SELECT ON SYS.DBA_TABLESPACES to bindplane;
21  GRANT SELECT ON SYS.GLOBAL_NAME to bindplane;

Configuration Table

ParameterTypeDefaultDescription
telemetry_typestelemetrySelector["Logs", "Metrics"]Choose Telemetry Type.
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 the file from the 'beginning' or 'end'.
hoststringlocalhostHost to scrape metrics from.
portint1521Port of the 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_intervalint60Sets how often (seconds) to scrape for metrics.
enable_audit_logbooltrueEnable to collect audit logs.
*required field