db_system_shapes

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

Overview

Name	db_system_shapes
Type	Resource
Id	aws.odb.db_system_shapes

Fields

The following fields are returned by SELECT queries:

list_db_system_shapes

Name	Datatype	Description
name	string	The name of the shape.
are_server_types_supported	boolean	Indicates whether the hardware system model supports configurable database and server storage types.
available_core_count	integer	The maximum number of CPU cores that can be enabled for the shape.
available_core_count_per_node	integer	The maximum number of CPU cores per DB node that can be enabled for the shape.
available_data_storage_in_tbs	integer	The maximum amount of data storage, in terabytes (TB), that can be enabled for the shape.
available_data_storage_per_server_in_tbs	integer	The maximum amount of data storage, in terabytes (TB), that's available per storage server for the shape.
available_db_node_per_node_in_gbs	integer	The maximum amount of DB node storage, in gigabytes (GB), that's available per DB node for the shape.
available_db_node_storage_in_gbs	integer	The maximum amount of DB node storage, in gigabytes (GB), that can be enabled for the shape.
available_memory_in_gbs	integer	The maximum amount of memory, in gigabytes (GB), that can be enabled for the shape.
available_memory_per_node_in_gbs	integer	The maximum amount of memory, in gigabytes (GB), that's available per DB node for the shape.
compute_model	string	The OCI model compute model used when you create or clone an instance: ECPU or OCPU. An ECPU is an abstracted measure of compute resources. ECPUs are based on the number of cores elastically allocated from a pool of compute and storage servers. An OCPU is a legacy physical measure of compute resources. OCPUs are based on the physical core of a processor with hyper-threading enabled. (ECPU, OCPU)
core_count_increment	integer	The discrete number by which the CPU core count for the shape can be increased or decreased.
max_storage_count	integer	The maximum number of Exadata storage servers that's available for the shape.
maximum_node_count	integer	The maximum number of compute servers that is available for the shape.
min_core_count_per_node	integer	The minimum number of CPU cores that can be enabled per node for the shape.
min_data_storage_in_tbs	integer	The minimum amount of data storage, in terabytes (TB), that must be allocated for the shape.
min_db_node_storage_per_node_in_gbs	integer	The minimum amount of DB node storage, in gigabytes (GB), that must be allocated per DB node for the shape.
min_memory_per_node_in_gbs	integer	The minimum amount of memory, in gigabytes (GB), that must be allocated per DB node for the shape.
min_storage_count	integer	The minimum number of Exadata storage servers that are available for the shape.
minimum_core_count	integer	The minimum number of CPU cores that can be enabled for the shape.
minimum_node_count	integer	The minimum number of compute servers that are available for the shape.
runtime_minimum_core_count	integer	The runtime minimum number of CPU cores that can be enabled for the shape.
shape_attributes	array	If provided and applicable, return DB System shape parameters based on the shape attribute provided.
shape_family	string	The family of the shape.
shape_type	string	The shape type. This property is determined by the CPU hardware. (AMD, INTEL, INTEL_FLEX_X9, AMPERE_FLEX_A1)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_db_system_shapes	select	region		Returns information about the shapes that are available for an 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.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)

SELECT examples

list_db_system_shapes

Returns information about the shapes that are available for an Exadata infrastructure.

SELECT
name,
are_server_types_supported,
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,
compute_model,
core_count_increment,
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_attributes,
shape_family,
shape_type
FROM aws.odb.db_system_shapes
WHERE region = '{{ region }}' -- required
;