Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page Go to next page
View PDF

Reading the Parameter Descriptions

The parameter descriptions in this chapter adhere to the following format.


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 232-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 264-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.


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.

For each parameter, paragraphs following these details further describe the parameter and the effects of different settings.