db_system_storage_performances
Creates, updates, deletes, gets or lists a db_system_storage_performances resource.
Overview​
| Name | db_system_storage_performances |
| Type | Resource |
| Id | oci.database.db_system_storage_performances |
Fields​
The following fields are returned by SELECT queries:
- list
Representation of storage performance summary per shapeType .<br />
| Name | Datatype | Description |
|---|---|---|
dataStoragePerformanceList | array | List of storage performance for the DATA disks |
recoStoragePerformanceList | array | List of storage performance for the RECO disks |
shapeType | string | ShapeType of the DbSystems INTEL , AMD, INTEL_FLEX_X9 or AMPERE_FLEX_A1 (AMD, INTEL, INTEL_FLEX_X9, AMPERE_FLEX_A1) |
Methods​
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
list | select | storageManagement, region | shapeType, databaseEdition, opc-request-id | Gets a list of possible expected storage performance parameters of a VMDB System based on Configuration.<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) |
storageManagement | string | The DB system storage management option. Used to list database versions available for that storage manager. Valid values are ASM and LVM. * ASM specifies Oracle Automatic Storage Management * LVM specifies logical volume manager, sometimes called logical disk manager. |
databaseEdition | string | The database edition of quota (STANDARD_EDITION/ENTERPRISE_EDITION/ENTERPRISE_EDITION_HIGH_PERFORMANCE/ENTERPRISE_EDITION_EXTREME_PERFORMANCE/ENTERPRISE_EDITION_DEVELOPER) |
opc-request-id | string | Unique identifier for the request. |
shapeType | string | Optional. Filters the performance results by shape type. |
SELECT examples​
- list
Gets a list of possible expected storage performance parameters of a VMDB System based on Configuration.<br />
SELECT
dataStoragePerformanceList,
recoStoragePerformanceList,
shapeType
FROM oci.database.db_system_storage_performances
WHERE storageManagement = '{{ storageManagement }}' -- required
AND region = '{{ region }}' -- required
AND shapeType = '{{ shapeType }}'
AND databaseEdition = '{{ databaseEdition }}'
AND opc-request-id = '{{ opc-request-id }}'
;