db_system_shapes

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

Overview

Name	db_system_shapes
Type	Resource
Id	azure_isv.oracle.db_system_shapes

Fields

vw_db_system_shapes

Name	Datatype	Description
available_core_count	text	field from the properties object
available_core_count_per_node	text	field from the properties object
available_data_storage_in_tbs	text	field from the properties object
available_data_storage_per_server_in_tbs	text	field from the properties object
available_db_node_per_node_in_gbs	text	field from the properties object
available_db_node_storage_in_gbs	text	field from the properties object
available_memory_in_gbs	text	field from the properties object
available_memory_per_node_in_gbs	text	field from the properties object
core_count_increment	text	field from the properties object
dbsystemshapename	text	field from the properties object
location	text	field from the properties object
max_storage_count	text	field from the properties object
maximum_node_count	text	field from the properties object
min_core_count_per_node	text	field from the properties object
min_data_storage_in_tbs	text	field from the properties object
min_db_node_storage_per_node_in_gbs	text	field from the properties object
min_memory_per_node_in_gbs	text	field from the properties object
min_storage_count	text	field from the properties object
minimum_core_count	text	field from the properties object
minimum_node_count	text	field from the properties object
runtime_minimum_core_count	text	field from the properties object
shape_family	text	field from the properties object
subscriptionId	text	field from the properties object

db_system_shapes

Name	Datatype	Description
properties	object	DbSystemShape resource model

Methods

Name	Accessible by	Required Params	Description
get	SELECT	dbsystemshapename, location, subscriptionId	Get a DbSystemShape
list_by_location	SELECT	location, subscriptionId	List DbSystemShape resources by Location

SELECT examples

List DbSystemShape resources by Location

vw_db_system_shapes

SELECT
available_core_count,
available_core_count_per_node,
available_data_storage_in_tbs,
available_data_storage_per_server_in_tbs,
available_db_node_per_node_in_gbs,
available_db_node_storage_in_gbs,
available_memory_in_gbs,
available_memory_per_node_in_gbs,
core_count_increment,
dbsystemshapename,
location,
max_storage_count,
maximum_node_count,
min_core_count_per_node,
min_data_storage_in_tbs,
min_db_node_storage_per_node_in_gbs,
min_memory_per_node_in_gbs,
min_storage_count,
minimum_core_count,
minimum_node_count,
runtime_minimum_core_count,
shape_family,
subscriptionId
FROM azure_isv.oracle.vw_db_system_shapes
WHERE location = '{{ location }}'
AND subscriptionId = '{{ subscriptionId }}';

db_system_shapes

SELECT
properties
FROM azure_isv.oracle.db_system_shapes
WHERE location = '{{ location }}'
AND subscriptionId = '{{ subscriptionId }}';