Oracle Database Monitoring and Performance Management
Database monitoring is an important part of Instana’s automated microservices application monitoring. Oracle Database is a popular relational database system developed by Oracle Corporation. The latest generation of Oracle Database is available on-prem, in Oracle’s cloud, or in a hybrid-Cloud environment. Oracle Database monitoring comes out of the box with Instana’s infrastructure and application monitoring solutions.
Configuring Instana’s Oracle Database Monitoring
Oracle Database monitoring is part of Instana’s automated Application Performance Monitoring solution.
When the Instana agent is deployed into an infrastructure containing Oracle Database, it automatically detects the technology but Instana cannot provide automatic Oracle monitoring for licensing reasons (because the driver jar may not be distributed by anybody except Oracle). Once you’ve downloaded and placed the driver jar file, the only further setup required is providing credentials and setting DB permissions to access the Oracle Database Monitoring information.
Oracle Database Performance and Configuration Monitoring
After Instana deploys its Oracle Database monitoring, it will immediately map out Oracle Database’s infrastructure. The Instana agent sends all data back to our Dynamic Graph model, which stores and contextualizes all collected monitoring data. Typical configuration data collected are:
- Started At
- CPU Count
- Max Sessions
- DB Block Size
Some example metrics collected are:
- DB Time per Second
- Time Waited per Second
- SQL Execution
- SQL Parse
- User Calls Commit Rollbacks
- Buffer Cache
- Tablespace Usage
A complete list is available in the Instana Oracle Database Monitoring Documentation.
Oracle Database Monitoring – Built-in Health Alerts
Instana tracks Oracle Database Key Performance Indicators to infer a health state about Oracle Database within the context of the monitored environment. Instana’s Dynamic Graph contains the contextual information needed to determine the root cause of Oracle Database problems.
Instana comes with multiple predefined health rules based upon expert knowledge and best practices. A few of these built in health rules are:
- Ratio between DB CPU Time and DB Time is low
- Tablespace space usage is high
- Total amount of sessions at maximum
If there is an issue with Oracle Database health or performance, the Instana UI will flag the issue and change the health color of the instance. If service is impacted, a Service Incident will also be created and an alert will be sent. Performance issues are correlated with all developer changes to help determine root cause.
Installing Instana’s Oracle Database Monitoring
Learn more about how to get started monitoring Oracle Database with Instana. You can either login to your account or start a trial.