oci logo
Oracle Cloud Infrastructure v0.19.0, May 26 23

oci.Database.getDbSystemStoragePerformances

Explore with Pulumi AI

This data source provides the list of Db System Storage Performances in Oracle Cloud Infrastructure Database service.

Gets a list of possible expected storage performance parameters of a VMDB System based on Configuration.

Example Usage

using System.Collections.Generic;
using System.Linq;
using Pulumi;
using Oci = Pulumi.Oci;

return await Deployment.RunAsync(() => 
{
    var testDbSystemStoragePerformances = Oci.Database.GetDbSystemStoragePerformances.Invoke(new()
    {
        StorageManagement = @var.Db_system_storage_performance_storage_management,
        ShapeType = @var.Db_system_storage_performance_shape_type,
    });

});
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.GetDbSystemStoragePerformances(ctx, &database.GetDbSystemStoragePerformancesArgs{
			StorageManagement: _var.Db_system_storage_performance_storage_management,
			ShapeType:         pulumi.StringRef(_var.Db_system_storage_performance_shape_type),
		}, 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.GetDbSystemStoragePerformancesArgs;
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 testDbSystemStoragePerformances = DatabaseFunctions.getDbSystemStoragePerformances(GetDbSystemStoragePerformancesArgs.builder()
            .storageManagement(var_.db_system_storage_performance_storage_management())
            .shapeType(var_.db_system_storage_performance_shape_type())
            .build());

    }
}
import pulumi
import pulumi_oci as oci

test_db_system_storage_performances = oci.Database.get_db_system_storage_performances(storage_management=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference),
    shape_type=%!v(PANIC=Format method: runtime error: invalid memory address or nil pointer dereference))
import * as pulumi from "@pulumi/pulumi";
import * as oci from "@pulumi/oci";

const testDbSystemStoragePerformances = oci.Database.getDbSystemStoragePerformances({
    storageManagement: _var.db_system_storage_performance_storage_management,
    shapeType: _var.db_system_storage_performance_shape_type,
});
variables:
  testDbSystemStoragePerformances:
    fn::invoke:
      Function: oci:Database:getDbSystemStoragePerformances
      Arguments:
        storageManagement: ${var.db_system_storage_performance_storage_management}
        shapeType: ${var.db_system_storage_performance_shape_type}

Using getDbSystemStoragePerformances

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 getDbSystemStoragePerformances(args: GetDbSystemStoragePerformancesArgs, opts?: InvokeOptions): Promise<GetDbSystemStoragePerformancesResult>
function getDbSystemStoragePerformancesOutput(args: GetDbSystemStoragePerformancesOutputArgs, opts?: InvokeOptions): Output<GetDbSystemStoragePerformancesResult>
def get_db_system_storage_performances(filters: Optional[Sequence[_database.GetDbSystemStoragePerformancesFilter]] = None,
                                       shape_type: Optional[str] = None,
                                       storage_management: Optional[str] = None,
                                       opts: Optional[InvokeOptions] = None) -> GetDbSystemStoragePerformancesResult
def get_db_system_storage_performances_output(filters: Optional[pulumi.Input[Sequence[pulumi.Input[_database.GetDbSystemStoragePerformancesFilterArgs]]]] = None,
                                       shape_type: Optional[pulumi.Input[str]] = None,
                                       storage_management: Optional[pulumi.Input[str]] = None,
                                       opts: Optional[InvokeOptions] = None) -> Output[GetDbSystemStoragePerformancesResult]
func GetDbSystemStoragePerformances(ctx *Context, args *GetDbSystemStoragePerformancesArgs, opts ...InvokeOption) (*GetDbSystemStoragePerformancesResult, error)
func GetDbSystemStoragePerformancesOutput(ctx *Context, args *GetDbSystemStoragePerformancesOutputArgs, opts ...InvokeOption) GetDbSystemStoragePerformancesResultOutput

> Note: This function is named GetDbSystemStoragePerformances in the Go SDK.

public static class GetDbSystemStoragePerformances 
{
    public static Task<GetDbSystemStoragePerformancesResult> InvokeAsync(GetDbSystemStoragePerformancesArgs args, InvokeOptions? opts = null)
    public static Output<GetDbSystemStoragePerformancesResult> Invoke(GetDbSystemStoragePerformancesInvokeArgs args, InvokeOptions? opts = null)
}
public static CompletableFuture<GetDbSystemStoragePerformancesResult> getDbSystemStoragePerformances(GetDbSystemStoragePerformancesArgs args, InvokeOptions options)
// Output-based functions aren't available in Java yet
fn::invoke:
  function: oci:Database/getDbSystemStoragePerformances:getDbSystemStoragePerformances
  arguments:
    # arguments dictionary

The following arguments are supported:

