OracleDB integration for Grafana Cloud
OracleDB is an enterprise SQL Database system by Oracle Corporation. The OracleDB integration uses the Grafana Agent to collect metrics and alert logs for monitoring an OracleDB instance. Including metrics such as virtual memory usage, open file descriptors, sessions, processes, database wait times, and tablespace usage.
This integration allows you to monitor the alert log of an OracleDB instance which contains valuable information for usage and operations of the instance.
It also supports metrics provided by v0.0.1 of a third party OracleDB exporter, which is integrated into the Grafana Agent.
Pre-install configuration for the OracleDB integration
In the agent configuration file, you must provide a connection string which has credentials with permissions to run queries.
To create a user with the SQL permissions required for the monitoring user “grafanau”.
-- Create the monitoring user "grafanau"
CREATE USER grafanau IDENTIFIED BY <YOUR-PASSWORD>;
-- Grant the "grafanau" user the required permissions
GRANT CONNECT TO grafanau;
GRANT SELECT ON SYS.GV_$RESOURCE_LIMIT to grafanau;
GRANT SELECT ON SYS.V_$SESSION to grafanau;
GRANT SELECT ON SYS.V_$WAITCLASSMETRIC to grafanau;
GRANT SELECT ON SYS.GV_$PROCESS to grafanau;
GRANT SELECT ON SYS.GV_$SYSSTAT to grafanau;
GRANT SELECT ON SYS.V_$DATAFILE to grafanau;
GRANT SELECT ON SYS.V_$ASM_DISKGROUP_STAT to grafanau;
GRANT SELECT ON SYS.V_$SYSTEM_WAIT_CLASS to grafanau;
GRANT SELECT ON SYS.DBA_TABLESPACE_USAGE_METRICS to grafanau;
GRANT SELECT ON SYS.DBA_TABLESPACES to grafanau;
GRANT SELECT ON SYS.GLOBAL_NAME to grafanau;
Install OracleDB integration for Grafana Cloud
- In your Grafana Cloud instance, click Integrations and Connections (lightning bolt icon).
- Navigate to the OracleDB tile and review the prerequisites. Then click Install integration.
- Once the integration is installed, follow the steps on the Configuration Details page to setup Grafana Agent and start sending OracleDB metrics to your Grafana Cloud instance.
Post-install configuration for the OracleDB integration
Integration configuration can be specified via the OracleDB integration.
oracledb:
enabled: true
connection_string: oracle://grafanau:<YOUR-PASSWORD>@localhost:1521/orcl.localnet
scrape_interval: 1m
scrape_timeout: 1m
scrape_integration: true
max_idle_connections: 0
max_open_connections: 10
query_timeout: 5
Dashboards
The OracleDB integration installs the following dashboard in your Grafana Cloud instance to help monitor your metrics.
- OracleDB overview
OracleDB overview dashboard
Alerts
The OracleDB integration includes the following useful alerts:
Group: OracleDBAlerts
| Alert | Description |
|---|---|
| OracledbReachingSessionLimit | Critical: The number of sessions being utilized exceeded 85%. |
| OracledbReachingProcessLimit | Critical: The number of processess being utilized exceeded the threshold of 85%. |
| OracledbTablespaceReachingCapacity | Critical: A tablespace is exceeding more than 85% of its maximum allotted space. |
Metrics
The following metrics are automatically written to your Grafana Cloud instance by connecting your Node.js instance through this integration:
- oracledb_resource_current_utilization
- oracledb_resource_limit_value
- oracledb_tablespace_bytes
- oracledb_tablespace_free
- oracledb_tablespace_max_bytes
- oracledb_up
- oracledb_wait_time_application
- oracledb_wait_time_commit
- oracledb_wait_time_concurrency
- oracledb_wait_time_configuration
- oracledb_wait_time_network
- oracledb_wait_time_scheduler
- oracledb_wait_time_system_io
- oracledb_wait_time_user_io
Changelog
# 0.0.1 - February 2023
- Initial release
Cost
By connecting your OracleDB instance to Grafana Cloud you might incur charges. To view information on the number of active series that your Grafana Cloud account uses for metrics included in each Cloud tier, see Active series and dpm usage and Cloud tier pricing.
