Alibaba Cloud PolarDB for Oracle Monitoring Integration
Site24x7 provides comprehensive monitoring for Alibaba Cloud PolarDB for Oracle, giving detailed insights into storage consumption, block usage, inode utilization, and connection activity. By monitoring data size, session utilization, and idle connections, Site24x7 helps maintain database stability and optimize resource usage. Once your Alibaba Cloud account is integrated with Site24x7, all PolarDB for Oracle instances are automatically discovered and monitored.
Use cases
- Storage management: Track data size, block usage, and inode consumption to prevent resource exhaustion.
- Connection monitoring: Monitor active and idle sessions to prevent connection saturation.
- Resource optimization: Identify storage or connection bottlenecks for scaling or cleanup.
- Automation and alerts: Configure thresholds and IT automation for proactive issue resolution.
Setup and configuration
- Log in to your Site24x7 account and navigate to Cloud > Alibaba Cloud > Add Monitor.
- In the Edit Alibaba Cloud Monitor page, select PolarDB for Oracle from the Service Types list.
- Once added, go to Cloud > Alibaba > PolarDB for Oracle to view dashboards and performance metrics.
Supported metrics
Compute & Memory
| Metric name | Description | Unit |
|---|---|---|
| Cluster CPU Utilization | The percentage of CPU utilization across the cluster. | Percentage |
| Cluster Memory Utilization | The percentage of memory used by the cluster. | Percentage |
| Total CPU Usage | Total CPU usage of the cluster. | Percentage |
| Memory Usage | Total memory usage of the cluster. | Percentage |
| Cluster PCU by CPU Cores | CPU usage per CPU core in the cluster. | Percentage |
| Cluster Proxy CPU Utilization | The CPU utilization of the cluster proxy layer. | Percentage |
Disk & I/O
| Metric name | Description | Unit |
|---|---|---|
| Cluster IOPS | The total number of I/O operations per second on the cluster. | Count/second |
| Cluster IOPS Usage | The percentage of IOPS utilization. | Percentage |
| Cluster Disk Utilization | Disk space utilization across cluster nodes. | Percentage |
| Cluster Data IOPS | IOPS specifically used for data reads/writes. | Count/second |
| Cluster Redo Write Rate | Rate of redo log writes in the cluster. | Bytes/second |
| Cluster Input Traffic | Inbound network traffic to the cluster. | Bytes/second |
| Cluster Output Traffic | Outbound network traffic from the cluster. | Bytes/second |
Connection & Session Utilization
| Metric name | Description | Unit |
|---|---|---|
| Total Connections | Total number of connections to the cluster. | Count |
| Active Connections | The number of currently active connections. | Count |
| Idle Connections | The number of idle connections in the cluster. | Count |
| Cluster Connection Utilization | Percentage of connection utilization across the cluster. | Percentage |
| Cluster Active Sessions | The number of active sessions on cluster nodes. | Count |
Throughput & Performance
| Metric name | Description | Unit |
|---|---|---|
| Cluster TPS | Transactions processed per second in the cluster. | Count/second |
| Cluster QPS | Queries executed per second in the cluster. | Count/second |
| TPS | Transaction rate for the cluster. | Count/second |
| Cluster Memory Hit Ratio | The memory hit ratio of the cluster. | Percentage |
Latency
| Metric name | Description | Unit |
|---|---|---|
| Swell Time | Time taken by queries experiencing execution delay. | Milliseconds |
| SQLs Executing > 5s | The number of queries executing longer than 5 seconds. | Count |
| SQLs Executing > 3s | The number of queries executing longer than 3 seconds. | Count |
| SQLs Executing > 1s | The number of queries executing longer than 1 second. | Count |
PolarDB for Oracle Metrics
| Metric name | Description | Unit |
|---|---|---|
| Oracle PLS Data Size Usage | The total size of data used in the PolarDB for Oracle cluster. | Bytes |
| Oracle PLS Block Usage | The total number of blocks currently utilized by the database. | Count |
| Oracle PLS Inode Usage | The total number of inodes in use within the database storage. | Count |
| Oracle Total Connections | The total number of active database connections. | Count |
| Oracle Idle Connections | The number of idle connections in the PolarDB for Oracle instance. | Count |
Threshold configuration
- Go to Admin > Configuration Profiles > Threshold and Availability.
- Create or edit a threshold profile for PolarDB for Oracle.
- Assign the profile to the respective monitors to trigger alerts.
IT automation
Site24x7's IT Automation tools help with automatically resolving performance degradation issues. When a breach occurs, the alarm engine continuously examines the system events for which thresholds have been defined and performs the mapped automation.
- Go to Admin > IT Automation Templates.
- Create a new automation rule.
- Map the rule to the monitor for proactive resolution.
How to configure IT Automation for a monitor
Configuration rules
With Site24x7's Configuration Rules, you can set parameters like Threshold Profile, Notification Profile, Tags, and Monitor Group for multiple monitors and automate the configuration settings of your monitoring resources. Automatically assign these settings when new PolarDB for Oracle monitors are added.
How to add a Configuration Rule