Parameter type

Specifies the type of the parameter:

• A Boolean parameter accepts either true or false as its value.
• A string parameter accepts any sequence of characters as its value, subject to the syntax for the parameter.
• An integer parameter accepts a 4-byte value that can range from 0 to 2³²-1.
• A parameter file parameter accepts an initialization parameter file specification as its value.
• A big integer parameter accepts an 8-byte value that can range from 0 to 2⁶⁴-1. You specify a value for a big integer as an integer together with an optional modifier such as K, M, or G, which respectively denotes kilobytes, megabytes, or gigabytes.

  For example, 1000, 100 KB, 50 MB and 2 GB are valid specifications for big integers.

Syntax

For string and big integer parameters, specifies the valid syntax for specifying the parameter.

Default value

Specifies the value this parameter assumes if not explicitly specified.

Parameter class

Specifies whether the parameter is dynamic or static. If dynamic, then it also specifies whether its value can be changed by an ALTER SESSION or ALTER SYSTEM statement. ALTER SESSION overrides the instance-wide setting of the parameter for the current session only. You can restore the instance-wide setting for that session only by issuing another ALTER SESSION statement. ALTER SYSTEM sets or changes the value of the parameter for all sessions.

Range of values

Specifies the valid range of values that this parameter can assume, shown as a minimum and maximum value. Not applicable to all parameters.

Real Application Clusters

Specifies how the values for this parameter must be specified for multiple instances in a cluster database environment. Not applicable to all parameters.