autonomous_vm_cluster_resource_usages
Creates, updates, deletes, gets or lists an autonomous_vm_cluster_resource_usages resource.
Overview​
| Name | autonomous_vm_cluster_resource_usages |
| Type | Resource |
| Id | oci.database.autonomous_vm_cluster_resource_usages |
Fields​
The following fields are returned by SELECT queries:
- get
Get the Autonomous VM cluster resource usage details.
| Name | Datatype | Description |
|---|---|---|
id | string | The [OCID](/Content/General/Concepts/identifiers.htm) of the Autonomous VM cluster. |
autonomousDataStorageSizeInTBs | number (float) | The data disk group size allocated for Autonomous Databases, in TBs. |
autonomousVmResourceUsage | array | List of autonomous vm cluster resource usages. |
availableAutonomousDataStorageSizeInTBs | number (float) | The data disk group size available for Autonomous Databases, in TBs. |
availableCpus | number (float) | The number of CPU cores available. |
dbNodeStorageSizeInGBs | integer | The local node storage allocated in GBs. |
displayName | string | The user-friendly name for the Autonomous VM cluster. The name does not need to be unique. |
exadataStorageInTBs | number (double) | Total exadata storage allocated for the Autonomous VM Cluster. DATA + RECOVERY + SPARSE + any overhead in TBs. |
isLocalBackupEnabled | boolean | If true, database backup on local Exadata storage is configured for the Autonomous VM cluster. If false, database backup on local Exadata storage is not available in the Autonomous VM cluster. |
memoryPerOracleComputeUnitInGBs | integer | The amount of memory (in GBs) to be enabled per each CPU core. |
memorySizeInGBs | integer | The memory allocated in GBs. |
nonProvisionableAutonomousContainerDatabases | integer | The number of non-provisionable Autonomous Container Databases in an Autonomous VM Cluster. |
provisionableAutonomousContainerDatabases | integer | The number of provisionable Autonomous Container Databases in an Autonomous VM Cluster. |
provisionedAutonomousContainerDatabases | integer | The number of provisioned Autonomous Container Databases in an Autonomous VM Cluster. |
provisionedCpus | number (float) | The number of CPUs provisioned in an Autonomous VM Cluster. |
reclaimableCpus | number (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 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. |
reservedCpus | number (float) | The number of CPUs reserved in an Autonomous VM Cluster. |
totalContainerDatabases | integer | The total number of Autonomous Container Databases that can be created. |
totalCpus | number (float) | The number of CPU cores enabled on the Autonomous VM cluster. |
usedAutonomousDataStorageSizeInTBs | number (float) | The data disk group size used for Autonomous Databases, in TBs. |
usedCpus | number (float) | The number of CPU cores alloted to the Autonomous Container Databases in an Autonomous VM cluster. |
Methods​
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | autonomousVmClusterId, region | opc-request-id | Get the resource usage details for 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) |
opc-request-id | string | Unique identifier for the request. |
SELECT examples​
- get
Get the resource usage details for the specified Autonomous Exadata VM cluster.<br />
SELECT
id,
autonomousDataStorageSizeInTBs,
autonomousVmResourceUsage,
availableAutonomousDataStorageSizeInTBs,
availableCpus,
dbNodeStorageSizeInGBs,
displayName,
exadataStorageInTBs,
isLocalBackupEnabled,
memoryPerOracleComputeUnitInGBs,
memorySizeInGBs,
nonProvisionableAutonomousContainerDatabases,
provisionableAutonomousContainerDatabases,
provisionedAutonomousContainerDatabases,
provisionedCpus,
reclaimableCpus,
reservedCpus,
totalContainerDatabases,
totalCpus,
usedAutonomousDataStorageSizeInTBs,
usedCpus
FROM oci.database.autonomous_vm_cluster_resource_usages
WHERE autonomousVmClusterId = '{{ autonomousVmClusterId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
;