Skip to main content

autonomous_container_database_resource_usages

Creates, updates, deletes, gets or lists an autonomous_container_database_resource_usages resource.

Overview​

Nameautonomous_container_database_resource_usages
TypeResource
Idoci.database.autonomous_container_database_resource_usages

Fields​

The following fields are returned by SELECT queries:

Get the Autonomous Container Database resource usage details.

NameDatatypeDescription
idstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the Autonomous Container Database.
autonomousContainerDatabaseVmUsagearrayList of autonomous container database resource usage per autonomous virtual machine.
availableCpusnumber (float)CPUs available for provisioning or scaling an Autonomous AI Database in the Autonomous Container Database.
definedTagsobjectDefined tags for this resource. Each key is predefined and scoped to a namespace. For more information, see [Resource Tags](/Content/General/Concepts/resourcetags.htm).
displayNamestringThe user-friendly name for the Autonomous Container Database. The name does not need to be unique.
freeformTagsobjectFree-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"}
largestProvisionableAutonomousDatabaseInCpusnumber (float)Largest provisionable ADB in the Autonomous Container Database.
provisionableCpusarrayValid list of provisionable CPUs for Autonomous AI Database.
provisionedCpusnumber (float)CPUs / cores assigned to ADBs in the Autonomous Container Database.
reclaimableCpusnumber (float)Number of CPUs that are reclaimable or released to the AVMC on Autonomous Container Database restart.
reservedCpusnumber (float)CPUs / cores reserved for scalability, resilliency and other overheads. This includes failover, autoscaling and idle instance overhead.
usedCpusnumber (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:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectautonomousContainerDatabaseId, regionopc-request-idGet resource usage details for the specified Autonomous Container Database.<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.

NameDatatypeDescription
autonomousContainerDatabaseIdstringThe Autonomous Container Database [OCID](/Content/General/Concepts/identifiers.htm).
regionstringOCI 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)
opc-request-idstringUnique identifier for the request.

SELECT examples​

Get resource usage details for the specified Autonomous Container Database.<br />

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