db_system_shapes

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

Overview

Name	db_system_shapes
Type	Resource
Id	google.oracledatabase.db_system_shapes

Fields

Name	Datatype	Description
name	string	Identifier. The name of the Database System Shape resource with the format: projects/{project}/locations/{region}/dbSystemShapes/{db_system_shape}
availableCoreCountPerNode	integer	Optional. Number of cores per node.
availableDataStorageTb	integer	Optional. Storage per storage server in terabytes.
availableMemoryPerNodeGb	integer	Optional. Memory per database server node in gigabytes.
maxNodeCount	integer	Optional. Maximum number of database servers.
maxStorageCount	integer	Optional. Maximum number of storage servers.
minCoreCountPerNode	integer	Optional. Minimum core count per node.
minDbNodeStoragePerNodeGb	integer	Optional. Minimum node storage per database server in gigabytes.
minMemoryPerNodeGb	integer	Optional. Minimum memory per node in gigabytes.
minNodeCount	integer	Optional. Minimum number of database servers.
minStorageCount	integer	Optional. Minimum number of storage servers.
shape	string	Optional. shape

Methods

Name	Accessible by	Required Params	Description
list	SELECT	locationsId, projectsId	Lists the database system shapes available for the project and location.

SELECT examples

Lists the database system shapes available for the project and location.

SELECT
name,
availableCoreCountPerNode,
availableDataStorageTb,
availableMemoryPerNodeGb,
maxNodeCount,
maxStorageCount,
minCoreCountPerNode,
minDbNodeStoragePerNodeGb,
minMemoryPerNodeGb,
minNodeCount,
minStorageCount,
shape
FROM google.oracledatabase.db_system_shapes
WHERE locationsId = '{{ locationsId }}'
AND projectsId = '{{ projectsId }}';