Oracle Cloud Infrastructure
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:
- Managed
Database stringId The OCID of the Managed Database.
- Filters
List<Get
Managed Databases Database Parameters Filter> - Is
Allowed boolValues Included 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 isCURRENT
.
- Managed
Database stringId The OCID of the Managed Database.
- Filters
[]Get
Managed Databases Database Parameters Filter - Is
Allowed boolValues Included 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 isCURRENT
.
- managed
Database StringId The OCID of the Managed Database.
- filters
List<Get
Managed Databases Database Parameters Filter> - is
Allowed BooleanValues Included 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 isCURRENT
.
- managed
Database stringId The OCID of the Managed Database.
- filters
Get
Managed Databases Database Parameters Filter[] - is
Allowed booleanValues Included 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 isCURRENT
.
- managed_
database_ strid The OCID of the Managed Database.
- filters
Get
Managed Databases Database Parameters Filter] - is_
allowed_ boolvalues_ included 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 isCURRENT
.
- managed
Database StringId The OCID of the Managed Database.
- filters List<Property Map>
- is
Allowed BooleanValues Included 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 isCURRENT
.
getManagedDatabasesDatabaseParameters Result
The following output properties are available:
- Database
Parameters List<GetCollections Managed Databases Database Parameters Database Parameters Collection> The list of database_parameters_collection.
- Id string
The provider-assigned unique ID for this managed resource.
- Managed
Database stringId - Filters
List<Get
Managed Databases Database Parameters Filter> - Is
Allowed boolValues Included - Name string
The parameter name.
- Source string
- Database
Parameters []GetCollections Managed Databases Database Parameters Database Parameters Collection The list of database_parameters_collection.
- Id string
The provider-assigned unique ID for this managed resource.
- Managed
Database stringId - Filters
[]Get
Managed Databases Database Parameters Filter - Is
Allowed boolValues Included - Name string
The parameter name.
- Source string
- database
Parameters List<GetCollections Managed Databases Database Parameters Database Parameters Collection> The list of database_parameters_collection.
- id String
The provider-assigned unique ID for this managed resource.
- managed
Database StringId - filters
List<Get
Managed Databases Database Parameters Filter> - is
Allowed BooleanValues Included - name String
The parameter name.
- source String
- database
Parameters GetCollections Managed Databases Database Parameters Database Parameters Collection[] The list of database_parameters_collection.
- id string
The provider-assigned unique ID for this managed resource.
- managed
Database stringId - filters
Get
Managed Databases Database Parameters Filter[] - is
Allowed booleanValues Included - name string
The parameter name.
- source string
- database_
parameters_ Getcollections Managed Databases Database Parameters Database Parameters Collection] The list of database_parameters_collection.
- id str
The provider-assigned unique ID for this managed resource.
- managed_
database_ strid - filters
Get
Managed Databases Database Parameters Filter] - is_
allowed_ boolvalues_ included - name str
The parameter name.
- source str
- database
Parameters List<Property Map>Collections The list of database_parameters_collection.
- id String
The provider-assigned unique ID for this managed resource.
- managed
Database StringId - filters List<Property Map>
- is
Allowed BooleanValues Included - name String
The parameter name.
- source String
Supporting Types
GetManagedDatabasesDatabaseParametersDatabaseParametersCollection
- Database
Name string The name of the Managed Database.
- Database
Sub stringType The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, or a Non-container Database.
- Database
Type string The type of Oracle Database installation.
- Database
Version string The Oracle Database version.
- Items
List<Get
Managed Databases Database Parameters Database Parameters Collection Item> An array of DatabaseParameterSummary objects.
- Database
Name string The name of the Managed Database.
- Database
Sub stringType The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, or a Non-container Database.
- Database
Type string The type of Oracle Database installation.
- Database
Version string The Oracle Database version.
- Items
[]Get
Managed Databases Database Parameters Database Parameters Collection Item An array of DatabaseParameterSummary objects.
- database
Name String The name of the Managed Database.
- database
Sub StringType The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, or a Non-container Database.
- database
Type String The type of Oracle Database installation.
- database
Version String The Oracle Database version.
- items
List<Get
Managed Databases Database Parameters Database Parameters Collection Item> An array of DatabaseParameterSummary objects.
- database
Name string The name of the Managed Database.
- database
Sub stringType The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, or a Non-container Database.
- database
Type string The type of Oracle Database installation.
- database
Version string The Oracle Database version.
- items
Get
Managed Databases Database Parameters Database Parameters Collection Item[] An array of DatabaseParameterSummary objects.
- database_
name str The name of the Managed Database.
- database_
sub_ strtype 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
Get
Managed Databases Database Parameters Database Parameters Collection Item] An array of DatabaseParameterSummary objects.
- database
Name String The name of the Managed Database.
- database
Sub StringType The subtype of the Oracle Database. Indicates whether the database is a Container Database, Pluggable Database, or a Non-container Database.
- database
Type String The type of Oracle Database installation.
- database
Version String The Oracle Database version.
- items List<Property Map>
An array of DatabaseParameterSummary objects.
GetManagedDatabasesDatabaseParametersDatabaseParametersCollectionItem
- Allowed
Values List<GetManaged Databases Database Parameters Database Parameters Collection Item Allowed Value> 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 parameterINSTANCE_NUMBER
must have different values in each instance. AnIDENTICAL
parameter must have the same value for every instance. For example, the parameterDB_BLOCK_SIZE
must have the same value in all instances.- Container
Id 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.
- Display
Value 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 thedisplayValue
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 boolModifiable 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 alwaysFALSE
.- Is
Modified string Indicates how the parameter was modified. If an
ALTER SYSTEM
was performed, the value will beMODIFIED
.- Is
Pdb boolModifiable 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 isnull
.- Is
Session boolModifiable 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 isSPFILE
.- Is
System stringModifiable 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.
- IMMEDIATE: Parameter can be changed with
- 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.
- Update
Comment string The comments associated with the most recent update.
- Value string
The parameter value.
- Allowed
Values []GetManaged Databases Database Parameters Database Parameters Collection Item Allowed Value 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 parameterINSTANCE_NUMBER
must have different values in each instance. AnIDENTICAL
parameter must have the same value for every instance. For example, the parameterDB_BLOCK_SIZE
must have the same value in all instances.- Container
Id 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.
- Display
Value 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 thedisplayValue
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 boolModifiable 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 alwaysFALSE
.- Is
Modified string Indicates how the parameter was modified. If an
ALTER SYSTEM
was performed, the value will beMODIFIED
.- Is
Pdb boolModifiable 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 isnull
.- Is
Session boolModifiable 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 isSPFILE
.- Is
System stringModifiable 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.
- IMMEDIATE: Parameter can be changed with
- 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.
- Update
Comment string The comments associated with the most recent update.
- Value string
The parameter value.
- allowed
Values List<GetManaged Databases Database Parameters Database Parameters Collection Item Allowed Value> 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 parameterINSTANCE_NUMBER
must have different values in each instance. AnIDENTICAL
parameter must have the same value for every instance. For example, the parameterDB_BLOCK_SIZE
must have the same value in all instances.- container
Id 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.
- display
Value 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 thedisplayValue
property will show the value 256K.- is
Adjusted Boolean Indicates whether Oracle adjusted the input value to a more suitable value.
- is
Basic Boolean Indicates whether the parameter is a basic parameter (
TRUE
) or not (FALSE
).- is
Default Boolean Indicates whether the parameter is set to the default value (
TRUE
) or the parameter value was specified in the parameter file (FALSE
).- is
Deprecated Boolean Indicates whether the parameter has been deprecated (
TRUE
) or not (FALSE
).- is
Instance BooleanModifiable 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 alwaysFALSE
.- is
Modified String Indicates how the parameter was modified. If an
ALTER SYSTEM
was performed, the value will beMODIFIED
.- is
Pdb BooleanModifiable 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 isnull
.- is
Session BooleanModifiable Indicates whether the parameter can be changed with
ALTER SESSION
(TRUE
) or not (FALSE
)- is
Specified Boolean Indicates whether the parameter was specified in the server parameter file (
TRUE
) or not (FALSE
). Applicable only when the parameter source isSPFILE
.- is
System StringModifiable 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.
- IMMEDIATE: Parameter can be changed with
- 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.
- update
Comment String The comments associated with the most recent update.
- value String
The parameter value.
- allowed
Values GetManaged Databases Database Parameters Database Parameters Collection Item Allowed Value[] 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 parameterINSTANCE_NUMBER
must have different values in each instance. AnIDENTICAL
parameter must have the same value for every instance. For example, the parameterDB_BLOCK_SIZE
must have the same value in all instances.- container
Id 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.
- display
Value 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 thedisplayValue
property will show the value 256K.- is
Adjusted boolean Indicates whether Oracle adjusted the input value to a more suitable value.
- is
Basic boolean Indicates whether the parameter is a basic parameter (
TRUE
) or not (FALSE
).- is
Default boolean Indicates whether the parameter is set to the default value (
TRUE
) or the parameter value was specified in the parameter file (FALSE
).- is
Deprecated boolean Indicates whether the parameter has been deprecated (
TRUE
) or not (FALSE
).- is
Instance booleanModifiable 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 alwaysFALSE
.- is
Modified string Indicates how the parameter was modified. If an
ALTER SYSTEM
was performed, the value will beMODIFIED
.- is
Pdb booleanModifiable 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 isnull
.- is
Session booleanModifiable Indicates whether the parameter can be changed with
ALTER SESSION
(TRUE
) or not (FALSE
)- is
Specified boolean Indicates whether the parameter was specified in the server parameter file (
TRUE
) or not (FALSE
). Applicable only when the parameter source isSPFILE
.- is
System stringModifiable 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.
- IMMEDIATE: Parameter can be changed with
- 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.
- update
Comment string The comments associated with the most recent update.
- value string
The parameter value.
- allowed_
values GetManaged Databases Database Parameters Database Parameters Collection Item Allowed Value] 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 parameterINSTANCE_NUMBER
must have different values in each instance. AnIDENTICAL
parameter must have the same value for every instance. For example, the parameterDB_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 thedisplayValue
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_ boolmodifiable 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 alwaysFALSE
.- is_
modified str Indicates how the parameter was modified. If an
ALTER SYSTEM
was performed, the value will beMODIFIED
.- is_
pdb_ boolmodifiable 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 isnull
.- is_
session_ boolmodifiable 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 isSPFILE
.- is_
system_ strmodifiable 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.
- IMMEDIATE: Parameter can be changed with
- 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.
- allowed
Values 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 parameterINSTANCE_NUMBER
must have different values in each instance. AnIDENTICAL
parameter must have the same value for every instance. For example, the parameterDB_BLOCK_SIZE
must have the same value in all instances.- container
Id 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.
- display
Value 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 thedisplayValue
property will show the value 256K.- is
Adjusted Boolean Indicates whether Oracle adjusted the input value to a more suitable value.
- is
Basic Boolean Indicates whether the parameter is a basic parameter (
TRUE
) or not (FALSE
).- is
Default Boolean Indicates whether the parameter is set to the default value (
TRUE
) or the parameter value was specified in the parameter file (FALSE
).- is
Deprecated Boolean Indicates whether the parameter has been deprecated (
TRUE
) or not (FALSE
).- is
Instance BooleanModifiable 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 alwaysFALSE
.- is
Modified String Indicates how the parameter was modified. If an
ALTER SYSTEM
was performed, the value will beMODIFIED
.- is
Pdb BooleanModifiable 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 isnull
.- is
Session BooleanModifiable Indicates whether the parameter can be changed with
ALTER SESSION
(TRUE
) or not (FALSE
)- is
Specified Boolean Indicates whether the parameter was specified in the server parameter file (
TRUE
) or not (FALSE
). Applicable only when the parameter source isSPFILE
.- is
System StringModifiable 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.
- IMMEDIATE: Parameter can be changed with
- 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.
- update
Comment String The comments associated with the most recent update.
- value String
The parameter value.
GetManagedDatabasesDatabaseParametersDatabaseParametersCollectionItemAllowedValue
- 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 double
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 float64
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 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.
- is
Default 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.
- is
Default 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
Package Details
- Repository
- https://github.com/pulumi/pulumi-oci
- License
- Apache-2.0
- Notes
This Pulumi package is based on the
oci
Terraform Provider.