e-Commerce Applications Using Oracle8i and Java from Scratch

Understanding the Oracle Multithreaded Server Architecture

By default, whenever a user attempts to make a connection to the database, the connection is made using dedicated server processes. In other words, for each user connection there is a shadow process created that performs all the work on behalf of the user process. This includes loading the desired data from the database files into the database block buffers and returning the results of the query back to the user process. Such dedicated connections are very fast and would be desirable, but they happen to have a problem: You can't have too many of them without quickly making the overhead prohibitive. This is particularly true for JavaStop if we are planning to support at least a couple hundred ...