Skip to Main Content
Oracle Net8 Configuration and Troubleshooting
book

Oracle Net8 Configuration and Troubleshooting

by Hugo Toledo, Jonathan Gennick
December 2000
Intermediate to advanced content levelIntermediate to advanced
408 pages
12h 26m
English
O'Reilly Media, Inc.
Content preview from 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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Pro Oracle Database 11g RAC on Linux

Pro Oracle Database 11g RAC on Linux

Steve Shaw, Martin Bach
Oracle 11g

Oracle 11g

Lewis Cunningham

Publisher Resources

ISBN: 1565927532Catalog PageErrata