flex_components
Creates, updates, deletes, gets or lists a flex_components resource.
Overview​
| Name | flex_components |
| Type | Resource |
| Id | oci.database.flex_components |
Fields​
The following fields are returned by SELECT queries:
- list
Supported DB system flex Components for a given DB System shape.
| Name | Datatype | Description |
|---|---|---|
name | string | The name of the Flex Component used for the DB system. |
availableCoreCount | integer (int32) | The maximum number of CPU cores that can ben enabled on the DB Server for this Flex Component. |
availableDbStorageInGBs | integer (int32) | The maximum storage that can be enabled on the Storage Server for this Flex Component. |
availableLocalStorageInGBs | integer (int32) | The maximum local storage that can be enabled on the DB Server for this Flex Component. |
availableMemoryInGBs | integer | The maximum memory size that can be enabled on the DB Server for this Flex Component. |
computeModel | string | The compute model of the DB Server for this Flex Component. |
descriptionSummary | string | The description summary for this Flex Component. |
hardwareType | string | The hardware type of the DB (Compute) or Storage (Cell) Server for this Flex Component. (COMPUTE, CELL) |
minimumCoreCount | integer (int32) | The minimum number of CPU cores that can be enabled on the DB Server for this Flex Component. |
runtimeMinimumCoreCount | integer (int32) | The runtime minimum number of CPU cores that can be enabled for this Flex Component. |
shape | string | The name of the DB system shape for this Flex Component. |
Methods​
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
list | select | compartmentId, region | name, shape, sortOrder, sortBy, limit, page | Gets a list of the flex components that can be used to launch a new DB system. The flex component determines resources to allocate to the DB system - Database Servers and Storage Servers. |
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 |
|---|---|---|
compartmentId | string | The compartment [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) |
limit | integer | The maximum number of items to return per page. |
name | string | A filter to return only resources that match the entire name given. The match is not case sensitive. |
page | string | The pagination token to continue listing from. |
shape | string | A filter to return only resources that belong to the entire shape name given. The match is not case sensitive. |
sortBy | string | The field to sort by. You can provide one sort order (sortOrder). Default order for NAME is ascending. The NAME sort order is case sensitive. |
sortOrder | string | The sort order to use, either ascending (ASC) or descending (DESC). |
SELECT examples​
- list
Gets a list of the flex components that can be used to launch a new DB system. The flex component determines resources to allocate to the DB system - Database Servers and Storage Servers.
SELECT
name,
availableCoreCount,
availableDbStorageInGBs,
availableLocalStorageInGBs,
availableMemoryInGBs,
computeModel,
descriptionSummary,
hardwareType,
minimumCoreCount,
runtimeMinimumCoreCount,
shape
FROM oci.database.flex_components
WHERE compartmentId = '{{ compartmentId }}' -- required
AND region = '{{ region }}' -- required
AND name = '{{ name }}'
AND shape = '{{ shape }}'
AND sortOrder = '{{ sortOrder }}'
AND sortBy = '{{ sortBy }}'
AND limit = '{{ limit }}'
AND page = '{{ page }}'
;