Skip to main content

cloud_autonomous_vm_cluster_resource_usages

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

Overview​

Namecloud_autonomous_vm_cluster_resource_usages
TypeResource
Idoci.database.cloud_autonomous_vm_cluster_resource_usages

Fields​

The following fields are returned by SELECT queries:

Get the Autonomous Cloud VM cluster resource usage details.

NameDatatypeDescription
idstringThe [OCID](/Content/General/Concepts/identifiers.htm) of the Cloud Autonomous VM cluster.
autonomousDataStorageSizeInTBsnumber (float)The data disk group size allocated for Autonomous AI Databases, in TBs.
autonomousVmResourceUsagearrayList of Autonomous VM resource usages.
availableAutonomousDataStorageSizeInTBsnumber (float)The data disk group size available for Autonomous AI Databases, in TBs.
availableCpusnumber (float)The number of CPU cores available.
dbNodeStorageSizeInGBsintegerThe local node storage allocated in GBs.
displayNamestringThe user-friendly name for the Autonomous VM cluster. The name does not need to be unique.
exadataStorageInTBsnumber (double)Total exadata storage allocated for the Autonomous VM Cluster. DATA + RECOVERY + SPARSE + any overhead in TBs.
memoryPerOracleComputeUnitInGBsintegerThe amount of memory (in GBs) to be enabled per each CPU core.
memorySizeInGBsintegerThe memory allocated in GBs.
nonProvisionableAutonomousContainerDatabasesintegerThe number of non-provisionable Autonomous Container Databases in an Autonomous VM Cluster.
provisionableAutonomousContainerDatabasesintegerThe number of provisionable Autonomous Container Databases in an Autonomous VM Cluster.
provisionedAutonomousContainerDatabasesintegerThe number of provisioned Autonomous Container Databases in an Autonomous VM Cluster.
provisionedCpusnumber (float)The number of CPUs provisioned in an Autonomous VM Cluster.
reclaimableCpusnumber (float)CPU cores that continue to be included in the count of OCPUs available to the Autonomous Container Database even after one of its Autonomous AI Database is terminated or scaled down. You can release them to the available OCPUs at its parent AVMC level by restarting the Autonomous Container Database.
reservedCpusnumber (float)The number of CPUs reserved in an Autonomous VM Cluster.
totalContainerDatabasesintegerThe total number of Autonomous Container Databases that can be created.
totalCpusnumber (float)The number of CPU cores enabled on the Cloud Autonomous VM cluster.
usedAutonomousDataStorageSizeInTBsnumber (float)The data disk group size used for Autonomous AI Databases, in TBs.
usedCpusnumber (float)The number of CPU cores alloted to the Autonomous Container Databases in an Cloud Autonomous VM cluster.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectcloudAutonomousVmClusterId, regionopc-request-idGet the resource usage details for 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.

NameDatatypeDescription
cloudAutonomousVmClusterIdstringThe Cloud VM cluster [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 the resource usage details for the specified Cloud Autonomous Exadata VM cluster.<br />

SELECT
id,
autonomousDataStorageSizeInTBs,
autonomousVmResourceUsage,
availableAutonomousDataStorageSizeInTBs,
availableCpus,
dbNodeStorageSizeInGBs,
displayName,
exadataStorageInTBs,
memoryPerOracleComputeUnitInGBs,
memorySizeInGBs,
nonProvisionableAutonomousContainerDatabases,
provisionableAutonomousContainerDatabases,
provisionedAutonomousContainerDatabases,
provisionedCpus,
reclaimableCpus,
reservedCpus,
totalContainerDatabases,
totalCpus,
usedAutonomousDataStorageSizeInTBs,
usedCpus
FROM oci.database.cloud_autonomous_vm_cluster_resource_usages
WHERE cloudAutonomousVmClusterId = '{{ cloudAutonomousVmClusterId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
;