Oracle Net8 Configuration and Troubleshooting

Name

PRESPAWN_DESC

Synopsis

PRESPAWN_DESC =
   (PROTOCOL = protocol)
   (POOL_SIZE = number_of_  processes)
   (TIMEOUT = minutes_to_death)

Defines the number of prespawned dedicated server processes to be created for a specific network protocol. Prespawned dedicated server processes are always protocol-specific.

Parameters

protocol

Identifies the network protocol supported by these processes. Use one of the abbreviations shown in Table 3.1.

Table C-1. Network Protocol Abbreviations

Abbreviation	Protocol
TCP	TCP/IP
SPX	SPX
IPC	Interprocess Communications
NMP	Named Pipes

number_of_ processes

Specifies the number of dedicated server processes to create for the specified protocol. This is also the number that Oracle attempts to keep available for new connections. As processes are taken out of the pool and assigned to a user as the result of a connection request, new processes are added in order to maintain the pool size. However, the total number of prespawned processes in existence is always subject to the limit specified by PRESPAWN_MAX. Once that limit has been reached, the pool will not be replenished.

minutes_to_death

Specifies the number of minutes that a prespawned dedicated server process is allowed to live once it has been used and returned to the pool. After the specified number of minutes, the process is deleted. This mechanism allows the number of prespawned processes to shrink back down to the value specified for the pool size. See Chapter 4, for more details.