StorageManagement string

The DB system storage management option. Used to list database versions available for that storage manager. Valid values are ASM and LVM.

  • ASM specifies Oracle Automatic Storage Management
  • LVM specifies logical volume manager, sometimes called logical disk manager.
Filters List<GetDbSystemStoragePerformancesFilter>
ShapeType string

Optional. Filters the performance results by shape type.

StorageManagement string

The DB system storage management option. Used to list database versions available for that storage manager. Valid values are ASM and LVM.

  • ASM specifies Oracle Automatic Storage Management
  • LVM specifies logical volume manager, sometimes called logical disk manager.
Filters []GetDbSystemStoragePerformancesFilter
ShapeType string

Optional. Filters the performance results by shape type.

storageManagement String

The DB system storage management option. Used to list database versions available for that storage manager. Valid values are ASM and LVM.

  • ASM specifies Oracle Automatic Storage Management
  • LVM specifies logical volume manager, sometimes called logical disk manager.
filters List<GetDbSystemStoragePerformancesFilter>
shapeType String

Optional. Filters the performance results by shape type.

storageManagement string

The DB system storage management option. Used to list database versions available for that storage manager. Valid values are ASM and LVM.

  • ASM specifies Oracle Automatic Storage Management
  • LVM specifies logical volume manager, sometimes called logical disk manager.
filters GetDbSystemStoragePerformancesFilter[]
shapeType string

Optional. Filters the performance results by shape type.

storage_management str

The DB system storage management option. Used to list database versions available for that storage manager. Valid values are ASM and LVM.

  • ASM specifies Oracle Automatic Storage Management
  • LVM specifies logical volume manager, sometimes called logical disk manager.
filters GetDbSystemStoragePerformancesFilter]
shape_type str

Optional. Filters the performance results by shape type.

storageManagement String

The DB system storage management option. Used to list database versions available for that storage manager. Valid values are ASM and LVM.

  • ASM specifies Oracle Automatic Storage Management
  • LVM specifies logical volume manager, sometimes called logical disk manager.
filters List<Property Map>
shapeType String

Optional. Filters the performance results by shape type.

getDbSystemStoragePerformances Result

The following output properties are available:

DbSystemStoragePerformances List<GetDbSystemStoragePerformancesDbSystemStoragePerformance>

The list of db_system_storage_performances.

Id string

The provider-assigned unique ID for this managed resource.

StorageManagement string
Filters List<GetDbSystemStoragePerformancesFilter>
ShapeType string

ShapeType of the DbSystems,INTEL or AMD

DbSystemStoragePerformances []GetDbSystemStoragePerformancesDbSystemStoragePerformance

The list of db_system_storage_performances.

Id string

The provider-assigned unique ID for this managed resource.

StorageManagement string
Filters []GetDbSystemStoragePerformancesFilter
ShapeType string

ShapeType of the DbSystems,INTEL or AMD

dbSystemStoragePerformances List<GetDbSystemStoragePerformancesDbSystemStoragePerformance>

The list of db_system_storage_performances.

id String

The provider-assigned unique ID for this managed resource.

storageManagement String
filters List<GetDbSystemStoragePerformancesFilter>
shapeType String

ShapeType of the DbSystems,INTEL or AMD

dbSystemStoragePerformances GetDbSystemStoragePerformancesDbSystemStoragePerformance[]

The list of db_system_storage_performances.

id string

The provider-assigned unique ID for this managed resource.

storageManagement string
filters GetDbSystemStoragePerformancesFilter[]
shapeType string

ShapeType of the DbSystems,INTEL or AMD

db_system_storage_performances GetDbSystemStoragePerformancesDbSystemStoragePerformance]

The list of db_system_storage_performances.

id str

The provider-assigned unique ID for this managed resource.

storage_management str
filters GetDbSystemStoragePerformancesFilter]
shape_type str

ShapeType of the DbSystems,INTEL or AMD

dbSystemStoragePerformances List<Property Map>

The list of db_system_storage_performances.

id String

The provider-assigned unique ID for this managed resource.

storageManagement String
filters List<Property Map>
shapeType String

ShapeType of the DbSystems,INTEL or AMD

Supporting Types

GetDbSystemStoragePerformancesDbSystemStoragePerformance

DataStoragePerformanceLists []GetDbSystemStoragePerformancesDbSystemStoragePerformanceDataStoragePerformanceList

List of storage performance for the DATA disks

RecoStoragePerformanceLists []GetDbSystemStoragePerformancesDbSystemStoragePerformanceRecoStoragePerformanceList

List of storage performance for the RECO disks

ShapeType string

Optional. Filters the performance results by shape type.

dataStoragePerformanceLists GetDbSystemStoragePerformancesDbSystemStoragePerformanceDataStoragePerformanceList[]

