Enable Database Management for HeatWave

Database Management is automatically enabled for a DB system when it's created in the HeatWave service. If Database Management is not enabled for a HeatWave DB system, you can enable it in the HeatWave service interface or on the MySQL DB systems page in Database Management.

For information on how to:

Note that before you enable Database Management for a DB system in the HeatWave service or on the MySQL DB systems page in Database Management, you must ensure that you have the required permissions. For information, see Permissions Required to Enable Database Management for HeatWave.

To enable Database Management for HeatWave DB systems on the MySQL DB systems page:

  1. Sign in to the Oracle Cloud Infrastructure console.
  2. Open the navigation menu, click Observability & Management. Under Database Management, click Administration.
  3. On the left pane, click MySQL Databases, select a compartment in the Compartment drop-down list and HeatWave in the Deployment type filter.

    The Heatwave DB systems in the compartment are listed. To further filter the list of Heatwave DB systems to only view those without Database Management enabled, use the Management status filter on the left pane.

  4. In the Management status column, click Enable Database Management for the HeatWave DB system.
  5. In the Database Management panel, select a Database Management monitoring option for HeatWave DB systems:
    • Full monitoring: This option includes advanced Database Management monitoring features at an additional cost. In addition to the features available as part of the Basic monitoring option, the Full monitoring option includes the full set of advanced monitoring metrics, Performance Hub, replication monitoring, and other features.
    • Basic monitoring: This option is available at no additional cost and includes fleet management, basic monitoring metrics, SQL monitoring in Performance Hub, and configuration variable monitoring.
  6. Click Submit.

A confirmation message with a link to the Work requests page is displayed. Click the Work Request link to monitor the progress of the work request. After Database Management is successfully enabled, Enabled (<monitoring option>) is displayed in the Management status column.

You can click Manage in the Management status column to perform the following tasks in the Database Management panel:

  • Change the monitoring option selected when enabling Database Management.
    Note

    When Database Management is automatically enabled for a new DB system in the HeatWave service, the Basic monitoring option is selected by default. However, you can click Manage and change the monitoring option to Full monitoring.
  • Disable Database Management.