Docs Home Pulumi IaC Pulumi ESC Pulumi Insights Pulumi Cloud Packages Tutorials
  1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabasesDatabaseParameter
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

oci.DatabaseManagement.getManagedDatabasesDatabaseParameter

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v2.33.0 published on Thursday, May 1, 2025 by Pulumi
pulumi/pulumi-oci

    This data source provides details about a specific Managed Databases Database Parameter resource in Oracle Cloud Infrastructure Database Management service.

    Gets the list of database parameters for the specified Managed Database. The parameters are listed in alphabetical order, along with their current values.

    Example Usage

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

const testManagedDatabasesDatabaseParameter = oci.DatabaseManagement.getManagedDatabasesDatabaseParameter({
    managedDatabaseId: testManagedDatabase.id,
    isAllowedValuesIncluded: managedDatabasesDatabaseParameterIsAllowedValuesIncluded,
    name: managedDatabasesDatabaseParameterName,
    source: managedDatabasesDatabaseParameterSource,
});

    import pulumi
import pulumi_oci as oci

test_managed_databases_database_parameter = oci.DatabaseManagement.get_managed_databases_database_parameter(managed_database_id=test_managed_database["id"],
    is_allowed_values_included=managed_databases_database_parameter_is_allowed_values_included,
    name=managed_databases_database_parameter_name,
    source=managed_databases_database_parameter_source)

    package main

import (
	"github.com/pulumi/pulumi-oci/sdk/v2/go/oci/databasemanagement"
	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)

func main() {
	pulumi.Run(func(ctx *pulumi.Context) error {
		_, err := databasemanagement.GetManagedDatabasesDatabaseParameter(ctx, &databasemanagement.GetManagedDatabasesDatabaseParameterArgs{
			ManagedDatabaseId:       testManagedDatabase.Id,
			IsAllowedValuesIncluded: pulumi.BoolRef(managedDatabasesDatabaseParameterIsAllowedValuesIncluded),
			Name:                    pulumi.StringRef(managedDatabasesDatabaseParameterName),
			Source:                  pulumi.StringRef(managedDatabasesDatabaseParameterSource),
		}, 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 testManagedDatabasesDatabaseParameter = Oci.DatabaseManagement.GetManagedDatabasesDatabaseParameter.Invoke(new()
    {
        ManagedDatabaseId = testManagedDatabase.Id,
        IsAllowedValuesIncluded = managedDatabasesDatabaseParameterIsAllowedValuesIncluded,
        Name = managedDatabasesDatabaseParameterName,
        Source = managedDatabasesDatabaseParameterSource,
    });

});

    package generated_program;

import com.pulumi.Context;
import com.pulumi.Pulumi;
import com.pulumi.core.Output;
import com.pulumi.oci.DatabaseManagement.DatabaseManagementFunctions;
import com.pulumi.oci.DatabaseManagement.inputs.GetManagedDatabasesDatabaseParameterArgs;
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 testManagedDatabasesDatabaseParameter = DatabaseManagementFunctions.getManagedDatabasesDatabaseParameter(GetManagedDatabasesDatabaseParameterArgs.builder()
            .managedDatabaseId(testManagedDatabase.id())
            .isAllowedValuesIncluded(managedDatabasesDatabaseParameterIsAllowedValuesIncluded)
            .name(managedDatabasesDatabaseParameterName)
            .source(managedDatabasesDatabaseParameterSource)
            .build());

    }
}

    variables:
  testManagedDatabasesDatabaseParameter:
    fn::invoke:
      function: oci:DatabaseManagement:getManagedDatabasesDatabaseParameter
      arguments:
        managedDatabaseId: ${testManagedDatabase.id}
        isAllowedValuesIncluded: ${managedDatabasesDatabaseParameterIsAllowedValuesIncluded}
        name: ${managedDatabasesDatabaseParameterName}
        source: ${managedDatabasesDatabaseParameterSource}

    Using getManagedDatabasesDatabaseParameter

    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 getManagedDatabasesDatabaseParameter(args: GetManagedDatabasesDatabaseParameterArgs, opts?: InvokeOptions): Promise<GetManagedDatabasesDatabaseParameterResult>
