autonomous_vm_cluster_acd_resource_usage
Creates, updates, deletes, gets or lists an autonomous_vm_cluster_acd_resource_usage resource.
Overview​
| Name | autonomous_vm_cluster_acd_resource_usage |
| Type | Resource |
| Id | oci.database.autonomous_vm_cluster_acd_resource_usage |
Fields​
The following fields are returned by SELECT queries:
- list
Associated autonomous container databases usages.
| Name | Datatype | Description |
|---|---|---|
id | string | The [OCID](/Content/General/Concepts/identifiers.htm) of the Autonomous Container Database. |
autonomousContainerDatabaseVmUsage | array | List of autonomous container database resource usage per autonomous virtual machine. |
availableCpus | number (float) | CPUs available for provisioning or scaling an Autonomous AI Database in the Autonomous Container Database. |
definedTags | object | Defined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm). |
displayName | string | The user-friendly name for the Autonomous Container Database. The name does not need to be unique. |
freeformTags | object | Free-form tags for this resource. Each tag is a simple key-value pair with no predefined name, type, or namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm). Example: {"Department": "Finance"} |
largestProvisionableAutonomousDatabaseInCpus | number (float) | Largest provisionable ADB in the Autonomous Container Database. |
provisionableCpus | array | Valid list of provisionable CPUs for Autonomous AI Database. |
provisionedCpus | number (float) | CPUs / cores assigned to ADBs in the Autonomous Container Database. |
reclaimableCpus | number (float) | Number of CPUs that are reclaimable or released to the AVMC on Autonomous Container Database restart. |
reservedCpus | number (float) | CPUs / cores reserved for scalability, resilliency and other overheads. This includes failover, autoscaling and idle instance overhead. |
usedCpus | number (float) | CPUs / cores assigned to the Autonomous Container Database. Sum of provisioned, reserved and reclaimable CPUs/ cores. |
Methods​
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
list | select | autonomousVmClusterId, region | compartmentId, opc-request-id, limit, page | Gets the list of resource usage details for all the Autonomous Container Database in the specified Autonomous Exadata VM cluster.<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 |
|---|---|---|
autonomousVmClusterId | string | The autonomous 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) |
compartmentId | string | The compartment [OCID](/Content/General/Concepts/identifiers.htm). |
limit | integer | The maximum number of items to return per page. |
opc-request-id | string | Unique identifier for the request. |
page | string | The pagination token to continue listing from. |
SELECT examples​
- list
Gets the list of resource usage details for all the Autonomous Container Database in the specified Autonomous Exadata VM cluster.<br />
SELECT
id,
autonomousContainerDatabaseVmUsage,
availableCpus,
definedTags,
displayName,
freeformTags,
largestProvisionableAutonomousDatabaseInCpus,
provisionableCpus,
provisionedCpus,
reclaimableCpus,
reservedCpus,
usedCpus
FROM oci.database.autonomous_vm_cluster_acd_resource_usage
WHERE autonomousVmClusterId = '{{ autonomousVmClusterId }}' -- required
AND region = '{{ region }}' -- required
AND compartmentId = '{{ compartmentId }}'
AND opc-request-id = '{{ opc-request-id }}'
AND limit = '{{ limit }}'
AND page = '{{ page }}'
;