User`s guide

Oracle Net Services Variables
Oracle Environment Variables B-9
Format: SF_PBLKSIZE = 2K|4K
Classification: DBA
Default: 2K
B.4.16 SGA_BASE
This variable gives the address where the SGA is mapped into memory, and must
represent a megabyte-boundary.
Format: SGA_BASE = address
Classification: DBA
Default: SGA_BASE = 190M
B.5 Oracle Net Services Variables
The following are the Oracle Net Services variables:
B.5.1 BREAK_HANDLING
This variable deactivates the signal routine for user interrupts, which sends a break
over the network. An interrupt can be released by pressing the [K2] key.
Format:
BREAK_HANDLING=ON|OFF
Classification:
DBA , USER , NET
Default:
BREAK_HANDLING=ON
B.5.2 TNS_ADMIN
This variable specifies the user ID of the Oracle Net Services configuration files, for
example,
LISTENER.ORA , TNSNAMES.ORA and SQLNET.ORA . If TNS_ADMIN is not defined,
then the configuration files are searched under the local user ID with the prefix
NETWORK.ADMIN .
Format: TNS_ADMIN = $userid
Classification: DBA , USER , NET
Note: This variable cannot be changed after database creation. Once
you specify a value different from the default, you must specify it in
all future calls.
Note: The value of SGA_BASE is read from the kernel if the shared
kernel is already loaded. There is no corresponding
SGA_SIZE variable;
the size of the SGA memory pool is calculated when the database is
started.