1. Packages
  2. Oracle Cloud Infrastructure
  3. API Docs
  4. DatabaseManagement
  5. getManagedDatabasesDatabaseParameters
Oracle Cloud Infrastructure v1.27.0 published on Friday, Mar 15, 2024 by Pulumi

oci.DatabaseManagement.getManagedDatabasesDatabaseParameters

Explore with Pulumi AI

oci logo
Oracle Cloud Infrastructure v1.27.0 published on Friday, Mar 15, 2024 by Pulumi

    This data source provides the list of Managed Databases Database Parameters 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 testManagedDatabasesDatabaseParameters = oci.DatabaseManagement.getManagedDatabasesDatabaseParameters({
        managedDatabaseId: oci_database_management_managed_database.test_managed_database.id,
        isAllowedValuesIncluded: _var.managed_databases_database_parameter_is_allowed_values_included,
        name: _var.managed_databases_database_parameter_name,
        opcNamedCredentialId: _var.managed_databases_database_parameter_opc_named_credential_id,
        source: _var.managed_databases_database_parameter_source,
    });
    
    import pulumi
    import pulumi_oci as oci
    
    test_managed_databases_database_parameters = oci.DatabaseManagement.get_managed_databases_database_parameters(managed_database_id=oci_database_management_managed_database["test_managed_database"]["id"],
        is_allowed_values_included=var["managed_databases_database_parameter_is_allowed_values_included"],
        name=var["managed_databases_database_parameter_name"],
        opc_named_credential_id=var["managed_databases_database_parameter_opc_named_credential_id"],
        source=var["managed_databases_database_parameter_source"])
    
    package main
    
    import (
    	"github.com/pulumi/pulumi-oci/sdk/go/oci/DatabaseManagement"
    	"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
    )
    
    func main() {
    	pulumi.Run(func(ctx *pulumi.Context) error {
    		_, err := DatabaseManagement.GetManagedDatabasesDatabaseParameters(ctx, &databasemanagement.GetManagedDatabasesDatabaseParametersArgs{
    			ManagedDatabaseId:       oci_database_management_managed_database.Test_managed_database.Id,
    			IsAllowedValuesIncluded: pulumi.BoolRef(_var.Managed_databases_database_parameter_is_allowed_values_included),
    			Name:                    pulumi.StringRef(_var.Managed_databases_database_parameter_name),
    			OpcNamedCredentialId:    pulumi.StringRef(_var.Managed_databases_database_parameter_opc_named_credential_id),
    			Source:                  pulumi.StringRef(_var.Managed_databases_database_parameter_source),
    		}, 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 testManagedDatabasesDatabaseParameters = Oci.DatabaseManagement.GetManagedDatabasesDatabaseParameters.Invoke(new()
        {
            ManagedDatabaseId = oci_database_management_managed_database.Test_managed_database.Id,
            IsAllowedValuesIncluded = @var.Managed_databases_database_parameter_is_allowed_values_included,
            Name = @var.Managed_databases_database_parameter_name,
            OpcNamedCredentialId = @var.Managed_databases_database_parameter_opc_named_credential_id,
            Source = @var.Managed_databases_database_parameter_source,
        });
    
    });
    
    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.GetManagedDatabasesDatabaseParametersArgs;
    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 testManagedDatabasesDatabaseParameters = DatabaseManagementFunctions.getManagedDatabasesDatabaseParameters(GetManagedDatabasesDatabaseParametersArgs.builder()
                .managedDatabaseId(oci_database_management_managed_database.test_managed_database().id())
                .isAllowedValuesIncluded(var_.managed_databases_database_parameter_is_allowed_values_included())
                .name(var_.managed_databases_database_parameter_name())
                .opcNamedCredentialId(var_.managed_databases_database_parameter_opc_named_credential_id())
                .source(var_.managed_databases_database_parameter_source())
                .build());
    
        }
    }
    
    variables:
      testManagedDatabasesDatabaseParameters:
        fn::invoke:
          Function: oci:DatabaseManagement:getManagedDatabasesDatabaseParameters
          Arguments:
            managedDatabaseId: ${oci_database_management_managed_database.test_managed_database.id}
            isAllowedValuesIncluded: ${var.managed_databases_database_parameter_is_allowed_values_included}
            name: ${var.managed_databases_database_parameter_name}
            opcNamedCredentialId: ${var.managed_databases_database_parameter_opc_named_credential_id}
            source: ${var.managed_databases_database_parameter_source}
    

    Using getManagedDatabasesDatabaseParameters

    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 getManagedDatabasesDatabaseParameters(args: GetManagedDatabasesDatabaseParametersArgs, opts?: InvokeOptions): Promise<GetManagedDatabasesDatabaseParametersResult>
    function getManagedDatabasesDatabaseParametersOutput(args: GetManagedDatabasesDatabaseParametersOutputArgs, opts?: InvokeOptions): Output<GetManagedDatabasesDatabaseParametersResult>
    def get_managed_databases_database_parameters(filters: Optional[Sequence[_databasemanagement.GetManagedDatabasesDatabaseParametersFilter]] = None,
                                                  is_allowed_values_included: Optional[bool] = None,
                                                  managed_database_id: Optional[str] = None,
                                                  name: Optional[str] = None,
                                                  opc_named_credential_id: Optional[str] = None,
                                                  source: Optional[str] = None,
                                                  opts: Optional[InvokeOptions] = None) -> GetManagedDatabasesDatabaseParametersResult
    def get_managed_databases_database_parameters_output(filters: Optional[pulumi.Input[Sequence[pulumi.Input[_databasemanagement.GetManagedDatabasesDatabaseParametersFilterArgs]]]] = None,
                                                  is_allowed_values_included: Optional[pulumi.Input[bool]] = None,
                                                  managed_database_id: Optional[pulumi.Input[str]] = None,
                                                  name: Optional[pulumi.Input[str]] = None,
                                                  opc_named_credential_id: Optional[pulumi.Input[str]] = None,
                                                  source: Optional[pulumi.Input[str]] = None,
                                                  opts: Optional[InvokeOptions] = None) -> Output[GetManagedDatabasesDatabaseParametersResult]
    func GetManagedDatabasesDatabaseParameters(ctx *Context, args *GetManagedDatabasesDatabaseParametersArgs, opts ...InvokeOption) (*GetManagedDatabasesDatabaseParametersResult, error)
    func GetManagedDatabasesDatabaseParametersOutput(ctx *Context, args *GetManagedDatabasesDatabaseParametersOutputArgs, opts ...InvokeOption) GetManagedDatabasesDatabaseParametersResultOutput

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

    public static class GetManagedDatabasesDatabaseParameters 
    {
        public static Task<GetManagedDatabasesDatabaseParametersResult> InvokeAsync(GetManagedDatabasesDatabaseParametersArgs args, InvokeOptions? opts = null)
        public static Output<GetManagedDatabasesDatabaseParametersResult> Invoke(GetManagedDatabasesDatabaseParametersInvokeArgs args, InvokeOptions? opts = null)
    }
    public static CompletableFuture<GetManagedDatabasesDatabaseParametersResult> getManagedDatabasesDatabaseParameters(GetManagedDatabasesDatabaseParametersArgs args, InvokeOptions options)
    // Output-based functions aren't available in Java yet
    
    fn::invoke:
      function: oci:DatabaseManagement/getManagedDatabasesDatabaseParameters:getManagedDatabasesDatabaseParameters
      arguments:
        # arguments dictionary

    The following arguments are supported:

    ManagedDatabaseId string
    The OCID of the Managed Database.
    Filters List<GetManagedDatabasesDatabaseParametersFilter>
    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.
    OpcNamedCredentialId string
    The OCID of the Named Credential.
    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.
    Filters []GetManagedDatabasesDatabaseParametersFilter
    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.
    OpcNamedCredentialId string
    The OCID of the Named Credential.
    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.
    filters List<GetManagedDatabasesDatabaseParametersFilter>
    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.
    opcNamedCredentialId String
    The OCID of the Named Credential.
    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.
    filters GetManagedDatabasesDatabaseParametersFilter[]
    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.
    opcNamedCredentialId string
    The OCID of the Named Credential.
    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.
    filters GetManagedDatabasesDatabaseParametersFilter]
    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.
    opc_named_credential_id str
    The OCID of the Named Credential.
    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.
    filters List<Property Map>
    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.
    opcNamedCredentialId String
    The OCID of the Named Credential.
    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.

    getManagedDatabasesDatabaseParameters Result

    The following output properties are available:

    DatabaseParametersCollections List<GetManagedDatabasesDatabaseParametersDatabaseParametersCollection>
    The list of database_parameters_collection.
    Id string
    The provider-assigned unique ID for this managed resource.
    ManagedDatabaseId string
    Filters List<GetManagedDatabasesDatabaseParametersFilter>
    IsAllowedValuesIncluded bool
    Name string
    The parameter name.
    OpcNamedCredentialId string
    Source string
    DatabaseParametersCollections []GetManagedDatabasesDatabaseParametersDatabaseParametersCollection
    The list of database_parameters_collection.
    Id string
    The provider-assigned unique ID for this managed resource.
    ManagedDatabaseId string
    Filters []GetManagedDatabasesDatabaseParametersFilter
    IsAllowedValuesIncluded bool
    Name string
    The parameter name.
    OpcNamedCredentialId string
    Source string
    databaseParametersCollections List<GetManagedDatabasesDatabaseParametersDatabaseParametersCollection>
    The list of database_parameters_collection.
    id String
    The provider-assigned unique ID for this managed resource.
    managedDatabaseId String
    filters List<GetManagedDatabasesDatabaseParametersFilter>
    isAllowedValuesIncluded Boolean
    name String
    The parameter name.
    opcNamedCredentialId String
    source String
    databaseParametersCollections GetManagedDatabasesDatabaseParametersDatabaseParametersCollection[]
    The list of database_parameters_collection.
    id string
    The provider-assigned unique ID for this managed resource.
    managedDatabaseId string
    filters GetManagedDatabasesDatabaseParametersFilter[]
    isAllowedValuesIncluded boolean
    name string
    The parameter name.
    opcNamedCredentialId string
    source string
    databaseParametersCollections List<Property Map>
    The list of database_parameters_collection.
    id String
    The provider-assigned unique ID for this managed resource.
    managedDatabaseId String
    filters List<Property Map>
    isAllowedValuesIncluded Boolean
    name String
    The parameter name.
    opcNamedCredentialId String
    source String

    Supporting Types

    GetManagedDatabasesDatabaseParametersDatabaseParametersCollection

    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.
    Items List<GetManagedDatabasesDatabaseParametersDatabaseParametersCollectionItem>
    An array of DatabaseParameterSummary objects.
    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.
    Items []GetManagedDatabasesDatabaseParametersDatabaseParametersCollectionItem
    An array of DatabaseParameterSummary objects.
    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.
    items List<GetManagedDatabasesDatabaseParametersDatabaseParametersCollectionItem>
    An array of DatabaseParameterSummary objects.
    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.
    items GetManagedDatabasesDatabaseParametersDatabaseParametersCollectionItem[]
    An array of DatabaseParameterSummary objects.
    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.
    items GetManagedDatabasesDatabaseParametersDatabaseParametersCollectionItem]
    An array of DatabaseParameterSummary objects.
    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.
    items List<Property Map>
    An array of DatabaseParameterSummary objects.

    GetManagedDatabasesDatabaseParametersDatabaseParametersCollectionItem

    AllowedValues List<GetManagedDatabasesDatabaseParametersDatabaseParametersCollectionItemAllowedValue>
    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 []GetManagedDatabasesDatabaseParametersDatabaseParametersCollectionItemAllowedValue
    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<GetManagedDatabasesDatabaseParametersDatabaseParametersCollectionItemAllowedValue>
    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 GetManagedDatabasesDatabaseParametersDatabaseParametersCollectionItemAllowedValue[]
    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 GetManagedDatabasesDatabaseParametersDatabaseParametersCollectionItemAllowedValue]
    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.

    GetManagedDatabasesDatabaseParametersDatabaseParametersCollectionItemAllowedValue

    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.

    GetManagedDatabasesDatabaseParametersFilter

    Name string
    A filter to return all parameters that have the text given in their names.
    Values List<string>
    Regex bool
    Name string
    A filter to return all parameters that have the text given in their names.
    Values []string
    Regex bool
    name String
    A filter to return all parameters that have the text given in their names.
    values List<String>
    regex Boolean
    name string
    A filter to return all parameters that have the text given in their names.
    values string[]
    regex boolean
    name str
    A filter to return all parameters that have the text given in their names.
    values Sequence[str]
    regex bool
    name String
    A filter to return all parameters that have the text given in their names.
    values List<String>
    regex Boolean

    Package Details

    Repository
    oci pulumi/pulumi-oci
    License
    Apache-2.0
    Notes
    This Pulumi package is based on the oci Terraform Provider.
    oci logo
    Oracle Cloud Infrastructure v1.27.0 published on Friday, Mar 15, 2024 by Pulumi