Skip to main content

cloud_exadata_infrastructure_unallocated_resources

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

Overview

Namecloud_exadata_infrastructure_unallocated_resources
TypeResource
Idaws.odb.cloud_exadata_infrastructure_unallocated_resources

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
cloud_autonomous_vm_clustersarrayA list of Autonomous VM clusters associated with this Cloud Exadata Infrastructure.
cloud_exadata_infrastructure_display_namestringThe display name of the Cloud Exadata infrastructure.
cloud_exadata_infrastructure_idstringThe unique identifier of the Cloud Exadata infrastructure. (pattern: <code>(arn:(?:aws|aws-cn|aws-us-gov|aws-iso-{0,1}[a-z]{0,1}):[a-z0-9-]+:[a-z0-9-]*:[0-9]+:[a-z0-9-]+/[a-zA-Z0-9_.-]{6,64}|[a-zA-Z0-9_.-]{6,64})</code>)
exadata_storage_in_tbsnumber (double)The amount of unallocated Exadata storage available, in terabytes (TB).
local_storage_in_gbsintegerThe amount of unallocated local storage available, in gigabytes (GB).
memory_in_gbsintegerThe amount of unallocated memory available, in gigabytes (GB).
ocpusintegerThe number of unallocated Oracle CPU Units (OCPUs) available.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_cloud_exadata_infrastructure_unallocated_resourcesselectregionRetrieves information about unallocated resources in a specified Cloud Exadata Infrastructure.

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
regionstringAWS region (default: us-east-1)

SELECT examples

Retrieves information about unallocated resources in a specified Cloud Exadata Infrastructure.

SELECT
cloud_autonomous_vm_clusters,
cloud_exadata_infrastructure_display_name,
cloud_exadata_infrastructure_id,
exadata_storage_in_tbs,
local_storage_in_gbs,
memory_in_gbs,
ocpus
FROM aws.odb.cloud_exadata_infrastructure_unallocated_resources
WHERE region = '{{ region }}' -- required
;