What is an Oracle Database?
An Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW), and mixed (OLTP & DW) database workloads.
Oracle Database software is distributed under a proprietary license and is known for its feature-rich capabilities, scalability, and robustness, making it a popular choice for large enterprise applications.
How to monitor an Oracle Database?
ServicePilot makes it easy to monitor an Oracle Database requiring only a DB account with read privileges. Simply add a resource from the ServicePilot database-oracle package to your monitoring environment.
The statistics collected this way include:
- Process indicators: availability for each critical oracle process (SMON, PMON, LGWR , DBWR, CKPT, ...)
- System: raw data system indicators and Performance Management Ratio as defined by Oracle (logons cumulative, logons current, ...)
- TableSpace: size and usage of the tablespaces instance
How to install a oracle resource?
- Use your ServicePilot OnPremise installation or a SaaS account.
- Add a new oracle resource via the web interface (
/prmresources) or via API (
/prmpackagespage), the default ServicePilot agent or another agent will be provisioned automatically.
Details of the oracle package are located in the
/prmpackagespage of the software.
ServicePilot enables you to deliver IT services faster and more securely with automated discovery and advanced monitoring features.
By correlating the technology ORACLE with APM and infrastructure monitoring, ServicePilot is able to provide a more comprehensive view of an organization's IT environment.
This allows IT teams to quickly identify and diagnose issues that may be impacting application performance, and take corrective action before end-users are affected.