flex_components

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

Overview

Name	flex_components
Type	Resource
Id	azure_isv.oracledatabase.flex_components

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
availableCoreCount	integer	The maximum number of CPU cores that can be enabled on the DB Server for this Flex Component.
availableDbStorageInGbs	integer	The maximum storage that can be enabled on the Storage Server for this Flex Component.
availableLocalStorageInGbs	integer	The maximum local storage that can be enabled on the DB Server for this Flex Component.
availableMemoryInGbs	integer	The maximum memory size that can be enabled on the DB Server for this Flex Component.
computeModel	string	The compute model of the DB Server for this Flex Component.
descriptionSummary	string	The description summary for this Flex Component.
hardwareType	string	The hardware type of the DB (Compute) or Storage (Cell) Server for this Flex Component. Known values are: "COMPUTE" and "CELL". (COMPUTE, CELL)
minimumCoreCount	integer	The minimum number of CPU cores that can be enabled on the DB Server for this Flex Component.
runtimeMinimumCoreCount	integer	The runtime minimum number of CPU cores that can be enabled for this Flex Component.
shape	string	The name of the DB system shape for this Flex Component.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

list_by_parent

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
availableCoreCount	integer	The maximum number of CPU cores that can be enabled on the DB Server for this Flex Component.
availableDbStorageInGbs	integer	The maximum storage that can be enabled on the Storage Server for this Flex Component.
availableLocalStorageInGbs	integer	The maximum local storage that can be enabled on the DB Server for this Flex Component.
availableMemoryInGbs	integer	The maximum memory size that can be enabled on the DB Server for this Flex Component.
computeModel	string	The compute model of the DB Server for this Flex Component.
descriptionSummary	string	The description summary for this Flex Component.
hardwareType	string	The hardware type of the DB (Compute) or Storage (Cell) Server for this Flex Component. Known values are: "COMPUTE" and "CELL". (COMPUTE, CELL)
minimumCoreCount	integer	The minimum number of CPU cores that can be enabled on the DB Server for this Flex Component.
runtimeMinimumCoreCount	integer	The runtime minimum number of CPU cores that can be enabled for this Flex Component.
shape	string	The name of the DB system shape for this Flex Component.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	location, flex_component_name, subscription_id		Get a FlexComponent.
list_by_parent	select	location, subscription_id	shape	List FlexComponent resources by SubscriptionLocationResource.

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
flex_component_name	string	The name of the FlexComponent. Required.
location	string	The name of the Azure region. Required.
subscription_id	string
shape	string	If provided, filters the results for the given shape. Known values are: "Exadata.X9M", "Exadata.X11M", and "ExaDbXS". Default value is None.

SELECT examples

get

Get a FlexComponent.

SELECT
id,
name,
availableCoreCount,
availableDbStorageInGbs,
availableLocalStorageInGbs,
availableMemoryInGbs,
computeModel,
descriptionSummary,
hardwareType,
minimumCoreCount,
runtimeMinimumCoreCount,
shape,
systemData,
type
FROM azure_isv.oracledatabase.flex_components
WHERE location = '{{ location }}' -- required
AND flex_component_name = '{{ flex_component_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list_by_parent

List FlexComponent resources by SubscriptionLocationResource.

SELECT
id,
name,
availableCoreCount,
availableDbStorageInGbs,
availableLocalStorageInGbs,
availableMemoryInGbs,
computeModel,
descriptionSummary,
hardwareType,
minimumCoreCount,
runtimeMinimumCoreCount,
shape,
systemData,
type
FROM azure_isv.oracledatabase.flex_components
WHERE location = '{{ location }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
AND shape = '{{ shape }}'
;