Viewing HeatWave Cluster Information
The HeatWave cluster information give details about a HeatWave cluster and its nodes. The HeatWave cluster state shows whether a HeatWave cluster active or not.
- Using the Console
- Using the REST API, run the GetHeatWaveCluster operation.
Using the Console
Use the Console to view the HeatWave cluster information if the DB system has HeatWave cluster enabled.
- Open the navigation menu and select Databases. Under HeatWave MySQL, click DB Systems.
- Choose your compartment from the List scope.
- In the HeatWave cluster filter, select Attached to filter the DB systems that have a HeatWave cluster attached.
- In the list of DB systems, find your DB system, and check the icon in the HeatWave cluster state column. The color of the icon and the associated text indicate the status of the HeatWave cluster. See HeatWave Cluster States.
- Click the name of the DB system to open the DB system details page.
- From the menu at the top of the page, select HeatWave cluster details.
The HeatWave cluster page is displayed.
HeatWave cluster
The HeatWave cluster page shows information related to the HeatWave cluster and nodes. You can view and manage the HeatWave cluster.
Table 11-3 HeatWave cluster page
| Tab or resource | Description |
|---|---|
| Details | Summary information about the HeatWave cluster and its configuration. |
| Metrics | Measurements such as the CPU and memory utilization of the HeatWave cluster. See HeatWave Cluster Metrics. |
| HeatWave cluster nodes | Summary information about the nodes in the cluster. |
| Work requests | Activity logs for ongoing and recent operations on the DB system. Work requests are retained for 12 hours. See Resource: Work Requests. |
Table 11-4 HeatWave cluster information
| Field | Description |
|---|---|
| Shape | The shape used for HeatWave cluster nodes. |
| Nodes | The number of nodes in the cluster. |
| Memory | The amount of RAM allocated to the HeatWave cluster, which depends on the number of nodes you select. |
| HeatWave Lakehouse | Displays whether HeatWave HeatWave Lakehouse is enabled or disabled. |
| Created | The date and time the HeatWave cluster was created. |
| Last updated | The date and time the HeatWave cluster was last updated. |
Table 11-5 HeatWave cluster nodes
| Column | Description |
|---|---|
| Node Id | The name of the HeatWave node. |
| State | Current state of the HeatWave node. See HeatWave Cluster States. |
| Created | The date and time the HeatWave node was created. |
HeatWave Cluster States
Check the HeatWave cluster state column to view the state of the HeatWave cluster.
Table 11-6 HeatWave Cluster States
| HeatWave cluster state | Description |
|---|---|
| Failed | An error condition prevented the creation or continued operation of the HeatWave cluster. |
| Creating | HeatWave is reserving resources, booting, and creating the HeatWave cluster. Provisioning can take several minutes. You cannot use the cluster yet. |
| Deleting | The HeatWave cluster is being deleted by the terminate action in the Console or API. |
| Inactive | The HeatWave cluster is powered off by the stop or reboot action in the Console or API, or on rare occasions when there is a failure. |
| Updating | The HeatWave cluster is starting, stopping, restarting, or updating. |
| Active | The HeatWave cluster is successfully created. |