Viewing Configuration Details
View the details of a configuration.
- Using the Console
- Using the CLI
- Using the REST API, run the GetConfiguration operation.
Using the Console
Use the Console to view the details of a configuration.
Configuration Details
The Configuration Details page lists all relevant information and functionality for the selected HeatWave Configuration.
The following information is displayed on the Configuration Information tab in the Configuration Details page:
Table 10-5 Configuration Information
| Field | Description |
|---|---|
| OCID | The unique identifier of the HeatWave configuration. |
| Description | Description of the HeatWave configuration. |
| Shape | The shape type the configuration is associated with. Each configuration can only be used with a specific shape.. |
| State | Lifecycle state. |
| Source Configuration | Name of the configuration this configuration is based on. If you created a new configuration, this field displays the name of the default configuration associated with the shape you selected. If you copied the configuration from an existing configuration, this field displays the name of the parent configuration. |
| Compartment | The compartment in which the configuration was created. |
| Type | The type of configuration, Default or Custom. Where Default is provided with the service, and Custom is user-created. |
| Created | The date and time the configuration was created. |
| Last Updated | The date and time the configuration was last updated. |
The following information is displayed under Variables resource in the Configuration Details page:
Table 10-6 Variables
| Field | Description |
|---|---|
| Name | The name of the variable. |
| Value | The value of the variable. User defined: whether the variable's value is user defined, or not. |
| Type | The type of the variable. For example, Integer, String, Enum, Boolean, and Set.
|
| Dynamic | The variable is dynamic or not. |
Note
The Console rounds large integer values that it reads from the Configuration to 16 significant digits. For example, 9223372036854775807 is rounded to 9223372036854776000.
The Console rounds large integer values that it reads from the Configuration to 16 significant digits. For example, 9223372036854775807 is rounded to 9223372036854776000.
The following information is displayed under Initialization variables resource in the Configuration Details page:
Table 10-7 Initialization variables
| Field | Description |
|---|---|
| Name | The name of the variable. |
| Value | The value of the variable. |
The following information is displayed under Associated DB Systems resource in the Configuration Details page:
Table 10-8 Associated DB Systems
| Field | Description |
|---|---|
| Name | The name of the DB system using this configuration. |
| State | The current state of the DB system. |
| High availability | Whether high availability is enabled or not. |
| Deleted protected | Whether the DB system is delete protected or not. |
| HeatWave cluster | Whether the DB system has a HeatWave cluster or not. |
| HeatWave cluster state | The state of the HeatWave cluster. |
| Created | The date and time the DB system was created. |
The following information is displayed under Associated replicas resource in the Configuration Details page:
Table 10-9 Associated replicas
| Field | Description |
|---|---|
| Name | The name of the read replica using this configuration. |
| State | The current state of the read replica. |
| DB system | The DB system of the read replica. |
| Address | The private IP address of the read replica |
| Created | The date and time the read replica was created. |
| Last updated | The date and time the read replica was last updated. |
Using the CLI
Use the command-line interface to view the details of a configuration.
This task requires the following:
- The OCID of a HeatWave configuration.
- A policy that permits you to view configuration details in the compartment or tenancy.
- A properly configured CLI installation and the requisite SSH keys. See Command Line Interface.
View the details of a configuration using the CLI:
If the command runs successfully, you get a response similar to the following, which shows the details of the configuration:
{
"data": {
"compartment-id": "ocid1.compartment.oc1..longAlphanumericString",
"defined-tags": {
"Oracle-Tags": {
"CreatedBy": "userName",
"CreatedOn": "2024-07-11T00:51:53.856Z"
}
},
"description": "This is a user defined descrption",
"display-name": "ConfigName",
"freeform-tags": {},
"id": "ocid1.mysqlconfiguration.oc1.longAlphanumericString",
"init-variables": {
"lower-case-table-names": "CASE_SENSITIVE"
},
"lifecycle-state": "ACTIVE",
"parent-configuration-id": "ocid1.mysqlconfiguration.oc1.longAlphanumericString",
"shape-name": "MySQL.2",
"time-created": "2024-07-11T00:51:53.866000+00:00",
"time-updated": "2024-07-11T00:51:53.866000+00:00",
"type": "CUSTOM",
"variables": {
"autocommit": true,
"big-tables": null,
"binlog-expire-logs-seconds": 3600,
"binlog-row-metadata": null,
"binlog-row-value-options": "PARTIAL_JSON",
"binlog-transaction-compression": null,
"completion-type": null,
"connect-timeout": 20,
"connection-memory-chunk-size": null,
"connection-memory-limit": null,
"cte-max-recursion-depth": null,
"default-authentication-plugin": null,
"foreign-key-checks": null,
"generated-random-password-length": null,
"global-connection-memory-limit": null,
"global-connection-memory-tracking": null,
"group-replication-consistency": "BEFORE_ON_PRIMARY_FAILOVER",
"information-schema-stats-expiry": null,
"innodb-buffer-pool-dump-pct": null,
"innodb-buffer-pool-instances": 4,
"innodb-buffer-pool-size": 9126805504,
"innodb-ddl-buffer-size": null,
"innodb-ddl-threads": null,
"innodb-ft-enable-stopword": null,
"innodb-ft-max-token-size": null,
"innodb-ft-min-token-size": null,
"innodb-ft-num-word-optimize": null,
"innodb-ft-result-cache-limit": 33554432,
"innodb-ft-server-stopword-table": null,
"innodb-lock-wait-timeout": null,
"innodb-log-writer-threads": null,
"innodb-max-purge-lag": null,
"innodb-max-purge-lag-delay": 300000,
"innodb-stats-persistent-sample-pages": null,
"innodb-stats-transient-sample-pages": null,
"interactive-timeout": null,
"local-infile": true,
"mandatory-roles": "public",
"max-allowed-packet": null,
"max-binlog-cache-size": 4294967296,
"max-connect-errors": null,
"max-connections": 1000,
"max-execution-time": null,
"max-heap-table-size": null,
"max-prepared-stmt-count": null,
"mysql-firewall-mode": null,
"mysql-zstd-default-compression-level": null,
"mysqlx-connect-timeout": null,
"mysqlx-deflate-default-compression-level": null,
"mysqlx-deflate-max-client-compression-level": null,
"mysqlx-document-id-unique-prefix": null,
"mysqlx-enable-hello-notice": null,
"mysqlx-idle-worker-thread-timeout": null,
"mysqlx-interactive-timeout": null,
"mysqlx-lz4-default-compression-level": null,
"mysqlx-lz4-max-client-compression-level": null,
"mysqlx-max-allowed-packet": null,
"mysqlx-min-worker-threads": null,
"mysqlx-read-timeout": null,
"mysqlx-wait-timeout": null,
"mysqlx-write-timeout": null,
"mysqlx-zstd-default-compression-level": null,
"mysqlx-zstd-max-client-compression-level": null,
"net-read-timeout": null,
"net-write-timeout": null,
"parser-max-mem-size": null,
"query-alloc-block-size": null,
"query-prealloc-size": null,
"regexp-time-limit": null,
"sort-buffer-size": null,
"sql-mode": null,
"sql-require-primary-key": true,
"sql-warnings": null,
"thread-pool-dedicated-listeners": null,
"thread-pool-max-transactions-limit": null,
"time-zone": "UTC",
"tmp-table-size": null,
"transaction-isolation": null,
"wait-timeout": null
}
},
"etag": "longAlphanumericString"
}