exadata_iorm_configs
Creates, updates, deletes, gets or lists an exadata_iorm_configs resource.
Overview​
| Name | exadata_iorm_configs |
| Type | Resource |
| Id | oci.database.exadata_iorm_configs |
Fields​
The following fields are returned by SELECT queries:
- get
The IORM configuration was retrieved.
| 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 | dbSystemId, region | opc-request-id | Gets the IORM configuration settings for the specified cloud Exadata DB system.<br />All Exadata service instances have default IORM settings.<br /><br />Note: Deprecated for Exadata Cloud Service systems. Use the [new resource model APIs](/iaas/Content/Database/Concepts/exaflexsystem.htm#exaflexsystem_topic-resource_model) instead.<br /><br />For Exadata Cloud Service instances, support for this API will end on May 15th, 2021. See [Switching an Exadata DB System to the New Resource Model and APIs](/iaas/Content/Database/Concepts/exaflexsystem_topic-resource_model_conversion.htm) for details on converting existing Exadata DB systems to the new resource model.<br /><br />The [GetCloudVmClusterIormConfig](#/en/database/latest/CloudVmCluster/GetCloudVmClusterIormConfig/) API is used for this operation with Exadata systems using the<br />new resource model.<br /> |
update | update | dbSystemId, region | opc-request-id, if-match | Updates IORM settings for the specified Exadata DB system.<br /><br />Note: Deprecated for Exadata Cloud Service systems. Use the [new resource model APIs](/iaas/Content/Database/Concepts/exaflexsystem.htm#exaflexsystem_topic-resource_model) instead.<br /><br />For Exadata Cloud Service instances, support for this API will end on May 15th, 2021. See [Switching an Exadata DB System to the New Resource Model and APIs](/iaas/Content/Database/Concepts/exaflexsystem_topic-resource_model_conversion.htm) for details on converting existing Exadata DB systems to the new resource model.<br /><br />The [UpdateCloudVmClusterIormConfig](#/en/database/latest/CloudVmCluster/UpdateCloudVmClusterIormConfig/) API is used for Exadata systems using the<br />new resource model.<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 |
|---|---|---|
dbSystemId | string | The DB system [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 settings for the specified cloud Exadata DB system.<br />All Exadata service instances have default IORM settings.<br /><br />Note: Deprecated for Exadata Cloud Service systems. Use the [new resource model APIs](/iaas/Content/Database/Concepts/exaflexsystem.htm#exaflexsystem_topic-resource_model) instead.<br /><br />For Exadata Cloud Service instances, support for this API will end on May 15th, 2021. See [Switching an Exadata DB System to the New Resource Model and APIs](/iaas/Content/Database/Concepts/exaflexsystem_topic-resource_model_conversion.htm) for details on converting existing Exadata DB systems to the new resource model.<br /><br />The [GetCloudVmClusterIormConfig](#/en/database/latest/CloudVmCluster/GetCloudVmClusterIormConfig/) API is used for this operation with Exadata systems using the<br />new resource model.<br />
SELECT
dbPlans,
lifecycleDetails,
lifecycleState,
objective
FROM oci.database.exadata_iorm_configs
WHERE dbSystemId = '{{ dbSystemId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
;
UPDATE examples​
- update
Updates IORM settings for the specified Exadata DB system.<br /><br />Note: Deprecated for Exadata Cloud Service systems. Use the [new resource model APIs](/iaas/Content/Database/Concepts/exaflexsystem.htm#exaflexsystem_topic-resource_model) instead.<br /><br />For Exadata Cloud Service instances, support for this API will end on May 15th, 2021. See [Switching an Exadata DB System to the New Resource Model and APIs](/iaas/Content/Database/Concepts/exaflexsystem_topic-resource_model_conversion.htm) for details on converting existing Exadata DB systems to the new resource model.<br /><br />The [UpdateCloudVmClusterIormConfig](#/en/database/latest/CloudVmCluster/UpdateCloudVmClusterIormConfig/) API is used for Exadata systems using the<br />new resource model.<br />
UPDATE oci.database.exadata_iorm_configs
SET
dbPlans = '{{ dbPlans }}',
objective = '{{ objective }}'
WHERE
dbSystemId = '{{ dbSystemId }}' --required
AND region = '{{ region }}' --required
AND opc-request-id = '{{ opc-request-id}}'
AND if-match = '{{ if-match}}'
RETURNING
dbPlans,
lifecycleDetails,
lifecycleState,
objective;