cloud_autonomous_vm_cluster_acd_resource_usage

Creates, updates, deletes, gets or lists a cloud_autonomous_vm_cluster_acd_resource_usage resource.

Overview

Name	cloud_autonomous_vm_cluster_acd_resource_usage
Type	Resource
Id	oci.database.cloud_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	cloudAutonomousVmClusterId, region	compartmentId, opc-request-id, limit, page	Gets the list of resource usage details for all the Cloud Autonomous Container Database<br />in the specified Cloud 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
cloudAutonomousVmClusterId	string	The Cloud 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 Cloud Autonomous Container Database<br />in the specified Cloud Autonomous Exadata VM cluster.<br />

SELECT
id,
autonomousContainerDatabaseVmUsage,
availableCpus,
definedTags,
displayName,
freeformTags,
largestProvisionableAutonomousDatabaseInCpus,
provisionableCpus,
provisionedCpus,
reclaimableCpus,
reservedCpus,
usedCpus
FROM oci.database.cloud_autonomous_vm_cluster_acd_resource_usage
WHERE cloudAutonomousVmClusterId = '{{ cloudAutonomousVmClusterId }}' -- required
AND region = '{{ region }}' -- required
AND compartmentId = '{{ compartmentId }}'
AND opc-request-id = '{{ opc-request-id }}'
AND limit = '{{ limit }}'
AND page = '{{ page }}'
;