What Are Server Processes In Oracle?

1.	What Are Server Processes In Oracle?
Answer» Oracle creates server PROCESSES to serve user processes requests, connected to the instance. In some situations, when the application and Oracle are on the same system, it is POSSIBLE to combine the user process and corresponding server process into one process for reducing system overhead. HOWEVER, when the application and Oracle operate on different COMPUTERS, a user process ALWAYS talks to Oracle through a separate server process. Oracle creates server processes to serve user processes requests, connected to the instance. In some situations, when the application and Oracle are on the same system, it is possible to combine the user process and corresponding server process into one process for reducing system overhead. However, when the application and Oracle operate on different computers, a user process always talks to Oracle through a separate server process.

Answer»

Oracle creates server PROCESSES to serve user processes requests, connected to the instance. In some situations, when the application and Oracle are on the same system, it is POSSIBLE to combine the user process and corresponding server process into one process for reducing system overhead. HOWEVER, when the application and Oracle operate on different COMPUTERS, a user process ALWAYS talks to Oracle through a separate server process.

Oracle creates server processes to serve user processes requests, connected to the instance. In some situations, when the application and Oracle are on the same system, it is possible to combine the user process and corresponding server process into one process for reducing system overhead. However, when the application and Oracle operate on different computers, a user process always talks to Oracle through a separate server process.

Discussion

No Comment Found

Related InterviewSolutions

How Do You Use A Pointer To A Function?
What Is Size Of Void Pointer?
Write A C Program To Find Size Of Structure Without Using Sizeof Operator?
What Is The Meaning Of Prototype Of A Function?
What Is Wild Pointer In C?
What Is Dangling Pointer In C?
Write A C Program To Swap Two Variables Without Using Third Variable ?
In C, What Is The Difference Between A Static Variable And Global Variable?
Is Using Exit() The Same As Using Return?
Why Does Pascal Matter? Is There Any Benefit To Using Pascal Functions?