db_system_compute_performances
Creates, updates, deletes, gets or lists a db_system_compute_performances resource.
Overview​
| Name | db_system_compute_performances |
| Type | Resource |
| Id | oci.database.db_system_compute_performances |
Fields​
The following fields are returned by SELECT queries:
- list
Representation of disk performance detail parameters.<br />
| Name | Datatype | Description |
|---|---|---|
computePerformanceList | array | List of Compute performance details for the specified DB system shape. |
shape | string | The shape of the DB system. |
Methods​
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
list | select | region | dbSystemShape, opc-request-id, compartmentId | Gets a list of expected compute performance parameters for a virtual machine DB system based on system configuration. Adding compartmentId does not affect results.<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 |
|---|---|---|
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) |
compartmentId | string | The compartment [OCID](/Content/General/Concepts/identifiers.htm). |
dbSystemShape | string | If provided, filters the results to the set of database versions which are supported for the given shape. |
opc-request-id | string | Unique identifier for the request. |
SELECT examples​
- list
Gets a list of expected compute performance parameters for a virtual machine DB system based on system configuration. Adding compartmentId does not affect results.<br />
SELECT
computePerformanceList,
shape
FROM oci.database.db_system_compute_performances
WHERE region = '{{ region }}' -- required
AND dbSystemShape = '{{ dbSystemShape }}'
AND opc-request-id = '{{ opc-request-id }}'
AND compartmentId = '{{ compartmentId }}'
;