1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. Database
  5. getDbSystemStoragePerformances
Oracle Cloud Infrastructure v3.10.0 published on Wednesday, Nov 5, 2025 by Pulumi
pulumi/pulumi-oci

oci.Database.getDbSystemStoragePerformances

Start a Neo task
Explain and create an oci.Database.getDbSystemStoragePerformances resource
oci logo
Oracle Cloud Infrastructure v3.10.0 published on Wednesday, Nov 5, 2025 by Pulumi
pulumi/pulumi-oci

    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

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

const testDbSystemStoragePerformances = oci.Database.getDbSystemStoragePerformances({
    storageManagement: dbSystemStoragePerformanceStorageManagement,
    shapeType: dbSystemStoragePerformanceShapeType,
    databaseEdition: dbSystemStoragePerformanceDatabaseEdition,
    compartmentId: compartmentId,
});

    import pulumi
import pulumi_oci as oci

test_db_system_storage_performances = oci.Database.get_db_system_storage_performances(storage_management=db_system_storage_performance_storage_management,
    shape_type=db_system_storage_performance_shape_type,
    database_edition=db_system_storage_performance_database_edition,
    compartment_id=compartment_id)

    package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v3/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: dbSystemStoragePerformanceStorageManagement,
			ShapeType:         pulumi.StringRef(dbSystemStoragePerformanceShapeType),
			DatabaseEdition:   pulumi.StringRef(dbSystemStoragePerformanceDatabaseEdition),
			CompartmentId:     pulumi.StringRef(compartmentId),
		}, 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 testDbSystemStoragePerformances = Oci.Database.GetDbSystemStoragePerformances.Invoke(new()
    {
        StorageManagement = dbSystemStoragePerformanceStorageManagement,
        ShapeType = dbSystemStoragePerformanceShapeType,
        DatabaseEdition = dbSystemStoragePerformanceDatabaseEdition,
        CompartmentId = compartmentId,
    });

});

    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(dbSystemStoragePerformanceStorageManagement)
            .shapeType(dbSystemStoragePerformanceShapeType)
            .databaseEdition(dbSystemStoragePerformanceDatabaseEdition)
            .compartmentId(compartmentId)
            .build());

    }
}

    variables:
  testDbSystemStoragePerformances:
    fn::invoke:
      function: oci:Database:getDbSystemStoragePerformances
      arguments:
        storageManagement: ${dbSystemStoragePerformanceStorageManagement}
        shapeType: ${dbSystemStoragePerformanceShapeType}
        databaseEdition: ${dbSystemStoragePerformanceDatabaseEdition}
        compartmentId: ${compartmentId}

    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(compartment_id: Optional[str] = None,
                                       database_edition: Optional[str] = None,
                                       filters: Optional[Sequence[GetDbSystemStoragePerformancesFilter]] = None,
                                       shape_type: Optional[str] = None,
                                       storage_management: Optional[str] = None,
                                       opts: Optional[InvokeOptions] = None) -> GetDbSystemStoragePerformancesResult
def get_db_system_storage_performances_output(compartment_id: Optional[pulumi.Input[str]] = None,
                                       database_edition: Optional[pulumi.Input[str]] = None,
                                       filters: Optional[pulumi.Input[Sequence[pulumi.Input[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)
public static Output<GetDbSystemStoragePerformancesResult> getDbSystemStoragePerformances(GetDbSystemStoragePerformancesArgs args, InvokeOptions options)

    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.
    CompartmentId string
    Optional. The OCID of the compartment.
    DatabaseEdition string
    Optional. Filters the performance results by database edition. Valid values are:

    • STANDARD_EDITION
    • ENTERPRISE_EDITION
    • ENTERPRISE_EDITION_HIGH_PERFORMANCE
    • ENTERPRISE_EDITION_EXTREME_PERFORMANCE
    • ENTERPRISE_EDITION_DEVELOPER
    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.
    CompartmentId string
    Optional. The OCID of the compartment.
    DatabaseEdition string
    Optional. Filters the performance results by database edition. Valid values are:

    • STANDARD_EDITION
    • ENTERPRISE_EDITION
    • ENTERPRISE_EDITION_HIGH_PERFORMANCE
    • ENTERPRISE_EDITION_EXTREME_PERFORMANCE
    • ENTERPRISE_EDITION_DEVELOPER
    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.
    compartmentId String
    Optional. The OCID of the compartment.
    databaseEdition String
    Optional. Filters the performance results by database edition. Valid values are:

    • STANDARD_EDITION
    • ENTERPRISE_EDITION
    • ENTERPRISE_EDITION_HIGH_PERFORMANCE
    • ENTERPRISE_EDITION_EXTREME_PERFORMANCE
    • ENTERPRISE_EDITION_DEVELOPER
    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.
    compartmentId string
    Optional. The OCID of the compartment.
    databaseEdition string
    Optional. Filters the performance results by database edition. Valid values are:

    • STANDARD_EDITION
    • ENTERPRISE_EDITION
    • ENTERPRISE_EDITION_HIGH_PERFORMANCE
    • ENTERPRISE_EDITION_EXTREME_PERFORMANCE
    • ENTERPRISE_EDITION_DEVELOPER
    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.
    compartment_id str
    Optional. The OCID of the compartment.
    database_edition str
    Optional. Filters the performance results by database edition. Valid values are:

    • STANDARD_EDITION
    • ENTERPRISE_EDITION
    • ENTERPRISE_EDITION_HIGH_PERFORMANCE
    • ENTERPRISE_EDITION_EXTREME_PERFORMANCE
    • ENTERPRISE_EDITION_DEVELOPER
    filters Sequence[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.
    compartmentId String
    Optional. The OCID of the compartment.
    databaseEdition String
    Optional. Filters the performance results by database edition. Valid values are:

    • STANDARD_EDITION
    • ENTERPRISE_EDITION
    • ENTERPRISE_EDITION_HIGH_PERFORMANCE
    • ENTERPRISE_EDITION_EXTREME_PERFORMANCE
    • ENTERPRISE_EDITION_DEVELOPER
    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
    CompartmentId string
    DatabaseEdition 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
    CompartmentId string
    DatabaseEdition 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
    compartmentId String
    databaseEdition 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
    compartmentId string
    databaseEdition string
    filters GetDbSystemStoragePerformancesFilter[]
    shapeType string
    ShapeType of the DbSystems,INTEL or AMD
    db_system_storage_performances Sequence[GetDbSystemStoragePerformancesDbSystemStoragePerformance]
    The list of db_system_storage_performances.
    id str
    The provider-assigned unique ID for this managed resource.
    storage_management str
    compartment_id str
    database_edition str
    filters Sequence[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
    compartmentId String
    databaseEdition 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.
    oci logo
    Oracle Cloud Infrastructure v3.10.0 published on Wednesday, Nov 5, 2025 by Pulumi
    pulumi/pulumi-oci
      Meet Neo: Your AI Platform Teammate