Shared server can service multiple user processes in a Oracle Database - Managing Oracle Database Processes

Q.  Which can service multiple user processes in a Oracle Database which creates server processes to handle the requests of user processes Connected to an instance of a server process?
- Published on 27 Jul 15

a. A dedicated server
b. A shared server
c. Both A & B
d. None of the above

ANSWER: A shared server
 

    Discussion

  • Nirja Shah   -Posted on 23 Sep 15
    - Oracle Database creates server processes to handle the requests of user processes connected to an instance.

    - A server process can be either of the following:

    - A dedicated server process, which services only one user process

    - A shared server process, which can service multiple user processes

    - Your database is always enabled to allow dedicated server processes, but you must specifically configure and enable shared server by setting one or more initialization parameters.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)