Database Reference
In-Depth Information
Figure 4-8: Background processes of Oracle Instance. Oracle Instance
running under Dedicated Server Mode is shown. There would not be
any Request and Response Queues in a dedicated server configuration.
There would not be any dispatcher process in dedicated server mode.
For each connected user then there would one dedicated server process.
The idle time of server will be more but this configuration has the
highest performance factor.
We will talk in detail regarding both of these modes (Dedicated
and Shared) and how Oracle system works, in the next chapter.
If you have a clear understanding of concepts so far, in the next
chapters many mysteries about Oracle that you had in your mind
will unfold, as you will see Oracle in Action.
In dedicated server mode, each connected user would be having
a separate server process. Although this configuration would be
having high idle server time as most of the time Server process
would be doing nothing after fulfilling the single connected user
request and waiting for next SQL statement to arrive. This
configuration has high performance factor but it should only be
utilized when you have plenty of system resources available.
Search WWH ::
Custom Search