db_system_shapes

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

Overview

Name	db_system_shapes
Type	Resource
Id	azure_isv.oracledatabase.db_system_shapes

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.
areServerTypesSupported	boolean	Indicates if the shape supports database and storage server types.
availableCoreCount	integer	The maximum number of CPU cores that can be enabled on the DB system for this shape. Required.
availableCoreCountPerNode	integer	The maximum number of CPU cores per database node that can be enabled for this shape. Only applicable to the flex Exadata shape and ExaCC Elastic shapes.
availableDataStorageInTbs	integer	The maximum DATA storage that can be enabled for this shape.
availableDataStoragePerServerInTbs	number	The maximum data storage available per storage server for this shape. Only applicable to ExaCC Elastic shapes.
availableDbNodePerNodeInGbs	integer	The maximum Db Node storage available per database node for this shape. Only applicable to ExaCC Elastic shapes.
availableDbNodeStorageInGbs	integer	The maximum Db Node storage that can be enabled for this shape.
availableMemoryInGbs	integer	The maximum memory that can be enabled for this shape.
availableMemoryPerNodeInGbs	integer	The maximum memory available per database node for this shape. Only applicable to ExaCC Elastic shapes.
computeModel	string	The compute model of the Exadata Infrastructure. Known values are: "ECPU" and "OCPU". (ECPU, OCPU)
coreCountIncrement	integer	The discrete number by which the CPU core count for this shape can be increased or decreased.
displayName	string	The display name of the shape used for the DB system.
maxStorageCount	integer	The maximum number of Exadata storage servers available for the Exadata infrastructure.
maximumNodeCount	integer	The maximum number of database nodes available for this shape.
minCoreCountPerNode	integer	The minimum number of CPU cores that can be enabled per node for this shape.
minDataStorageInTbs	integer	The minimum data storage that need be allocated for this shape.
minDbNodeStoragePerNodeInGbs	integer	The minimum Db Node storage that need be allocated per node for this shape.
minMemoryPerNodeInGbs	integer	The minimum memory that need be allocated per node for this shape.
minStorageCount	integer	The minimum number of Exadata storage servers available for the Exadata infrastructure.
minimumCoreCount	integer	The minimum number of CPU cores that can be enabled on the DB system for this shape.
minimumNodeCount	integer	The minimum number of database nodes available for this shape.
runtimeMinimumCoreCount	integer	The runtime minimum number of CPU cores that can be enabled on the DB system for this shape.
shapeAttributes	array	The shapeAttributes of the DB system shape..
shapeFamily	string	The family of the shape used for the DB system.
shapeName	string	The shape used for the DB system. Required.
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_location

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.
areServerTypesSupported	boolean	Indicates if the shape supports database and storage server types.
availableCoreCount	integer	The maximum number of CPU cores that can be enabled on the DB system for this shape. Required.
availableCoreCountPerNode	integer	The maximum number of CPU cores per database node that can be enabled for this shape. Only applicable to the flex Exadata shape and ExaCC Elastic shapes.
availableDataStorageInTbs	integer	The maximum DATA storage that can be enabled for this shape.
availableDataStoragePerServerInTbs	number	The maximum data storage available per storage server for this shape. Only applicable to ExaCC Elastic shapes.
availableDbNodePerNodeInGbs	integer	The maximum Db Node storage available per database node for this shape. Only applicable to ExaCC Elastic shapes.
availableDbNodeStorageInGbs	integer	The maximum Db Node storage that can be enabled for this shape.
availableMemoryInGbs	integer	The maximum memory that can be enabled for this shape.
availableMemoryPerNodeInGbs	integer	The maximum memory available per database node for this shape. Only applicable to ExaCC Elastic shapes.
computeModel	string	The compute model of the Exadata Infrastructure. Known values are: "ECPU" and "OCPU". (ECPU, OCPU)
coreCountIncrement	integer	The discrete number by which the CPU core count for this shape can be increased or decreased.
displayName	string	The display name of the shape used for the DB system.
maxStorageCount	integer	The maximum number of Exadata storage servers available for the Exadata infrastructure.
maximumNodeCount	integer	The maximum number of database nodes available for this shape.
minCoreCountPerNode	integer	The minimum number of CPU cores that can be enabled per node for this shape.
minDataStorageInTbs	integer	The minimum data storage that need be allocated for this shape.
minDbNodeStoragePerNodeInGbs	integer	The minimum Db Node storage that need be allocated per node for this shape.
minMemoryPerNodeInGbs	integer	The minimum memory that need be allocated per node for this shape.
minStorageCount	integer	The minimum number of Exadata storage servers available for the Exadata infrastructure.
minimumCoreCount	integer	The minimum number of CPU cores that can be enabled on the DB system for this shape.
minimumNodeCount	integer	The minimum number of database nodes available for this shape.
runtimeMinimumCoreCount	integer	The runtime minimum number of CPU cores that can be enabled on the DB system for this shape.
shapeAttributes	array	The shapeAttributes of the DB system shape..
shapeFamily	string	The family of the shape used for the DB system.
shapeName	string	The shape used for the DB system. Required.
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, dbsystemshapename, subscription_id		Get a DbSystemShape.
list_by_location	select	location, subscription_id	zone, shapeAttribute	List DbSystemShape 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
dbsystemshapename	string	DbSystemShape name. Required.
location	string	The name of the Azure region. Required.
subscription_id	string
shapeAttribute	string	Filters the result for the given Shape Attribute, such as BLOCK_STORAGE or SMART_STORAGE. Default value is None.
zone	string	Filters the result for the given Azure Availability Zone. Default value is None.

SELECT examples

get

Get a DbSystemShape.

SELECT
id,
name,
areServerTypesSupported,
availableCoreCount,
availableCoreCountPerNode,
availableDataStorageInTbs,
availableDataStoragePerServerInTbs,
availableDbNodePerNodeInGbs,
availableDbNodeStorageInGbs,
availableMemoryInGbs,
availableMemoryPerNodeInGbs,
computeModel,
coreCountIncrement,
displayName,
maxStorageCount,
maximumNodeCount,
minCoreCountPerNode,
minDataStorageInTbs,
minDbNodeStoragePerNodeInGbs,
minMemoryPerNodeInGbs,
minStorageCount,
minimumCoreCount,
minimumNodeCount,
runtimeMinimumCoreCount,
shapeAttributes,
shapeFamily,
shapeName,
systemData,
type
FROM azure_isv.oracledatabase.db_system_shapes
WHERE location = '{{ location }}' -- required
AND dbsystemshapename = '{{ dbsystemshapename }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list_by_location

List DbSystemShape resources by SubscriptionLocationResource.

SELECT
id,
name,
areServerTypesSupported,
availableCoreCount,
availableCoreCountPerNode,
availableDataStorageInTbs,
availableDataStoragePerServerInTbs,
availableDbNodePerNodeInGbs,
availableDbNodeStorageInGbs,
availableMemoryInGbs,
availableMemoryPerNodeInGbs,
computeModel,
coreCountIncrement,
displayName,
maxStorageCount,
maximumNodeCount,
minCoreCountPerNode,
minDataStorageInTbs,
minDbNodeStoragePerNodeInGbs,
minMemoryPerNodeInGbs,
minStorageCount,
minimumCoreCount,
minimumNodeCount,
runtimeMinimumCoreCount,
shapeAttributes,
shapeFamily,
shapeName,
systemData,
type
FROM azure_isv.oracledatabase.db_system_shapes
WHERE location = '{{ location }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
AND zone = '{{ zone }}'
AND shapeAttribute = '{{ shapeAttribute }}'
;