Oracle Cloud Infrastructure v1.16.0, Nov 2 23

Oracle Cloud Infrastructure v1.16.0 published on Thursday, Nov 2, 2023 by Pulumi

oci.Database.getDbSystemShapes

Explore with Pulumi AI

Oracle Cloud Infrastructure v1.16.0 published on Thursday, Nov 2, 2023 by Pulumi

Example Usage

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 = @var.Compartment_id,
        AvailabilityDomain = @var.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:      _var.Compartment_id,
			AvailabilityDomain: pulumi.StringRef(_var.Db_system_shape_availability_domain),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

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(var_.compartment_id())
            .availabilityDomain(var_.db_system_shape_availability_domain())
            .build());

    }
}

import pulumi
import pulumi_oci as oci

test_db_system_shapes = oci.Database.get_db_system_shapes(compartment_id=var["compartment_id"],
    availability_domain=var["db_system_shape_availability_domain"])

import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testDbSystemShapes = oci.Database.getDbSystemShapes({
    compartmentId: _var.compartment_id,
    availabilityDomain: _var.db_system_shape_availability_domain,
});

variables:
  testDbSystemShapes:
    fn::invoke:
      Function: oci:Database:getDbSystemShapes
      Arguments:
        compartmentId: ${var.compartment_id}
        availabilityDomain: ${var.db_system_shape_availability_domain}

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 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 GetDbSystemShapesDbSystemShape]: The list of db_system_shapes.
id str: The provider-assigned unique ID for this managed resource.
availability_domain str
filters 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