Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Initialization Parameters, 4 of 220


Reading the Parameter Descriptions

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

PARAMETER_NAME

Parameter type 

Specifies the type of the parameter value: Boolean, string, integer, file, big integer, and so on. 

Syntax 

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

Default value 

Specifies the value this parameter assumes if not explicitly specified. 

Parameter class 

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

Auto-resource parameters are parameters that have an initial value specified at startup that can change dynamically as needed. 

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. 

Oracle9i Real Application Clusters 

Specifies how the values for this parameter must be specified for multiple instances in an Oracle9i Real Application Clusters. Not applicable to all parameters. 

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


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback