Prespawned dedicated servers improve the time it takes to establish a connection to a server where the multi-threaded server is not in use or is not supported on a given machine. Prespawned dedicated servers also allow for better use of allocated memory and system resources by recycling server processes. They do this by creating ready to use database service processes to handle requests on various protocols. This way, users do not need to wait for a new process to initialize when making a connection.

To create prespawned dedicated servers:

1. Double-click on the Listeners folder.

2. Click on a listener.

3. Choose Database Services from the drop-down list box.

4. Select Use Prespawned Dedicated Server, and click Configure Prespawned Servers.

5. In the Configure Prespawned Servers dialog box, enter appropriate information.

6. Choose Save Network Configuration from the File menu to save changes to LISTENER.ORA in $ORACLE_HOME/network/admin on UNIX or ORACLE_HOME\network\admin on Windows platforms, or choose Save As from the File menu to save under a different file name or path.