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

The following fields are returned by SELECT queries:

list

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 (int32)	Optional. Number of cores per node.
availableDataStorageTb	integer (int32)	Optional. Storage per storage server in terabytes.
availableMemoryPerNodeGb	integer (int32)	Optional. Memory per database server node in gigabytes.
maxNodeCount	integer (int32)	Optional. Maximum number of database servers.
maxStorageCount	integer (int32)	Optional. Maximum number of storage servers.
minCoreCountPerNode	integer (int32)	Optional. Minimum core count per node.
minDbNodeStoragePerNodeGb	integer (int32)	Optional. Minimum node storage per database server in gigabytes.
minMemoryPerNodeGb	integer (int32)	Optional. Minimum memory per node in gigabytes.
minNodeCount	integer (int32)	Optional. Minimum number of database servers.
minStorageCount	integer (int32)	Optional. Minimum number of storage servers.
shape	string	Optional. shape

Methods

The following methods are available for this resource:

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

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
locationsId	string
projectsId	string
pageSize	integer (int32)
pageToken	string

SELECT examples

list

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 projectsId = '{{ projectsId }}' -- required
AND locationsId = '{{ locationsId }}' -- required
AND pageSize = '{{ pageSize }}'
AND pageToken = '{{ pageToken }}'
;