cloud_vm_cluster_iorm_configs
Creates, updates, deletes, gets or lists a cloud_vm_cluster_iorm_configs resource.
Overview​
| Name | cloud_vm_cluster_iorm_configs |
| Type | Resource |
| Id | oci.database.cloud_vm_cluster_iorm_configs |
Fields​
The following fields are returned by SELECT queries:
- get
An object containing the list of databases in the specified cloud VM cluster and their IORM settings.
| Name | Datatype | Description |
|---|---|---|
dbPlans | array | An array of IORM settings for all the database in the Exadata DB system. |
lifecycleDetails | string | Additional information about the current lifecycleState. |
lifecycleState | string | The current state of IORM configuration for the Exadata DB system. (BOOTSTRAPPING, ENABLED, DISABLED, UPDATING, FAILED) |
objective | string | The current value for the IORM objective. The default is AUTO. (LOW_LATENCY, HIGH_THROUGHPUT, BALANCED, AUTO, BASIC) |
Methods​
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | cloudVmClusterId, region | opc-request-id | Gets the IORM configuration for the specified cloud VM cluster in an Exadata Cloud Service instance.<br />If you have not specified an IORM configuration, the default configuration is returned.<br /> |
update | update | cloudVmClusterId, region | opc-request-id, if-match | Updates the IORM settings for the specified cloud VM cluster in an Exadata Cloud Service instance.<br /> |
Parameters​
Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.
| Name | Datatype | Description |
|---|---|---|
cloudVmClusterId | string | The cloud VM cluster [OCID](/Content/General/Concepts/identifiers.htm). |
region | string | OCI region identifier (e.g. us-ashburn-1, ap-sydney-1); resolves from OCI_REGION when not supplied in the query. (default: us-ashburn-1, x-stackQL-envVar: OCI_REGION) |
if-match | string | For optimistic concurrency control. In the PUT or DELETE call for a resource, set the if-match parameter to the value of the etag from a previous GET or POST response for that resource. The resource will be updated or deleted only if the etag you provide matches the resource's current etag value. |
opc-request-id | string | Unique identifier for the request. |
SELECT examples​
- get
Gets the IORM configuration for the specified cloud VM cluster in an Exadata Cloud Service instance.<br />If you have not specified an IORM configuration, the default configuration is returned.<br />
SELECT
dbPlans,
lifecycleDetails,
lifecycleState,
objective
FROM oci.database.cloud_vm_cluster_iorm_configs
WHERE cloudVmClusterId = '{{ cloudVmClusterId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
;
UPDATE examples​
- update
Updates the IORM settings for the specified cloud VM cluster in an Exadata Cloud Service instance.<br />
UPDATE oci.database.cloud_vm_cluster_iorm_configs
SET
dbPlans = '{{ dbPlans }}',
objective = '{{ objective }}'
WHERE
cloudVmClusterId = '{{ cloudVmClusterId }}' --required
AND region = '{{ region }}' --required
AND opc-request-id = '{{ opc-request-id}}'
AND if-match = '{{ if-match}}'
RETURNING
dbPlans,
lifecycleDetails,
lifecycleState,
objective;