Question

Difference between user process and server process in oracle

Answer 1

Oracle Database creates server processes to handle the requests ofuser processes connected to an instance. A server process can be either of the following: A dedicatedserver process, which services only one user process. A shared server process, which can service multipleuser processes.