Skip to main content

exadata_infrastructure_ocpus

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

Overview​

Nameexadata_infrastructure_ocpus
TypeResource
Idoci.database.exadata_infrastructure_ocpus

Fields​

The following fields are returned by SELECT queries:

Details of the available and consumed OCPUs for the specified Autonomous Exadata Infrastructure instance.

NameDatatypeDescription
byWorkloadTypeobjectThe number of consumed OCPUs, by database workload type.
consumedCpunumber (float)The total number of consumed OCPUs in the Autonomous Exadata Infrastructure instance.
totalCpunumber (float)The total number of OCPUs in the Autonomous Exadata Infrastructure instance.

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectautonomousExadataInfrastructureId, regionopc-request-idGets details of the available and consumed OCPUs for the specified Autonomous Exadata Infrastructure resource.<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
autonomousExadataInfrastructureIdstringThe Autonomous Exadata Infrastructure [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​

Gets details of the available and consumed OCPUs for the specified Autonomous Exadata Infrastructure resource.<br />

SELECT
byWorkloadType,
consumedCpu,
totalCpu
FROM oci.database.exadata_infrastructure_ocpus
WHERE autonomousExadataInfrastructureId = '{{ autonomousExadataInfrastructureId }}' -- required
AND region = '{{ region }}' -- required
AND opc-request-id = '{{ opc-request-id }}'
;