getManagedDatabasesDatabaseParameter

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

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

return await Deployment.RunAsync(() => 
{
    var testManagedDatabasesDatabaseParameter = Oci.DatabaseManagement.GetManagedDatabasesDatabaseParameter.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,
        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.GetManagedDatabasesDatabaseParameter(ctx, &databasemanagement.GetManagedDatabasesDatabaseParameterArgs{
			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
	})
}
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(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())
            .build());

    }
}
import pulumi
import pulumi_oci as oci

test_managed_databases_database_parameter = oci.DatabaseManagement.get_managed_databases_database_parameter(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 testManagedDatabasesDatabaseParameter = oci.DatabaseManagement.getManagedDatabasesDatabaseParameter({
    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,
});
variables:
  testManagedDatabasesDatabaseParameter:
    Fn::Invoke:
      Function: oci:DatabaseManagement:getManagedDatabasesDatabaseParameter
      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}
        source: ${var.managed_databases_database_parameter_source}

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)
// Output-based functions aren't available in Java yet
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 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:

  • 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 []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:

  • 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<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:

  • 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 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:

  • 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 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:

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

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
https://github.com/pulumi/pulumi-oci
License
Apache-2.0
Notes

This Pulumi package is based on the oci Terraform Provider.