Oracle Pro 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 Pro Monitoring features
WhaTab's Oracle Pro monitoring products presents an innovation that goes beyond the traditional query-based data collection. Traditional query-based approaches place significant load on the database server, which can cause system performance degradation. This approach uses the Direct Memory Access (DMA) technique to directly access the server's memory and extract the required data, thereby placing little load on the database server. This is a huge advantage, especially in high-performance database environments.
Additionally, query-based collection methods have long data update cycles and can collect data only at specific query execution times. In comparison, the Oracle Pro monitoring can collect data almost in real time through memory access, and can collect sessions and SQL performance data at an interval of at least 0.01 seconds. This allows database administrators to monitor the system performance more precisely and respond immediately when any problem occurs.
Another important feature of the Oracle Pro monitoring product is that data collection is not interrupted even in a system failure or hang. Data collection in these scenarios can be difficult using traditional query-based approaches. By using Oracle Pro, database administrators can ensure data continuity under any circumstances, thereby maximizing the stability and availability of the system.
Ultimately, WhaTab's Oracle Pro monitoring product is an essential technology for improving the efficiency and accuracy of database monitoring, while minimizing system load and ensuring business continuity. This provides a foundation for companies to make faster, more accurate, and more reliable decisions.
-
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 | ✅ |