oci.Database.getDbSystemShapes
Explore with Pulumi AI
This data source provides the list of Db System Shapes in Oracle Cloud Infrastructure Database service.
Gets a list of the shapes that can be used to launch a new DB system. The shape determines resources to allocate to the DB system - CPU cores and memory for VM shapes; CPU cores, memory and storage for non-VM (or bare metal) shapes.
Example Usage
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";
const testDbSystemShapes = oci.Database.getDbSystemShapes({
    compartmentId: compartmentId,
    availabilityDomain: dbSystemShapeAvailabilityDomain,
});
import pulumi
import pulumi_oci as oci
test_db_system_shapes = oci.Database.get_db_system_shapes(compartment_id=compartment_id,
    availability_domain=db_system_shape_availability_domain)
package main
import (
	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/database"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := database.GetDbSystemShapes(ctx, &database.GetDbSystemShapesArgs{
			CompartmentId:      compartmentId,
			AvailabilityDomain: pulumi.StringRef(dbSystemShapeAvailabilityDomain),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}
using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;
return await Deployment.RunAsync(() => 
{
    var testDbSystemShapes = Oci.Database.GetDbSystemShapes.Invoke(new()
    {
        CompartmentId = compartmentId,
        AvailabilityDomain = dbSystemShapeAvailabilityDomain,
    });
});
package generated_program;
import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.Database.DatabaseFunctions;
import com.pulumi.oci.Database.inputs.GetDbSystemShapesArgs;
import java.util.List;
import java.util.ArrayList;
import java.util.Map;
import java.io.File;
import java.nio.file.Files;
import java.nio.file.Paths;
public class App {
    public static void main(String[] args) {
        Pulumi.run(App::stack);
    }
    public static void stack(Context ctx) {
        final var testDbSystemShapes = DatabaseFunctions.getDbSystemShapes(GetDbSystemShapesArgs.builder()
            .compartmentId(compartmentId)
            .availabilityDomain(dbSystemShapeAvailabilityDomain)
            .build());
    }
}
variables:
  testDbSystemShapes:
    fn::invoke:
      function: oci:Database:getDbSystemShapes
      arguments:
        compartmentId: ${compartmentId}
        availabilityDomain: ${dbSystemShapeAvailabilityDomain}
Using getDbSystemShapes
Two invocation forms are available. The direct form accepts plain arguments and either blocks until the result value is available, or returns a Promise-wrapped result. The output form accepts Input-wrapped arguments and returns an Output-wrapped result.
function getDbSystemShapes(args: GetDbSystemShapesArgs, opts?: InvokeOptions): Promise<GetDbSystemShapesResult>
function getDbSystemShapesOutput(args: GetDbSystemShapesOutputArgs, opts?: InvokeOptions): Output<GetDbSystemShapesResult>def get_db_system_shapes(availability_domain: Optional[str] = None,
                         compartment_id: Optional[str] = None,
                         filters: Optional[Sequence[GetDbSystemShapesFilter]] = None,
                         opts: Optional[InvokeOptions] = None) -> GetDbSystemShapesResult
def get_db_system_shapes_output(availability_domain: Optional[pulumi.Input[str]] = None,
                         compartment_id: Optional[pulumi.Input[str]] = None,
                         filters: Optional[pulumi.Input[Sequence[pulumi.Input[GetDbSystemShapesFilterArgs]]]] = None,
                         opts: Optional[InvokeOptions] = None) -> Output[GetDbSystemShapesResult]func GetDbSystemShapes(ctx *Context, args *GetDbSystemShapesArgs, opts ...InvokeOption) (*GetDbSystemShapesResult, error)
func GetDbSystemShapesOutput(ctx *Context, args *GetDbSystemShapesOutputArgs, opts ...InvokeOption) GetDbSystemShapesResultOutput> Note: This function is named GetDbSystemShapes in the Go SDK.
public static class GetDbSystemShapes 
{
    public static Task<GetDbSystemShapesResult> InvokeAsync(GetDbSystemShapesArgs args, InvokeOptions? opts = null)
    public static Output<GetDbSystemShapesResult> Invoke(GetDbSystemShapesInvokeArgs args, InvokeOptions? opts = null)
}public static CompletableFuture<GetDbSystemShapesResult> getDbSystemShapes(GetDbSystemShapesArgs args, InvokeOptions options)
public static Output<GetDbSystemShapesResult> getDbSystemShapes(GetDbSystemShapesArgs args, InvokeOptions options)
fn::invoke:
  function: oci:Database/getDbSystemShapes:getDbSystemShapes
  arguments:
    # arguments dictionaryThe following arguments are supported:
- CompartmentId string
- The compartment OCID.
- AvailabilityDomain string
- The name of the Availability Domain.
- Filters
List<GetDb System Shapes Filter> 
- CompartmentId string
- The compartment OCID.
- AvailabilityDomain string
- The name of the Availability Domain.
- Filters
[]GetDb System Shapes Filter 
- compartmentId String
- The compartment OCID.
- availabilityDomain String
- The name of the Availability Domain.
- filters
List<GetDb System Shapes Filter> 
- compartmentId string
- The compartment OCID.
- availabilityDomain string
- The name of the Availability Domain.
- filters
GetDb System Shapes Filter[] 
- compartment_id str
- The compartment OCID.
- availability_domain str
- The name of the Availability Domain.
- filters
Sequence[GetDb System Shapes Filter] 
- compartmentId String
- The compartment OCID.
- availabilityDomain String
- The name of the Availability Domain.
- filters List<Property Map>
getDbSystemShapes Result
The following output properties are available:
- CompartmentId string
- DbSystem List<GetShapes Db System Shapes Db System Shape> 
- The list of db_system_shapes.
- Id string
- The provider-assigned unique ID for this managed resource.
- AvailabilityDomain string
- Filters
List<GetDb System Shapes Filter> 
- CompartmentId string
- DbSystem []GetShapes Db System Shapes Db System Shape 
- The list of db_system_shapes.
- Id string
- The provider-assigned unique ID for this managed resource.
- AvailabilityDomain string
- Filters
[]GetDb System Shapes Filter 
- compartmentId String
- dbSystem List<GetShapes Db System Shapes Db System Shape> 
- The list of db_system_shapes.
- id String
- The provider-assigned unique ID for this managed resource.
- availabilityDomain String
- filters
List<GetDb System Shapes Filter> 
- compartmentId string
- dbSystem GetShapes Db System Shapes Db System Shape[] 
- The list of db_system_shapes.
- id string
- The provider-assigned unique ID for this managed resource.
- availabilityDomain string
- filters
GetDb System Shapes Filter[] 
- compartment_id str
- db_system_ Sequence[Getshapes Db System Shapes Db System Shape] 
- The list of db_system_shapes.
- id str
- The provider-assigned unique ID for this managed resource.
- availability_domain str
- filters
Sequence[GetDb System Shapes Filter] 
- compartmentId String
- dbSystem List<Property Map>Shapes 
- The list of db_system_shapes.
- id String
- The provider-assigned unique ID for this managed resource.
- availabilityDomain String
- filters List<Property Map>
Supporting Types
GetDbSystemShapesDbSystemShape      
- AreServer boolTypes Supported 
- If true, the shape supports configurable DB and Storage Server types.
- AvailableCore intCount 
- The maximum number of CPU cores that can be enabled on the DB system for this shape.
- AvailableCore intCount Per Node 
- The maximum number of CPU cores per database node that can be enabled for this shape. Only applicable to the flex Exadata shape, ExaCC Elastic shapes and VM Flex shapes.
- AvailableData intStorage In Tbs 
- The maximum DATA storage that can be enabled for this shape.
- AvailableData doubleStorage Per Server In Tbs 
- The maximum data storage available per storage server for this shape. Only applicable to ExaCC Elastic shapes.
- AvailableDb intNode Per Node In Gbs 
- The maximum Db Node storage available per database node for this shape. Only applicable to ExaCC Elastic shapes.
- AvailableDb intNode Storage In Gbs 
- The maximum Db Node storage that can be enabled for this shape.
- AvailableMemory intIn Gbs 
- The maximum memory that can be enabled for this shape.
- AvailableMemory intPer Node In Gbs 
- The maximum memory available per database node for this shape. Only applicable to ExaCC Elastic shapes.
- ComputeModel string
- The compute model of the Autonomous Database. This is required if using the computeCountparameter. If usingcpuCoreCountthen it is an error to specifycomputeModelto a non-null value. ECPU compute model is the recommended model and OCPU compute model is legacy.
- CoreCount intIncrement 
- 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.
- MaxStorage intCount 
- The maximum number of Exadata storage servers available for the Exadata infrastructure.
- MaximumNode intCount 
- The maximum number of compute servers available for this shape.
- MinCore intCount Per Node 
- The minimum number of CPU cores that can be enabled per node for this shape.
- MinData intStorage In Tbs 
- The minimum data storage that need be allocated for this shape.
- MinDb intNode Storage Per Node In Gbs 
- The minimum Db Node storage that need be allocated per node for this shape.
- MinMemory intPer Node In Gbs 
- The minimum memory that need be allocated per node for this shape.
- MinStorage intCount 
- The minimum number of Exadata storage servers available for the Exadata infrastructure.
- MinimumCore intCount 
- The minimum number of CPU cores that can be enabled on the DB system for this shape.
- MinimumNode intCount 
- The minimum number of compute servers available for this shape.
- Name string
- The name of the shape used for the DB system.
- Shape string
- Deprecated. Use nameinstead ofshape.
- ShapeFamily string
- The family of the shape used for the DB system.
- ShapeType string
- The shape type for the virtual machine DB system. Shape type is determined by CPU hardware. Valid values are AMD,INTELorINTEL_FLEX_X9.
- AreServer boolTypes Supported 
- If true, the shape supports configurable DB and Storage Server types.
- AvailableCore intCount 
- The maximum number of CPU cores that can be enabled on the DB system for this shape.
- AvailableCore intCount Per Node 
- The maximum number of CPU cores per database node that can be enabled for this shape. Only applicable to the flex Exadata shape, ExaCC Elastic shapes and VM Flex shapes.
- AvailableData intStorage In Tbs 
- The maximum DATA storage that can be enabled for this shape.
- AvailableData float64Storage Per Server In Tbs 
- The maximum data storage available per storage server for this shape. Only applicable to ExaCC Elastic shapes.
- AvailableDb intNode Per Node In Gbs 
- The maximum Db Node storage available per database node for this shape. Only applicable to ExaCC Elastic shapes.
- AvailableDb intNode Storage In Gbs 
- The maximum Db Node storage that can be enabled for this shape.
- AvailableMemory intIn Gbs 
- The maximum memory that can be enabled for this shape.
- AvailableMemory intPer Node In Gbs 
- The maximum memory available per database node for this shape. Only applicable to ExaCC Elastic shapes.
- ComputeModel string
- The compute model of the Autonomous Database. This is required if using the computeCountparameter. If usingcpuCoreCountthen it is an error to specifycomputeModelto a non-null value. ECPU compute model is the recommended model and OCPU compute model is legacy.
- CoreCount intIncrement 
- 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.
- MaxStorage intCount 
- The maximum number of Exadata storage servers available for the Exadata infrastructure.
- MaximumNode intCount 
- The maximum number of compute servers available for this shape.
- MinCore intCount Per Node 
- The minimum number of CPU cores that can be enabled per node for this shape.
- MinData intStorage In Tbs 
- The minimum data storage that need be allocated for this shape.
- MinDb intNode Storage Per Node In Gbs 
- The minimum Db Node storage that need be allocated per node for this shape.
- MinMemory intPer Node In Gbs 
- The minimum memory that need be allocated per node for this shape.
- MinStorage intCount 
- The minimum number of Exadata storage servers available for the Exadata infrastructure.
- MinimumCore intCount 
- The minimum number of CPU cores that can be enabled on the DB system for this shape.
- MinimumNode intCount 
- The minimum number of compute servers available for this shape.
- Name string
- The name of the shape used for the DB system.
- Shape string
- Deprecated. Use nameinstead ofshape.
- ShapeFamily string
- The family of the shape used for the DB system.
- ShapeType string
- The shape type for the virtual machine DB system. Shape type is determined by CPU hardware. Valid values are AMD,INTELorINTEL_FLEX_X9.
- areServer BooleanTypes Supported 
- If true, the shape supports configurable DB and Storage Server types.
- availableCore IntegerCount 
- The maximum number of CPU cores that can be enabled on the DB system for this shape.
- availableCore IntegerCount Per Node 
- The maximum number of CPU cores per database node that can be enabled for this shape. Only applicable to the flex Exadata shape, ExaCC Elastic shapes and VM Flex shapes.
- availableData IntegerStorage In Tbs 
- The maximum DATA storage that can be enabled for this shape.
- availableData DoubleStorage Per Server In Tbs 
- The maximum data storage available per storage server for this shape. Only applicable to ExaCC Elastic shapes.
- availableDb IntegerNode Per Node In Gbs 
- The maximum Db Node storage available per database node for this shape. Only applicable to ExaCC Elastic shapes.
- availableDb IntegerNode Storage In Gbs 
- The maximum Db Node storage that can be enabled for this shape.
- availableMemory IntegerIn Gbs 
- The maximum memory that can be enabled for this shape.
- availableMemory IntegerPer Node In Gbs 
- The maximum memory available per database node for this shape. Only applicable to ExaCC Elastic shapes.
- computeModel String
- The compute model of the Autonomous Database. This is required if using the computeCountparameter. If usingcpuCoreCountthen it is an error to specifycomputeModelto a non-null value. ECPU compute model is the recommended model and OCPU compute model is legacy.
- coreCount IntegerIncrement 
- 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.
- maxStorage IntegerCount 
- The maximum number of Exadata storage servers available for the Exadata infrastructure.
- maximumNode IntegerCount 
- The maximum number of compute servers available for this shape.
- minCore IntegerCount Per Node 
- The minimum number of CPU cores that can be enabled per node for this shape.
- minData IntegerStorage In Tbs 
- The minimum data storage that need be allocated for this shape.
- minDb IntegerNode Storage Per Node In Gbs 
- The minimum Db Node storage that need be allocated per node for this shape.
- minMemory IntegerPer Node In Gbs 
- The minimum memory that need be allocated per node for this shape.
- minStorage IntegerCount 
- The minimum number of Exadata storage servers available for the Exadata infrastructure.
- minimumCore IntegerCount 
- The minimum number of CPU cores that can be enabled on the DB system for this shape.
- minimumNode IntegerCount 
- The minimum number of compute servers available for this shape.
- name String
- The name of the shape used for the DB system.
- shape String
- Deprecated. Use nameinstead ofshape.
- shapeFamily String
- The family of the shape used for the DB system.
- shapeType String
- The shape type for the virtual machine DB system. Shape type is determined by CPU hardware. Valid values are AMD,INTELorINTEL_FLEX_X9.
- areServer booleanTypes Supported 
- If true, the shape supports configurable DB and Storage Server types.
- availableCore numberCount 
- The maximum number of CPU cores that can be enabled on the DB system for this shape.
- availableCore numberCount Per Node 
- The maximum number of CPU cores per database node that can be enabled for this shape. Only applicable to the flex Exadata shape, ExaCC Elastic shapes and VM Flex shapes.
- availableData numberStorage In Tbs 
- The maximum DATA storage that can be enabled for this shape.
- availableData numberStorage Per Server In Tbs 
- The maximum data storage available per storage server for this shape. Only applicable to ExaCC Elastic shapes.
- availableDb numberNode Per Node In Gbs 
- The maximum Db Node storage available per database node for this shape. Only applicable to ExaCC Elastic shapes.
- availableDb numberNode Storage In Gbs 
- The maximum Db Node storage that can be enabled for this shape.
- availableMemory numberIn Gbs 
- The maximum memory that can be enabled for this shape.
- availableMemory numberPer Node In Gbs 
- The maximum memory available per database node for this shape. Only applicable to ExaCC Elastic shapes.
- computeModel string
- The compute model of the Autonomous Database. This is required if using the computeCountparameter. If usingcpuCoreCountthen it is an error to specifycomputeModelto a non-null value. ECPU compute model is the recommended model and OCPU compute model is legacy.
- coreCount numberIncrement 
- 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.
- maxStorage numberCount 
- The maximum number of Exadata storage servers available for the Exadata infrastructure.
- maximumNode numberCount 
- The maximum number of compute servers available for this shape.
- minCore numberCount Per Node 
- The minimum number of CPU cores that can be enabled per node for this shape.
- minData numberStorage In Tbs 
- The minimum data storage that need be allocated for this shape.
- minDb numberNode Storage Per Node In Gbs 
- The minimum Db Node storage that need be allocated per node for this shape.
- minMemory numberPer Node In Gbs 
- The minimum memory that need be allocated per node for this shape.
- minStorage numberCount 
- The minimum number of Exadata storage servers available for the Exadata infrastructure.
- minimumCore numberCount 
- The minimum number of CPU cores that can be enabled on the DB system for this shape.
- minimumNode numberCount 
- The minimum number of compute servers available for this shape.
- name string
- The name of the shape used for the DB system.
- shape string
- Deprecated. Use nameinstead ofshape.
- shapeFamily string
- The family of the shape used for the DB system.
- shapeType string
- The shape type for the virtual machine DB system. Shape type is determined by CPU hardware. Valid values are AMD,INTELorINTEL_FLEX_X9.
- are_server_ booltypes_ supported 
- If true, the shape supports configurable DB and Storage Server types.
- available_core_ intcount 
- The maximum number of CPU cores that can be enabled on the DB system for this shape.
- available_core_ intcount_ per_ node 
- The maximum number of CPU cores per database node that can be enabled for this shape. Only applicable to the flex Exadata shape, ExaCC Elastic shapes and VM Flex shapes.
- available_data_ intstorage_ in_ tbs 
- The maximum DATA storage that can be enabled for this shape.
- available_data_ floatstorage_ per_ server_ in_ tbs 
- The maximum data storage available per storage server for this shape. Only applicable to ExaCC Elastic shapes.
- available_db_ intnode_ per_ node_ in_ gbs 
- The maximum Db Node storage available per database node for this shape. Only applicable to ExaCC Elastic shapes.
- available_db_ intnode_ storage_ in_ gbs 
- The maximum Db Node storage that can be enabled for this shape.
- available_memory_ intin_ gbs 
- The maximum memory that can be enabled for this shape.
- available_memory_ intper_ node_ in_ gbs 
- The maximum memory available per database node for this shape. Only applicable to ExaCC Elastic shapes.
- compute_model str
- The compute model of the Autonomous Database. This is required if using the computeCountparameter. If usingcpuCoreCountthen it is an error to specifycomputeModelto a non-null value. ECPU compute model is the recommended model and OCPU compute model is legacy.
- core_count_ intincrement 
- The discrete number by which the CPU core count for this shape can be increased or decreased.
- display_name str
- The display name of the shape used for the DB system.
- max_storage_ intcount 
- The maximum number of Exadata storage servers available for the Exadata infrastructure.
- maximum_node_ intcount 
- The maximum number of compute servers available for this shape.
- min_core_ intcount_ per_ node 
- The minimum number of CPU cores that can be enabled per node for this shape.
- min_data_ intstorage_ in_ tbs 
- The minimum data storage that need be allocated for this shape.
- min_db_ intnode_ storage_ per_ node_ in_ gbs 
- The minimum Db Node storage that need be allocated per node for this shape.
- min_memory_ intper_ node_ in_ gbs 
- The minimum memory that need be allocated per node for this shape.
- min_storage_ intcount 
- The minimum number of Exadata storage servers available for the Exadata infrastructure.
- minimum_core_ intcount 
- The minimum number of CPU cores that can be enabled on the DB system for this shape.
- minimum_node_ intcount 
- The minimum number of compute servers available for this shape.
- name str
- The name of the shape used for the DB system.
- shape str
- Deprecated. Use nameinstead ofshape.
- shape_family str
- The family of the shape used for the DB system.
- shape_type str
- The shape type for the virtual machine DB system. Shape type is determined by CPU hardware. Valid values are AMD,INTELorINTEL_FLEX_X9.
- areServer BooleanTypes Supported 
- If true, the shape supports configurable DB and Storage Server types.
- availableCore NumberCount 
- The maximum number of CPU cores that can be enabled on the DB system for this shape.
- availableCore NumberCount Per Node 
- The maximum number of CPU cores per database node that can be enabled for this shape. Only applicable to the flex Exadata shape, ExaCC Elastic shapes and VM Flex shapes.
- availableData NumberStorage In Tbs 
- The maximum DATA storage that can be enabled for this shape.
- availableData NumberStorage Per Server In Tbs 
- The maximum data storage available per storage server for this shape. Only applicable to ExaCC Elastic shapes.
- availableDb NumberNode Per Node In Gbs 
- The maximum Db Node storage available per database node for this shape. Only applicable to ExaCC Elastic shapes.
- availableDb NumberNode Storage In Gbs 
- The maximum Db Node storage that can be enabled for this shape.
- availableMemory NumberIn Gbs 
- The maximum memory that can be enabled for this shape.
- availableMemory NumberPer Node In Gbs 
- The maximum memory available per database node for this shape. Only applicable to ExaCC Elastic shapes.
- computeModel String
- The compute model of the Autonomous Database. This is required if using the computeCountparameter. If usingcpuCoreCountthen it is an error to specifycomputeModelto a non-null value. ECPU compute model is the recommended model and OCPU compute model is legacy.
- coreCount NumberIncrement 
- 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.
- maxStorage NumberCount 
- The maximum number of Exadata storage servers available for the Exadata infrastructure.
- maximumNode NumberCount 
- The maximum number of compute servers available for this shape.
- minCore NumberCount Per Node 
- The minimum number of CPU cores that can be enabled per node for this shape.
- minData NumberStorage In Tbs 
- The minimum data storage that need be allocated for this shape.
- minDb NumberNode Storage Per Node In Gbs 
- The minimum Db Node storage that need be allocated per node for this shape.
- minMemory NumberPer Node In Gbs 
- The minimum memory that need be allocated per node for this shape.
- minStorage NumberCount 
- The minimum number of Exadata storage servers available for the Exadata infrastructure.
- minimumCore NumberCount 
- The minimum number of CPU cores that can be enabled on the DB system for this shape.
- minimumNode NumberCount 
- The minimum number of compute servers available for this shape.
- name String
- The name of the shape used for the DB system.
- shape String
- Deprecated. Use nameinstead ofshape.
- shapeFamily String
- The family of the shape used for the DB system.
- shapeType String
- The shape type for the virtual machine DB system. Shape type is determined by CPU hardware. Valid values are AMD,INTELorINTEL_FLEX_X9.
GetDbSystemShapesFilter    
Package Details
- Repository
- oci pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
- This Pulumi package is based on the ociTerraform Provider.