Database Autonomy Service (DAS) can automatically detect Autonomy Events—including Auto Scaling, throttling, SQL optimization, space optimization, metric anomalies, and slow query log count anomalies—and send alerts to designated contacts. Slow query log alerting supports both intelligent detection and threshold-based detection, so you can tune alert sensitivity to match the workload of each instance.
How it works
DAS runs the following pipeline to detect and report Autonomy Events:
Data collection: The DAS Agent continuously collects performance data from the database instance, including slow query logs and active sessions.
Baseline analysis: The DAS backend processes the collected data to build dynamic performance baselines for each metric.
Anomaly detection: Incoming real-time data is compared against the baselines. Events that deviate from the normal range are classified as Autonomy Events.
Rule matching: Each Autonomy Event is matched against the rules defined in the alert template.
Notification: When a match is found, DAS sends an alert to the associated contact group.
Key concepts
| Concept | Description |
|---|---|
| Alert rule | Defines the conditions for triggering an alert, including the alert metric, trigger times, and notification channels. See Configure alert rules. |
| Alert template | A collection of alert rules. A single alert rule can belong to multiple templates. See Configure alert templates. |
| Alert contact | The person who receives alert notifications. Contacts are organized into contact groups for reuse across multiple alert configurations. See Manage alert contacts. |
Prerequisites
Before you begin, ensure that you have:
Access to the DAS console
A database instance to monitor in DAS
Configure alerting
Setting up alerting involves two tasks:
Configure an alert template with the rules for Autonomy Events.
Associate the template with a contact group and the target database instance.
Configure an alert template
Alert templates let you define a reusable set of alert rules that you can apply to multiple instances.
Log on to the DAS console.
In the left navigation pane, click Instance Monitoring.
On the Instance Monitoring page, click the tab for your database instance type. In the instance list, click the instance ID to open its details page.
In the left navigation pane, click Instance Alerts.
Click the Configuration Information tab.
If the instance has no associated alert templates, the following message appears: This instance is not associated with any alert templates. Click here to Configure Alert.
Click Configure Alert to open the Select Alert Template page.
Select an existing template, or click Create Alert Template to create a new one.
In the selected template, click Add Rule, then click Create Rule. In the Create Rule dialog box, configure the rules for Autonomy Events. Select the rules you added and click OK.
Click Next.
Associate the alert template
To activate the alert rules, associate the template with a contact group and the target database instance. Contact groups are reusable, so you can apply the same group across multiple alert configurations.
On the Select Alert Contact Group page, select an existing contact group or click Create Contact Group. In the dialog box, enter a name for the group and click OK.
In the contact group, click Add Contact to add contacts. Select existing contacts or click Create Contact to add a new one.
Click Next.
On the Associate with Resources page, review the configuration and click Submit Configuration.
Verify
After the configuration is complete, the specified contacts receive an alert notification each time the instance triggers an Autonomy Event that matches a rule in the template.