User`s guide

Oracle Net Services Variables
Oracle Environment Variables B-9
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
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.
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
B.5.3 TNS_BEQ_TIMEOUT
This variable specifies the time after which a connection between a parent and a child
process is closed if there is no communication between them.
Format:
TNS_BEQ_TIMEOUT = lifetime (in seconds)
Classification:
NET
Default: TNS_BEQ_TIMEOUT = 180