function getManagedDatabasesDatabaseParameterOutput(args: GetManagedDatabasesDatabaseParameterOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabasesDatabaseParameterResult>
    def get_managed_databases_database_parameter(is_allowed_values_included: Optional[bool] = None,
                                             managed_database_id: Optional[str] = None,
                                             name: Optional[str] = None,
                                             source: Optional[str] = None,
                                             opts: Optional[InvokeOptions] = None) -> GetManagedDatabasesDatabaseParameterResult
def get_managed_databases_database_parameter_output(is_allowed_values_included: Optional[pulumi.Input[bool]] = None,
                                             managed_database_id: Optional[pulumi.Input[str]] = None,
                                             name: Optional[pulumi.Input[str]] = None,
                                             source: Optional[pulumi.Input[str]] = None,
                                             opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabasesDatabaseParameterResult]
    func GetManagedDatabasesDatabaseParameter(ctx *Context, args *GetManagedDatabasesDatabaseParameterArgs, opts ...InvokeOption) (*GetManagedDatabasesDatabaseParameterResult, error)
func GetManagedDatabasesDatabaseParameterOutput(ctx *Context, args *GetManagedDatabasesDatabaseParameterOutputArgs, opts ...InvokeOption) GetManagedDatabasesDatabaseParameterResultOutput

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

    public static class GetManagedDatabasesDatabaseParameter 
{
    public static Task<GetManagedDatabasesDatabaseParameterResult> InvokeAsync(GetManagedDatabasesDatabaseParameterArgs args, InvokeOptions? opts = null)
    public static Output<GetManagedDatabasesDatabaseParameterResult> Invoke(GetManagedDatabasesDatabaseParameterInvokeArgs args, InvokeOptions? opts = null)
}
    public static CompletableFuture<GetManagedDatabasesDatabaseParameterResult> getManagedDatabasesDatabaseParameter(GetManagedDatabasesDatabaseParameterArgs args, InvokeOptions options)
public static Output<GetManagedDatabasesDatabaseParameterResult> getManagedDatabasesDatabaseParameter(GetManagedDatabasesDatabaseParameterArgs args, InvokeOptions options)

    fn::invoke:
  function: oci:DatabaseManagement/getManagedDatabasesDatabaseParameter:getManagedDatabasesDatabaseParameter
  arguments:
    # arguments dictionary

    The following arguments are supported:

    ManagedDatabaseId string
    The OCID of the Managed Database.
    IsAllowedValuesIncluded bool
    When true, results include a list of valid values for parameters (if applicable).
    Name string
    A filter to return all parameters that have the text given in their names.
    Source string
    The source used to list database parameters. CURRENT is used to get the database parameters that are currently in effect for the database instance. SPFILE is used to list parameters from the server parameter file. Default is CURRENT.
    ManagedDatabaseId string
    The OCID of the Managed Database.
    IsAllowedValuesIncluded bool
    When true, results include a list of valid values for parameters (if applicable).
    Name string
    A filter to return all parameters that have the text given in their names.
    Source string
    The source used to list database parameters. CURRENT is used to get the database parameters that are currently in effect for the database instance. SPFILE is used to list parameters from the server parameter file. Default is CURRENT.
    managedDatabaseId String
    The OCID of the Managed Database.
    isAllowedValuesIncluded Boolean
    When true, results include a list of valid values for parameters (if applicable).
    name String
    A filter to return all parameters that have the text given in their names.
    source String
    The source used to list database parameters. CURRENT is used to get the database parameters that are currently in effect for the database instance. SPFILE is used to list parameters from the server parameter file. Default is CURRENT.
    managedDatabaseId string
    The OCID of the Managed Database.
    isAllowedValuesIncluded boolean
    When true, results include a list of valid values for parameters (if applicable).
    name string
    A filter to return all parameters that have the text given in their names.
    source string
    The source used to list database parameters. CURRENT is used to get the database parameters that are currently in effect for the database instance. SPFILE is used to list parameters from the server parameter file. Default is CURRENT.
    managed_database_id str
    The OCID of the Managed Database.
    is_allowed_values_included bool
    When true, results include a list of valid values for parameters (if applicable).
    name str
    A filter to return all parameters that have the text given in their names.
    source str
    The source used to list database parameters. CURRENT is used to get the database parameters that are currently in effect for the database instance. SPFILE is used to list parameters from the server parameter file. Default is CURRENT.
    managedDatabaseId String
    The OCID of the Managed Database.
    isAllowedValuesIncluded Boolean
    When true, results include a list of valid values for parameters (if applicable).
    name String
    A filter to return all parameters that have the text given in their names.
    source String
    The source used to list database parameters. CURRENT is used to get the database parameters that are currently in effect for the database instance. SPFILE is used to list parameters from the server parameter file. Default is CURRENT.

    getManagedDatabasesDatabaseParameter Result

    The following output properties are available:

    DatabaseName string
    The name of the Managed Database.
    DatabaseSubType string
    The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, or a Non-container Database.
    DatabaseType string
    The type of Oracle Database installation.
    DatabaseVersion string
    The Oracle Database version.
    Id string
    The provider-assigned unique ID for this managed resource.
    Items List<GetManagedDatabasesDatabaseParameterItem>
    An array of DatabaseParameterSummary objects.
    ManagedDatabaseId string
    IsAllowedValuesIncluded bool
    Name string
    The parameter name.
    Source string
    DatabaseName string
    The name of the Managed Database.
    DatabaseSubType string
    The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, or a Non-container Database.
    DatabaseType string
    The type of Oracle Database installation.
    DatabaseVersion string
    The Oracle Database version.
    Id string
    The provider-assigned unique ID for this managed resource.
    Items []GetManagedDatabasesDatabaseParameterItem
    An array of DatabaseParameterSummary objects.
    ManagedDatabaseId string
    IsAllowedValuesIncluded bool
    Name string
    The parameter name.
    Source string
    databaseName String
    The name of the Managed Database.
    databaseSubType String
    The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, or a Non-container Database.
    databaseType String
    The type of Oracle Database installation.
    databaseVersion String
    The Oracle Database version.
    id String
    The provider-assigned unique ID for this managed resource.
    items List<GetManagedDatabasesDatabaseParameterItem>
    An array of DatabaseParameterSummary objects.
    managedDatabaseId String
    isAllowedValuesIncluded Boolean
    name String
    The parameter name.
    source String
    databaseName string
    The name of the Managed Database.
    databaseSubType string
    The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, or a Non-container Database.
    databaseType string
    The type of Oracle Database installation.
    databaseVersion string
    The Oracle Database version.
    id string
    The provider-assigned unique ID for this managed resource.
    items GetManagedDatabasesDatabaseParameterItem[]
    An array of DatabaseParameterSummary objects.
    managedDatabaseId string
    isAllowedValuesIncluded boolean
    name string
    The parameter name.
    source string
    database_name str
    The name of the Managed Database.
    database_sub_type str
    The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, or a Non-container Database.
    database_type str
    The type of Oracle Database installation.
    database_version str
    The Oracle Database version.
    id str
    The provider-assigned unique ID for this managed resource.
    items Sequence[GetManagedDatabasesDatabaseParameterItem]
    An array of DatabaseParameterSummary objects.
    managed_database_id str
    is_allowed_values_included bool
    name str
    The parameter name.
    source str
    databaseName String
    The name of the Managed Database.
    databaseSubType String
    The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, or a Non-container Database.
    databaseType String
    The type of Oracle Database installation.
    databaseVersion String
    The Oracle Database version.
    id String
    The provider-assigned unique ID for this managed resource.
    items List<Property Map>
    An array of DatabaseParameterSummary objects.
    managedDatabaseId String
    isAllowedValuesIncluded Boolean
    name String
    The parameter name.
    source String

    Supporting Types

    GetManagedDatabasesDatabaseParameterItem

    AllowedValues List<GetManagedDatabasesDatabaseParameterItemAllowedValue>
    A list of allowed values for this parameter.
    Category string
    The parameter category.
    Constraint string
    Applicable in case of Oracle Real Application Clusters (Oracle RAC) databases. A UNIQUE parameter is one which is unique to each Oracle Real Application Clusters (Oracle RAC) instance. For example, the parameter INSTANCE_NUMBER must have different values in each instance. An IDENTICAL parameter must have the same value for every instance. For example, the parameter DB_BLOCK_SIZE must have the same value in all instances.
    ContainerId double
    The ID of the database container to which the data pertains. Possible values include:
    Description string
    The description of the parameter.
    DisplayValue string
    The parameter value in a user-friendly format. For example, if the value property shows the value 262144 for a big integer parameter, then the displayValue property will show the value 256K.
    IsAdjusted bool
    Indicates whether Oracle adjusted the input value to a more suitable value.
    IsBasic bool
    Indicates whether the parameter is a basic parameter (TRUE) or not (FALSE).
    IsDefault bool
    Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE).
    IsDeprecated bool
    Indicates whether the parameter has been deprecated (TRUE) or not (FALSE).
    IsInstanceModifiable bool
    For parameters that can be changed with ALTER SYSTEM, indicates whether the value of the parameter can be different for every instance (TRUE) or whether the parameter must have the same value for all Real Application Clusters instances (FALSE). For other parameters, this is always FALSE.
    IsModified string
    Indicates how the parameter was modified. If an ALTER SYSTEM was performed, the value will be MODIFIED.
    IsPdbModifiable bool
    Indicates whether the parameter can be modified on a per-PDB basis (TRUE) or not (FALSE). In a non-CDB, the value of this property is null.
    IsSessionModifiable bool
    Indicates whether the parameter can be changed with ALTER SESSION (TRUE) or not (FALSE)
    IsSpecified bool
    Indicates whether the parameter was specified in the server parameter file (TRUE) or not (FALSE). Applicable only when the parameter source is SPFILE.
    IsSystemModifiable string
    Indicates whether the parameter can be changed with ALTER SYSTEM and when the change takes effect:

    • IMMEDIATE: Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect immediately.
    • DEFERRED: Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect in subsequent sessions.
    • FALSE: Parameter cannot be changed with ALTER SYSTEM unless a server parameter file was used to start the instance. The change takes effect in subsequent instances.
    Name string
    A filter to return all parameters that have the text given in their names.
    Number double
    The parameter number.
    Ordinal double
    The position (ordinal number) of the parameter value. Useful only for parameters whose values are lists of strings.
    Sid string
    The database instance SID for which the parameter is defined.
    Type string
    The parameter type.
    UpdateComment string
    The comments associated with the most recent update.
    Value string
    The parameter value.
    AllowedValues []GetManagedDatabasesDatabaseParameterItemAllowedValue
    A list of allowed values for this parameter.
    Category string
    The parameter category.
    Constraint string
    Applicable in case of Oracle Real Application Clusters (Oracle RAC) databases. A UNIQUE parameter is one which is unique to each Oracle Real Application Clusters (Oracle RAC) instance. For example, the parameter INSTANCE_NUMBER must have different values in each instance. An IDENTICAL parameter must have the same value for every instance. For example, the parameter DB_BLOCK_SIZE must have the same value in all instances.
    ContainerId float64
    The ID of the database container to which the data pertains. Possible values include:
    Description string
    The description of the parameter.
    DisplayValue string
    The parameter value in a user-friendly format. For example, if the value property shows the value 262144 for a big integer parameter, then the displayValue property will show the value 256K.
    IsAdjusted bool
    Indicates whether Oracle adjusted the input value to a more suitable value.
    IsBasic bool
    Indicates whether the parameter is a basic parameter (TRUE) or not (FALSE).
    IsDefault bool
    Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE).
    IsDeprecated bool
    Indicates whether the parameter has been deprecated (TRUE) or not (FALSE).
    IsInstanceModifiable bool
    For parameters that can be changed with ALTER SYSTEM, indicates whether the value of the parameter can be different for every instance (TRUE) or whether the parameter must have the same value for all Real Application Clusters instances (FALSE). For other parameters, this is always FALSE.
    IsModified string
    Indicates how the parameter was modified. If an ALTER SYSTEM was performed, the value will be MODIFIED.
    IsPdbModifiable bool
    Indicates whether the parameter can be modified on a per-PDB basis (TRUE) or not (FALSE). In a non-CDB, the value of this property is null.
    IsSessionModifiable bool
    Indicates whether the parameter can be changed with ALTER SESSION (TRUE) or not (FALSE)
    IsSpecified bool
    Indicates whether the parameter was specified in the server parameter file (TRUE) or not (FALSE). Applicable only when the parameter source is SPFILE.
    IsSystemModifiable string
    Indicates whether the parameter can be changed with ALTER SYSTEM and when the change takes effect:

    • IMMEDIATE: Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect immediately.
    • DEFERRED: Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect in subsequent sessions.
    • FALSE: Parameter cannot be changed with ALTER SYSTEM unless a server parameter file was used to start the instance. The change takes effect in subsequent instances.
    Name string
    A filter to return all parameters that have the text given in their names.
    Number float64
    The parameter number.
    Ordinal float64
    The position (ordinal number) of the parameter value. Useful only for parameters whose values are lists of strings.
    Sid string
    The database instance SID for which the parameter is defined.
    Type string
    The parameter type.
    UpdateComment string
    The comments associated with the most recent update.
    Value string
    The parameter value.
    allowedValues List<GetManagedDatabasesDatabaseParameterItemAllowedValue>
    A list of allowed values for this parameter.
    category String
    The parameter category.
    constraint String
    Applicable in case of Oracle Real Application Clusters (Oracle RAC) databases. A UNIQUE parameter is one which is unique to each Oracle Real Application Clusters (Oracle RAC) instance. For example, the parameter INSTANCE_NUMBER must have different values in each instance. An IDENTICAL parameter must have the same value for every instance. For example, the parameter DB_BLOCK_SIZE must have the same value in all instances.
    containerId Double
    The ID of the database container to which the data pertains. Possible values include:
    description String
    The description of the parameter.
    displayValue String
    The parameter value in a user-friendly format. For example, if the value property shows the value 262144 for a big integer parameter, then the displayValue property will show the value 256K.
    isAdjusted Boolean
    Indicates whether Oracle adjusted the input value to a more suitable value.
    isBasic Boolean
    Indicates whether the parameter is a basic parameter (TRUE) or not (FALSE).
    isDefault Boolean
    Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE).
    isDeprecated Boolean
    Indicates whether the parameter has been deprecated (TRUE) or not (FALSE).
    isInstanceModifiable Boolean
    For parameters that can be changed with ALTER SYSTEM, indicates whether the value of the parameter can be different for every instance (TRUE) or whether the parameter must have the same value for all Real Application Clusters instances (FALSE). For other parameters, this is always FALSE.
    isModified String
    Indicates how the parameter was modified. If an ALTER SYSTEM was performed, the value will be MODIFIED.
    isPdbModifiable Boolean
    Indicates whether the parameter can be modified on a per-PDB basis (TRUE) or not (FALSE). In a non-CDB, the value of this property is null.
    isSessionModifiable Boolean
    Indicates whether the parameter can be changed with ALTER SESSION (TRUE) or not (FALSE)
    isSpecified Boolean
    Indicates whether the parameter was specified in the server parameter file (TRUE) or not (FALSE). Applicable only when the parameter source is SPFILE.
    isSystemModifiable String
    Indicates whether the parameter can be changed with ALTER SYSTEM and when the change takes effect:

    • IMMEDIATE: Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect immediately.
    • DEFERRED: Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect in subsequent sessions.
    • FALSE: Parameter cannot be changed with ALTER SYSTEM unless a server parameter file was used to start the instance. The change takes effect in subsequent instances.
    name String
    A filter to return all parameters that have the text given in their names.
    number Double
    The parameter number.
    ordinal Double
    The position (ordinal number) of the parameter value. Useful only for parameters whose values are lists of strings.
    sid String
    The database instance SID for which the parameter is defined.
    type String
    The parameter type.
    updateComment String
    The comments associated with the most recent update.
    value String
    The parameter value.
    allowedValues GetManagedDatabasesDatabaseParameterItemAllowedValue[]
    A list of allowed values for this parameter.
    category string
    The parameter category.
    constraint string
    Applicable in case of Oracle Real Application Clusters (Oracle RAC) databases. A UNIQUE parameter is one which is unique to each Oracle Real Application Clusters (Oracle RAC) instance. For example, the parameter INSTANCE_NUMBER must have different values in each instance. An IDENTICAL parameter must have the same value for every instance. For example, the parameter DB_BLOCK_SIZE must have the same value in all instances.
    containerId number
    The ID of the database container to which the data pertains. Possible values include:
    description string
    The description of the parameter.
    displayValue string
    The parameter value in a user-friendly format. For example, if the value property shows the value 262144 for a big integer parameter, then the displayValue property will show the value 256K.
    isAdjusted boolean
    Indicates whether Oracle adjusted the input value to a more suitable value.
    isBasic boolean
    Indicates whether the parameter is a basic parameter (TRUE) or not (FALSE).
    isDefault boolean
    Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE).
    isDeprecated boolean
    Indicates whether the parameter has been deprecated (TRUE) or not (FALSE).
    isInstanceModifiable boolean
    For parameters that can be changed with ALTER SYSTEM, indicates whether the value of the parameter can be different for every instance (TRUE) or whether the parameter must have the same value for all Real Application Clusters instances (FALSE). For other parameters, this is always FALSE.
    isModified string
    Indicates how the parameter was modified. If an ALTER SYSTEM was performed, the value will be MODIFIED.
    isPdbModifiable boolean
    Indicates whether the parameter can be modified on a per-PDB basis (TRUE) or not (FALSE). In a non-CDB, the value of this property is null.
    isSessionModifiable boolean
    Indicates whether the parameter can be changed with ALTER SESSION (TRUE) or not (FALSE)
    isSpecified boolean
    Indicates whether the parameter was specified in the server parameter file (TRUE) or not (FALSE). Applicable only when the parameter source is SPFILE.
    isSystemModifiable string
    Indicates whether the parameter can be changed with ALTER SYSTEM and when the change takes effect:

    • IMMEDIATE: Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect immediately.
    • DEFERRED: Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect in subsequent sessions.
    • FALSE: Parameter cannot be changed with ALTER SYSTEM unless a server parameter file was used to start the instance. The change takes effect in subsequent instances.
    name string
    A filter to return all parameters that have the text given in their names.
    number number
    The parameter number.
    ordinal number
    The position (ordinal number) of the parameter value. Useful only for parameters whose values are lists of strings.
    sid string
    The database instance SID for which the parameter is defined.
    type string
    The parameter type.
    updateComment string
    The comments associated with the most recent update.
    value string
    The parameter value.
    allowed_values Sequence[GetManagedDatabasesDatabaseParameterItemAllowedValue]
    A list of allowed values for this parameter.
    category str
    The parameter category.
    constraint str
    Applicable in case of Oracle Real Application Clusters (Oracle RAC) databases. A UNIQUE parameter is one which is unique to each Oracle Real Application Clusters (Oracle RAC) instance. For example, the parameter INSTANCE_NUMBER must have different values in each instance. An IDENTICAL parameter must have the same value for every instance. For example, the parameter DB_BLOCK_SIZE must have the same value in all instances.
    container_id float
    The ID of the database container to which the data pertains. Possible values include:
    description str
    The description of the parameter.
    display_value str
    The parameter value in a user-friendly format. For example, if the value property shows the value 262144 for a big integer parameter, then the displayValue property will show the value 256K.
    is_adjusted bool
    Indicates whether Oracle adjusted the input value to a more suitable value.
    is_basic bool
    Indicates whether the parameter is a basic parameter (TRUE) or not (FALSE).
    is_default bool
    Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE).
    is_deprecated bool
    Indicates whether the parameter has been deprecated (TRUE) or not (FALSE).
    is_instance_modifiable bool
    For parameters that can be changed with ALTER SYSTEM, indicates whether the value of the parameter can be different for every instance (TRUE) or whether the parameter must have the same value for all Real Application Clusters instances (FALSE). For other parameters, this is always FALSE.
    is_modified str
    Indicates how the parameter was modified. If an ALTER SYSTEM was performed, the value will be MODIFIED.
    is_pdb_modifiable bool
    Indicates whether the parameter can be modified on a per-PDB basis (TRUE) or not (FALSE). In a non-CDB, the value of this property is null.
    is_session_modifiable bool
    Indicates whether the parameter can be changed with ALTER SESSION (TRUE) or not (FALSE)
    is_specified bool
    Indicates whether the parameter was specified in the server parameter file (TRUE) or not (FALSE). Applicable only when the parameter source is SPFILE.
    is_system_modifiable str
    Indicates whether the parameter can be changed with ALTER SYSTEM and when the change takes effect:

    • IMMEDIATE: Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect immediately.
    • DEFERRED: Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect in subsequent sessions.
    • FALSE: Parameter cannot be changed with ALTER SYSTEM unless a server parameter file was used to start the instance. The change takes effect in subsequent instances.
    name str
    A filter to return all parameters that have the text given in their names.
    number float
    The parameter number.
    ordinal float
    The position (ordinal number) of the parameter value. Useful only for parameters whose values are lists of strings.
    sid str
    The database instance SID for which the parameter is defined.
    type str
    The parameter type.
    update_comment str
    The comments associated with the most recent update.
    value str
    The parameter value.
    allowedValues List<Property Map>
    A list of allowed values for this parameter.
    category String
    The parameter category.
    constraint String
    Applicable in case of Oracle Real Application Clusters (Oracle RAC) databases. A UNIQUE parameter is one which is unique to each Oracle Real Application Clusters (Oracle RAC) instance. For example, the parameter INSTANCE_NUMBER must have different values in each instance. An IDENTICAL parameter must have the same value for every instance. For example, the parameter DB_BLOCK_SIZE must have the same value in all instances.
    containerId Number
    The ID of the database container to which the data pertains. Possible values include:
    description String
    The description of the parameter.
    displayValue String
    The parameter value in a user-friendly format. For example, if the value property shows the value 262144 for a big integer parameter, then the displayValue property will show the value 256K.
    isAdjusted Boolean
    Indicates whether Oracle adjusted the input value to a more suitable value.
    isBasic Boolean
    Indicates whether the parameter is a basic parameter (TRUE) or not (FALSE).
    isDefault Boolean
    Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE).
    isDeprecated Boolean
    Indicates whether the parameter has been deprecated (TRUE) or not (FALSE).
    isInstanceModifiable Boolean
    For parameters that can be changed with ALTER SYSTEM, indicates whether the value of the parameter can be different for every instance (TRUE) or whether the parameter must have the same value for all Real Application Clusters instances (FALSE). For other parameters, this is always FALSE.
    isModified String
    Indicates how the parameter was modified. If an ALTER SYSTEM was performed, the value will be MODIFIED.
    isPdbModifiable Boolean
    Indicates whether the parameter can be modified on a per-PDB basis (TRUE) or not (FALSE). In a non-CDB, the value of this property is null.
    isSessionModifiable Boolean
    Indicates whether the parameter can be changed with ALTER SESSION (TRUE) or not (FALSE)
    isSpecified Boolean
    Indicates whether the parameter was specified in the server parameter file (TRUE) or not (FALSE). Applicable only when the parameter source is SPFILE.
    isSystemModifiable String
    Indicates whether the parameter can be changed with ALTER SYSTEM and when the change takes effect:

    • IMMEDIATE: Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect immediately.
    • DEFERRED: Parameter can be changed with ALTER SYSTEM regardless of the type of parameter file used to start the instance. The change takes effect in subsequent sessions.
    • FALSE: Parameter cannot be changed with ALTER SYSTEM unless a server parameter file was used to start the instance. The change takes effect in subsequent instances.
    name String
    A filter to return all parameters that have the text given in their names.
    number Number
    The parameter number.
    ordinal Number
    The position (ordinal number) of the parameter value. Useful only for parameters whose values are lists of strings.
    sid String
    The database instance SID for which the parameter is defined.
    type String
    The parameter type.
    updateComment String
    The comments associated with the most recent update.
    value String
    The parameter value.

    GetManagedDatabasesDatabaseParameterItemAllowedValue

    IsDefault bool
    Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE).
    Ordinal double
    The position (ordinal number) of the parameter value. Useful only for parameters whose values are lists of strings.
    Value string
    The parameter value.
    IsDefault bool
    Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE).
    Ordinal float64
    The position (ordinal number) of the parameter value. Useful only for parameters whose values are lists of strings.
    Value string
    The parameter value.
    isDefault Boolean
    Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE).
    ordinal Double
    The position (ordinal number) of the parameter value. Useful only for parameters whose values are lists of strings.
    value String
    The parameter value.
    isDefault boolean
    Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE).
    ordinal number
    The position (ordinal number) of the parameter value. Useful only for parameters whose values are lists of strings.
    value string
    The parameter value.
    is_default bool
    Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE).
    ordinal float
    The position (ordinal number) of the parameter value. Useful only for parameters whose values are lists of strings.
    value str
    The parameter value.
    isDefault Boolean
    Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE).
    ordinal Number
    The position (ordinal number) of the parameter value. Useful only for parameters whose values are lists of strings.
    value String
    The parameter value.

    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 v2.33.0 published on Thursday, May 1, 2025 by Pulumi
    pulumi/pulumi-oci