User`s guide

DBA Startup Variables
Oracle Environment Variables B-5
Format: PRINTPAR = print-options
Classification: USER
B.3.10 SQLPATH
This variable specifies a path where SQL*Plus looks for command files. Elements of
the path are separated by semicolons (;). For example:
SQLPATH=PRIVATE;$ORAC1120
This assignment causes SQL*Plus to look for filename.SQL, then for
PRIVATE . filename . SQL , and finally for $ORAC1120 . filename . SQL .
Format: SQLPATH = search-path
Classification: USER, DBA
B.3.11 SSSIDPWF
This variable specifies the password file for remote instance start. For further
information, refer to
Chapter 5, "Administering Oracle Database".
Format: SSSIDPWF = password-file
Classification: DBA
B.4 DBA Startup Variables
The following variables are used during database and network startup. They
supplement (and in some cases provide defaults for) variables contained in the
initialization file.
Oracle recommends that database startup and shutdown, background jobs, and
network jobs should all refer to the same
ORAENV file to ensure that the variables are
consistent.
Note that the default values listed in the following section are built-in defaults, most of
them are over-ridden by settings in the shipped
DEMO . P . ORAENV .
B.4.1 Address and Size Specification
Several of the variables described in this section define memory addresses and sizes.
The notation used to specify these items is as follows:
■ A number with no modifiers is interpreted as a decimal number
■ A number followed by K or M is interpreted as a decimal number multiplied by
1024 or 1048576 (1024*1024) respectively
■ A number enclosed in single quotation marks and preceded by the letter X is
interpreted as a hexadecimal number
For example, the following all set the KNL_BASE variable to 8M:
KNL_BASE=8M
KNL_BASE=8388608
KNL_BASE=X'800000'