Docs Packages
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Database
  5. getDbSystemShapes
Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi
pulumi/pulumi-oci

oci.Database.getDbSystemShapes

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi
pulumi/pulumi-oci

    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/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[_database.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[_database.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)
// Output-based functions aren't available in Java yet

    fn::invoke:
  function: oci:Database/getDbSystemShapes:getDbSystemShapes
  arguments:
    # arguments dictionary

    The following arguments are supported:

    CompartmentId string
    The compartment OCID.
    AvailabilityDomain string
    The name of the Availability Domain.
    Filters List<GetDbSystemShapesFilter>
    CompartmentId string
    The compartment OCID.
    AvailabilityDomain string
    The name of the Availability Domain.
    Filters []GetDbSystemShapesFilter
    compartmentId String
    The compartment OCID.
    availabilityDomain String
    The name of the Availability Domain.
    filters List<GetDbSystemShapesFilter>
    compartmentId string
    The compartment OCID.
    availabilityDomain string
    The name of the Availability Domain.
    filters GetDbSystemShapesFilter[]
    compartment_id str
    The compartment OCID.
    availability_domain str
    The name of the Availability Domain.
    filters Sequence[database.GetDbSystemShapesFilter]
    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
    DbSystemShapes List<GetDbSystemShapesDbSystemShape>
    The list of db_system_shapes.
    Id string
    The provider-assigned unique ID for this managed resource.
    AvailabilityDomain string
    Filters List<GetDbSystemShapesFilter>
    CompartmentId string
    DbSystemShapes []GetDbSystemShapesDbSystemShape
    The list of db_system_shapes.
    Id string
    The provider-assigned unique ID for this managed resource.
    AvailabilityDomain string
    Filters []GetDbSystemShapesFilter
    compartmentId String
    dbSystemShapes List<GetDbSystemShapesDbSystemShape>
    The list of db_system_shapes.
    id String
    The provider-assigned unique ID for this managed resource.
    availabilityDomain String
    filters List<GetDbSystemShapesFilter>
    compartmentId string
    dbSystemShapes GetDbSystemShapesDbSystemShape[]
    The list of db_system_shapes.
    id string
    The provider-assigned unique ID for this managed resource.
    availabilityDomain string
    filters GetDbSystemShapesFilter[]
    compartment_id str
    db_system_shapes Sequence[database.GetDbSystemShapesDbSystemShape]
    The list of db_system_shapes.
    id str
    The provider-assigned unique ID for this managed resource.
    availability_domain str
    filters Sequence[database.GetDbSystemShapesFilter]
    compartmentId String
    dbSystemShapes List<Property Map>
    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

    AvailableCoreCount int
    The maximum number of CPU cores that can be enabled on the DB system for this shape.
    AvailableCoreCountPerNode int
    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.
    AvailableDataStorageInTbs int
    The maximum DATA storage that can be enabled for this shape.
    AvailableDataStoragePerServerInTbs double
    The maximum data storage available per storage server for this shape. Only applicable to ExaCC Elastic shapes.
    AvailableDbNodePerNodeInGbs int
    The maximum Db Node storage available per database node for this shape. Only applicable to ExaCC Elastic shapes.
    AvailableDbNodeStorageInGbs int
    The maximum Db Node storage that can be enabled for this shape.
    AvailableMemoryInGbs int
    The maximum memory that can be enabled for this shape.
    AvailableMemoryPerNodeInGbs int
    The maximum memory available per database node for this shape. Only applicable to ExaCC Elastic shapes.
    CoreCountIncrement int
    The discrete number by which the CPU core count for this shape can be increased or decreased.
    MaxStorageCount int
    The maximum number of Exadata storage servers available for the Exadata infrastructure.
    MaximumNodeCount int
    The maximum number of compute servers available for this shape.
    MinCoreCountPerNode int
    The minimum number of CPU cores that can be enabled per node for this shape.
    MinDataStorageInTbs int
    The minimum data storage that need be allocated for this shape.
    MinDbNodeStoragePerNodeInGbs int
    The minimum Db Node storage that need be allocated per node for this shape.
    MinMemoryPerNodeInGbs int
    The minimum memory that need be allocated per node for this shape.
    MinStorageCount int
    The minimum number of Exadata storage servers available for the Exadata infrastructure.
    MinimumCoreCount int
    The minimum number of CPU cores that can be enabled on the DB system for this shape.
    MinimumNodeCount int
    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 name instead of shape.

    Deprecated: The 'shape' field has been deprecated. Please use 'name' instead.

    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 , INTEL or INTEL_FLEX_X9.
    AvailableCoreCount int
    The maximum number of CPU cores that can be enabled on the DB system for this shape.
    AvailableCoreCountPerNode int
    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.
    AvailableDataStorageInTbs int
    The maximum DATA storage that can be enabled for this shape.
    AvailableDataStoragePerServerInTbs float64
    The maximum data storage available per storage server for this shape. Only applicable to ExaCC Elastic shapes.
    AvailableDbNodePerNodeInGbs int
    The maximum Db Node storage available per database node for this shape. Only applicable to ExaCC Elastic shapes.
    AvailableDbNodeStorageInGbs int
    The maximum Db Node storage that can be enabled for this shape.
    AvailableMemoryInGbs int
    The maximum memory that can be enabled for this shape.
    AvailableMemoryPerNodeInGbs int
    The maximum memory available per database node for this shape. Only applicable to ExaCC Elastic shapes.
    CoreCountIncrement int
    The discrete number by which the CPU core count for this shape can be increased or decreased.
    MaxStorageCount int
    The maximum number of Exadata storage servers available for the Exadata infrastructure.
    MaximumNodeCount int
    The maximum number of compute servers available for this shape.
    MinCoreCountPerNode int
    The minimum number of CPU cores that can be enabled per node for this shape.
    MinDataStorageInTbs int
    The minimum data storage that need be allocated for this shape.
    MinDbNodeStoragePerNodeInGbs int
    The minimum Db Node storage that need be allocated per node for this shape.
    MinMemoryPerNodeInGbs int
    The minimum memory that need be allocated per node for this shape.
    MinStorageCount int
    The minimum number of Exadata storage servers available for the Exadata infrastructure.
    MinimumCoreCount int
    The minimum number of CPU cores that can be enabled on the DB system for this shape.
    MinimumNodeCount int
    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 name instead of shape.

    Deprecated: The 'shape' field has been deprecated. Please use 'name' instead.

    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 , INTEL or INTEL_FLEX_X9.
    availableCoreCount Integer
    The maximum number of CPU cores that can be enabled on the DB system for this shape.
    availableCoreCountPerNode Integer
    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.
    availableDataStorageInTbs Integer
    The maximum DATA storage that can be enabled for this shape.
    availableDataStoragePerServerInTbs Double
    The maximum data storage available per storage server for this shape. Only applicable to ExaCC Elastic shapes.
    availableDbNodePerNodeInGbs Integer
    The maximum Db Node storage available per database node for this shape. Only applicable to ExaCC Elastic shapes.
    availableDbNodeStorageInGbs Integer
    The maximum Db Node storage that can be enabled for this shape.
    availableMemoryInGbs Integer
    The maximum memory that can be enabled for this shape.
    availableMemoryPerNodeInGbs Integer
    The maximum memory available per database node for this shape. Only applicable to ExaCC Elastic shapes.
    coreCountIncrement Integer
    The discrete number by which the CPU core count for this shape can be increased or decreased.
    maxStorageCount Integer
    The maximum number of Exadata storage servers available for the Exadata infrastructure.
    maximumNodeCount Integer
    The maximum number of compute servers available for this shape.
    minCoreCountPerNode Integer
    The minimum number of CPU cores that can be enabled per node for this shape.
    minDataStorageInTbs Integer
    The minimum data storage that need be allocated for this shape.
    minDbNodeStoragePerNodeInGbs Integer
    The minimum Db Node storage that need be allocated per node for this shape.
    minMemoryPerNodeInGbs Integer
    The minimum memory that need be allocated per node for this shape.
    minStorageCount Integer
    The minimum number of Exadata storage servers available for the Exadata infrastructure.
    minimumCoreCount Integer
    The minimum number of CPU cores that can be enabled on the DB system for this shape.
    minimumNodeCount Integer
    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 name instead of shape.

    Deprecated: The 'shape' field has been deprecated. Please use 'name' instead.

    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 , INTEL or INTEL_FLEX_X9.
    availableCoreCount number
    The maximum number of CPU cores that can be enabled on the DB system for this shape.
    availableCoreCountPerNode number
    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.
    availableDataStorageInTbs number
    The maximum DATA storage that can be enabled for this shape.
    availableDataStoragePerServerInTbs number
    The maximum data storage available per storage server for this shape. Only applicable to ExaCC Elastic shapes.
    availableDbNodePerNodeInGbs number
    The maximum Db Node storage available per database node for this shape. Only applicable to ExaCC Elastic shapes.
    availableDbNodeStorageInGbs number
    The maximum Db Node storage that can be enabled for this shape.
    availableMemoryInGbs number
    The maximum memory that can be enabled for this shape.
    availableMemoryPerNodeInGbs number
    The maximum memory available per database node for this shape. Only applicable to ExaCC Elastic shapes.
    coreCountIncrement number
    The discrete number by which the CPU core count for this shape can be increased or decreased.
    maxStorageCount number
    The maximum number of Exadata storage servers available for the Exadata infrastructure.
    maximumNodeCount number
    The maximum number of compute servers available for this shape.
    minCoreCountPerNode number
    The minimum number of CPU cores that can be enabled per node for this shape.
    minDataStorageInTbs number
    The minimum data storage that need be allocated for this shape.
    minDbNodeStoragePerNodeInGbs number
    The minimum Db Node storage that need be allocated per node for this shape.
    minMemoryPerNodeInGbs number
    The minimum memory that need be allocated per node for this shape.
    minStorageCount number
    The minimum number of Exadata storage servers available for the Exadata infrastructure.
    minimumCoreCount number
    The minimum number of CPU cores that can be enabled on the DB system for this shape.
    minimumNodeCount number
    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 name instead of shape.

    Deprecated: The 'shape' field has been deprecated. Please use 'name' instead.

    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 , INTEL or INTEL_FLEX_X9.
    available_core_count int
    The maximum number of CPU cores that can be enabled on the DB system for this shape.
    available_core_count_per_node int
    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_storage_in_tbs int
    The maximum DATA storage that can be enabled for this shape.
    available_data_storage_per_server_in_tbs float
    The maximum data storage available per storage server for this shape. Only applicable to ExaCC Elastic shapes.
    available_db_node_per_node_in_gbs int
    The maximum Db Node storage available per database node for this shape. Only applicable to ExaCC Elastic shapes.
    available_db_node_storage_in_gbs int
    The maximum Db Node storage that can be enabled for this shape.
    available_memory_in_gbs int
    The maximum memory that can be enabled for this shape.
    available_memory_per_node_in_gbs int
    The maximum memory available per database node for this shape. Only applicable to ExaCC Elastic shapes.
    core_count_increment int
    The discrete number by which the CPU core count for this shape can be increased or decreased.
    max_storage_count int
    The maximum number of Exadata storage servers available for the Exadata infrastructure.
    maximum_node_count int
    The maximum number of compute servers available for this shape.
    min_core_count_per_node int
    The minimum number of CPU cores that can be enabled per node for this shape.
    min_data_storage_in_tbs int
    The minimum data storage that need be allocated for this shape.
    min_db_node_storage_per_node_in_gbs int
    The minimum Db Node storage that need be allocated per node for this shape.
    min_memory_per_node_in_gbs int
    The minimum memory that need be allocated per node for this shape.
    min_storage_count int
    The minimum number of Exadata storage servers available for the Exadata infrastructure.
    minimum_core_count int
    The minimum number of CPU cores that can be enabled on the DB system for this shape.
    minimum_node_count int
    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 name instead of shape.

    Deprecated: The 'shape' field has been deprecated. Please use 'name' instead.

    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 , INTEL or INTEL_FLEX_X9.
    availableCoreCount Number
    The maximum number of CPU cores that can be enabled on the DB system for this shape.
    availableCoreCountPerNode Number
    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.
    availableDataStorageInTbs Number
    The maximum DATA storage that can be enabled for this shape.
    availableDataStoragePerServerInTbs Number
    The maximum data storage available per storage server for this shape. Only applicable to ExaCC Elastic shapes.
    availableDbNodePerNodeInGbs Number
    The maximum Db Node storage available per database node for this shape. Only applicable to ExaCC Elastic shapes.
    availableDbNodeStorageInGbs Number
    The maximum Db Node storage that can be enabled for this shape.
    availableMemoryInGbs Number
    The maximum memory that can be enabled for this shape.
    availableMemoryPerNodeInGbs Number
    The maximum memory available per database node for this shape. Only applicable to ExaCC Elastic shapes.
    coreCountIncrement Number
    The discrete number by which the CPU core count for this shape can be increased or decreased.
    maxStorageCount Number
    The maximum number of Exadata storage servers available for the Exadata infrastructure.
    maximumNodeCount Number
    The maximum number of compute servers available for this shape.
    minCoreCountPerNode Number
    The minimum number of CPU cores that can be enabled per node for this shape.
    minDataStorageInTbs Number
    The minimum data storage that need be allocated for this shape.
    minDbNodeStoragePerNodeInGbs Number
    The minimum Db Node storage that need be allocated per node for this shape.
    minMemoryPerNodeInGbs Number
    The minimum memory that need be allocated per node for this shape.
    minStorageCount Number
    The minimum number of Exadata storage servers available for the Exadata infrastructure.
    minimumCoreCount Number
    The minimum number of CPU cores that can be enabled on the DB system for this shape.
    minimumNodeCount Number
    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 name instead of shape.

    Deprecated: The 'shape' field has been deprecated. Please use 'name' instead.

    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 , INTEL or INTEL_FLEX_X9.

    GetDbSystemShapesFilter

    Name string
    The name of the shape used for the DB system.
    Values List<string>
    Regex bool
    Name string
    The name of the shape used for the DB system.
    Values []string
    Regex bool
    name String
    The name of the shape used for the DB system.
    values List<String>
    regex Boolean
    name string
    The name of the shape used for the DB system.
    values string[]
    regex boolean
    name str
    The name of the shape used for the DB system.
    values Sequence[str]
    regex bool
    name String
    The name of the shape used for the DB system.
    values List<String>
    regex Boolean

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v1.41.0 published on Wednesday, Jun 19, 2024 by Pulumi
    pulumi/pulumi-oci