List of storage performance for the DATA disks

recoStoragePerformanceLists GetDbSystemStoragePerformancesDbSystemStoragePerformanceRecoStoragePerformanceList[]

List of storage performance for the RECO disks

shapeType string

Optional. Filters the performance results by shape type.

dataStoragePerformanceLists List<Property Map>

List of storage performance for the DATA disks

recoStoragePerformanceLists List<Property Map>

List of storage performance for the RECO disks

shapeType String

Optional. Filters the performance results by shape type.

GetDbSystemStoragePerformancesDbSystemStoragePerformanceDataStoragePerformanceList

balancedDiskPerformances List<Property Map>

Representation of disk performance detail parameters.

highDiskPerformances List<Property Map>

Representation of disk performance detail parameters.

sizeInGbs Number

Size in GBs.

GetDbSystemStoragePerformancesDbSystemStoragePerformanceDataStoragePerformanceListBalancedDiskPerformance

DiskIops double

Disk IOPS in thousands.

DiskThroughputInMbps double

Disk Throughput in Mbps.

DiskIops float64

Disk IOPS in thousands.

DiskThroughputInMbps float64

Disk Throughput in Mbps.

diskIops Double

Disk IOPS in thousands.

diskThroughputInMbps Double

Disk Throughput in Mbps.

diskIops number

Disk IOPS in thousands.

diskThroughputInMbps number

Disk Throughput in Mbps.

disk_iops float

Disk IOPS in thousands.

disk_throughput_in_mbps float

Disk Throughput in Mbps.

diskIops Number

Disk IOPS in thousands.

diskThroughputInMbps Number

Disk Throughput in Mbps.

GetDbSystemStoragePerformancesDbSystemStoragePerformanceDataStoragePerformanceListHighDiskPerformance

DiskIops double

Disk IOPS in thousands.

DiskThroughputInMbps double

Disk Throughput in Mbps.

DiskIops float64

Disk IOPS in thousands.

DiskThroughputInMbps float64

Disk Throughput in Mbps.

diskIops Double

Disk IOPS in thousands.

diskThroughputInMbps Double

Disk Throughput in Mbps.

diskIops number

Disk IOPS in thousands.

diskThroughputInMbps number

Disk Throughput in Mbps.

disk_iops float

Disk IOPS in thousands.

disk_throughput_in_mbps float

Disk Throughput in Mbps.

diskIops Number

Disk IOPS in thousands.

diskThroughputInMbps Number

Disk Throughput in Mbps.

GetDbSystemStoragePerformancesDbSystemStoragePerformanceRecoStoragePerformanceList

balancedDiskPerformances List<Property Map>

Representation of disk performance detail parameters.

highDiskPerformances List<Property Map>

Representation of disk performance detail parameters.

sizeInGbs Number

Size in GBs.

GetDbSystemStoragePerformancesDbSystemStoragePerformanceRecoStoragePerformanceListBalancedDiskPerformance

DiskIops double

Disk IOPS in thousands.

DiskThroughputInMbps double

Disk Throughput in Mbps.

DiskIops float64

Disk IOPS in thousands.

DiskThroughputInMbps float64

Disk Throughput in Mbps.

diskIops Double

Disk IOPS in thousands.

diskThroughputInMbps Double

Disk Throughput in Mbps.

diskIops number

Disk IOPS in thousands.

diskThroughputInMbps number

Disk Throughput in Mbps.

disk_iops float

Disk IOPS in thousands.

disk_throughput_in_mbps float

Disk Throughput in Mbps.

diskIops Number

Disk IOPS in thousands.

diskThroughputInMbps Number

Disk Throughput in Mbps.

GetDbSystemStoragePerformancesDbSystemStoragePerformanceRecoStoragePerformanceListHighDiskPerformance

DiskIops double

Disk IOPS in thousands.

DiskThroughputInMbps double

Disk Throughput in Mbps.

DiskIops float64

Disk IOPS in thousands.

DiskThroughputInMbps float64

Disk Throughput in Mbps.

diskIops Double

Disk IOPS in thousands.

diskThroughputInMbps Double

Disk Throughput in Mbps.

diskIops number

Disk IOPS in thousands.

diskThroughputInMbps number

Disk Throughput in Mbps.

disk_iops float

Disk IOPS in thousands.

disk_throughput_in_mbps float

Disk Throughput in Mbps.

diskIops Number

Disk IOPS in thousands.

diskThroughputInMbps Number

Disk Throughput in Mbps.

GetDbSystemStoragePerformancesFilter

Name string
Values List<string>
Regex bool
Name string
Values []string
Regex bool
name String
values List<String>
regex Boolean
name string
values string[]
regex boolean
name str
values Sequence[str]
regex bool
name String
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.