WHAT IS USER PROCESS AND SERVER PROCESS?
Ans: A User process is created and maintained to execute the software code of an application program (such as PRO * Program) or an ORACLE tool (such as SQL * DBA). The User process also manages the communication with server processes. User processes communication with the server processes through the program interface. Other processes call ORACLE processes. In a dedicated server configuration, a server Process handles requests for a single user process. A multithread server configuration allows many user processes to share a small number of server processes, minimizing the utilization of available system resources.