Oracle Monitoring
The DB performance management monitors the database performance in real time, diagnoses and analyzes problems, tunes problematic SQLs, and monitors whether problems have been resolved.
The WhaTap database monitoring service is designed to manage a series of operations in cycles. It is configured to help maintain consistent levels of availability and performance by monitoring, diagnosing, and analyzing the database behaviors. When a problem occurs in the database, this service sends an alarm to the staff to recognize the situation and helps you identify the root cause by analyzing the database situation more precisely through the collected data.
Oracle Monitoring features
-
Realtime DB Monitoring
It collects real-time DB performance metrics and the data of running clients (active sessions). You can check the operation status at a glance to immediately recognize the load occurrence status, and you can immediately recognize any problems through alarm settings.
-
Specific point analysis
By using the metrics' short-term trends, long-term trends, and metric comparison functions, you can analyze problems at the past. The database parameter change history is traced.
-
Efficient structure even on a large scale
Even when managing multiple DB servers, it provides an optimal analysis environment through unified performance data collection and efficient data storage structure.
-
Cloud DB monitoring available
Structure for query-based monitoring data collection does not depend on the DB server type. DBs in AWS, GCP, Azure, and OCI environments can also be monitored, and monitoring for cloud resource metrics and integrated items is also possible.
-
Integrated Monitoring
If you have installed all applications, servers, and database monitoring products, you can quickly analyze the causes of failures through linked views when detecting service problems.
-
WhaTap SaaS
You can select from various database products, and freely set the period of use by monthly subscription. (available also with an installation type)
Supported functions
The following are available features. To compare with other products and supported features, see the following.
| Category | Function type | Oracle |
|---|---|---|
| Monitoring | Instance List | ✅ |
| Instance Monitoring | ✅ | |
| Multi DataBase (tenant) | ✅ 12c or later, in case of multi tenant | |
| Slow Query | ❌ | |
| Analysis | Trends | ✅ |
| Trends Compare | ✅ | |
| Lock Tree | ✅ | |
| Parallel Query Tree | ✅ | |
| Dead Lock | ❌ | |
| DB Parameters | ✅ | |
| Statistics | SQL Stat | ✅ |
| Table Size | Scheduled support | |
| Database (TableSpace) Size | ✅ | |
| SGA Size | ✅ | |
| Report | Daily/Weekly/Monthly Report | ✅ |
| Event | Event List | ✅ |
| Event Stat | ✅ | |
| Event Setting | ✅ | |
| Notification | ✅ | |
| Management | Agent Setup | ✅ |
| Agent List | ✅ | |
| Project Management | ✅ |