Oracle Cloud Infrastructure

Pulumi Official
Package maintained by Pulumi
v0.1.1 published on Tuesday, May 3, 2022 by Pulumi

getManagedDatabasesDatabaseParameters

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

using Pulumi;
using Oci = Pulumi.Oci;

class MyStack : Stack
{
    public MyStack()
    {
        var testManagedDatabasesDatabaseParameters = Output.Create(Oci.DatabaseManagement.GetManagedDatabasesDatabaseParameters.InvokeAsync(new Oci.DatabaseManagement.GetManagedDatabasesDatabaseParametersArgs
        {
            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,
            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),
			Source:                  pulumi.StringRef(_var.Managed_databases_database_parameter_source),
		}, nil)
		if err != nil {
			return err
		}
		return nil
	})
}

Coming soon!

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"],
    source=var["managed_databases_database_parameter_source"])
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,
    source: _var.managed_databases_database_parameter_source,
});

Coming soon!

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,
                                              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,
                                              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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

source string
database_parameters_collections GetManagedDatabasesDatabaseParametersDatabaseParametersCollection]

The list of database_parameters_collection.

id str

The provider-assigned unique ID for this managed resource.

managed_database_id str
filters GetManagedDatabasesDatabaseParametersFilter]
is_allowed_values_included bool
name str

The parameter name.

source str
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.

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:

  • 0: This value is used for data that pertain to the entire CDB. This value is also used for data in non-CDBs.
  • 1: This value is used for data that pertain to only the root container.
  • n: Where n is the applicable container ID for the data.
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:

  • 0: This value is used for data that pertain to the entire CDB. This value is also used for data in non-CDBs.
  • 1: This value is used for data that pertain to only the root container.
  • n: Where n is the applicable container ID for the data.
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:

  • 0: This value is used for data that pertain to the entire CDB. This value is also used for data in non-CDBs.
  • 1: This value is used for data that pertain to only the root container.
  • n: Where n is the applicable container ID for the data.
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:

  • 0: This value is used for data that pertain to the entire CDB. This value is also used for data in non-CDBs.
  • 1: This value is used for data that pertain to only the root container.
  • n: Where n is the applicable container ID for the data.
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:

  • 0: This value is used for data that pertain to the entire CDB. This value is also used for data in non-CDBs.
  • 1: This value is used for data that pertain to only the root container.
  • n: Where n is the applicable container ID for the data.
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:

  • 0: This value is used for data that pertain to the entire CDB. This value is also used for data in non-CDBs.
  • 1: This value is used for data that pertain to only the root container.
  • n: Where n is the applicable container ID for the data.
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
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.