AWS RDS Oracle
Collect AWS RDS Oracle asset and monitoring data.
Configuration¶
Install Func¶
Enable hosted Func under Integration - Extensions in Guance. All prerequisites are installed automatically; proceed with script installation.
To deploy Func yourself, see Self-hosted Func Deployment
Enable the Script¶
Note: Prepare an AWS AK with the required permissions in advance. For simplicity, you can grant the global read-only policy
ReadOnlyAccess.
Enable the Script in Hosted Func¶
- Log in to the Guance console.
- Open the Integration menu and select Cloud Account Management.
- Click Add Cloud Account, select AWS, and enter the required information. Skip this step if the cloud account is already configured.
- Click Test, then click Save if the test succeeds. If it fails, check the configuration and test again.
- In Cloud Account Management, locate the added cloud account and click it to open its details page.
- Click Integration on the cloud account details page. Under
Not Installed, findAWS RDS Oracle, click Install, and complete the installation in the dialog.
Enable the Script Manually¶
- Log in to the Func console, open Script Market, enter the Guance script market, and search for
integration_aws_rds_oracle - Click Install and enter AWS AK ID, AK Secret, and the account name.
- Click Deploy Startup Script. The system automatically creates a
Startupscript set and configures the startup script. - After activation, find the trigger under Management / Automatic Trigger Configuration. Click Execute to run it immediately without waiting for the schedule. After a short wait, check the task execution records and logs.
Verification¶
- Under Management / Automatic Trigger Configuration, confirm that the task has a trigger configured. Check the task records and logs for errors.
- In Guance, check for asset information under Infrastructure / Custom.
- In Guance, check Metrics for the corresponding monitoring data.
Metrics¶
Configure Amazon CloudWatch to collect additional metrics: Amazon CloudWatch Metric Details
AWS RDS Oracle metrics use the aws_AWS/RDS measurement. The description column explains each metric, including its units and statistics.
| MetricName | MetricDescribe | Dimensions | Unit |
|---|---|---|---|
CPUCreditUsage_Sum |
CPU credits consumed; applies to db.t3 instances and is published every 5 minutes | DBInstanceIdentifier | Credits (vCPU minutes) |
CPUUtilization_Average |
CPU utilization | DBInstanceIdentifier | percent |
DatabaseConnections_Average |
Client database connections | DBInstanceIdentifier | count |
DBLoad_Average |
Average active sessions; published only when the instance has load | DBInstanceIdentifier | - |
DBLoadCPU_Average |
Active sessions with the CPU wait type; published only when the instance has load | DBInstanceIdentifier | - |
DBLoadNonCPU_Average |
Active sessions with non-CPU wait types; published only when the instance has load | DBInstanceIdentifier | - |
DBLoadRelativeToNumVCPUs_Average |
Ratio of database load to vCPU count; published only when the instance has load | DBInstanceIdentifier | - |
DiskQueueDepth_Average |
I/O requests waiting for disk reads or writes | DBInstanceIdentifier | count |
FreeStorageSpace_Average |
Available storage space | DBInstanceIdentifier | B |
FreeableMemory_Average |
Available memory | DBInstanceIdentifier | B |
NetworkReceiveThroughput_Average |
Rate of network traffic received by the instance, including client, monitoring, and replication traffic | DBInstanceIdentifier | B/S |
NetworkTransmitThroughput_Average |
Rate of network traffic sent by the instance, including client, monitoring, and replication traffic | DBInstanceIdentifier | B/S |
ReadIOPS_Average |
Disk read operations per second | DBInstanceIdentifier | iops |
ReadLatency_Average |
Average duration of disk read operations | DBInstanceIdentifier | s |
ReplicaLag_Average |
Replication lag of the read replica relative to the source database | DBInstanceIdentifier | s |
SwapUsage_Average |
Swap space used | DBInstanceIdentifier | B |
WriteIOPS_Average |
Disk write operations per second | DBInstanceIdentifier | iops |
WriteLatency_Average |
Average duration of disk write operations | DBInstanceIdentifier | s |
total_storage_space |
Total storage capacity allocated to the database instance | DBInstanceIdentifier | B |