Database Autonomy Service:Autonomy center

Features

DAS monitors the core metrics of a database instance to detect exceptions. If an exception is detected, DAS checks sessions, SQL statements, and the capacity of the database instance to identify the cause. Then, DAS provides suggestions on how to optimize performance or mitigate losses. You can also authorize DAS to automatically optimize performance or mitigate losses.

The features include:

• Anomaly detection

• SQL throttling

• Automatic SQL throttling

• Automatic SQL optimization

• Automatic performance scaling

• Automatic space expansion

• Automatic tablespace fragment recycling

• Abnormal SQL request identification

Procedure

1. Log on to the DAS console.

2. In the left-side navigation pane, click Instance Monitoring.

3. On the page that appears, find the database instance that you want to manage and click the instance ID. The instance details page appears.

4. On the instance details page, click Autonomy Center in the left-side navigation pane.

5. On the Autonomy Center tab, click Autonomy Service Settings in the upper-right corner.

6. On the Autonomous Function Settings tab of the Autonomous Function Management panel, enable the autonomy service and click OK.

7. On the Autonomy Center tab, specify a time range and view the events that occurred within the specified time range.

   • The trend chart displays the duration of the events and the variations in the major metrics of the database instance during the events.

   • Find the event that you want to view and click Details.

FAQ

A: The database instance does not support the features of the DAS autonomy center.