Oracle database is an object-relational database management system created and promoted by Oracle Corporation. A database server is a piece of hardware that runs software to provide database services to other users' applications as part of a client-server model. So is Oracle database server, which is the most used and deployed database management system in the world.
It has got two server architectural models: dedicated server model
and shared server architecture. In the dedicated server architecture, each client process is made to connect a dedicated server process. Also the server process is not shared by any other client; thereby effectively every single session or user connection has only one server process associated with it. But in a shared server architecture we have multi-thread architecture that is one server process has more threads, thus a shared server
is named multi-thread server as well.Difference between dedicated and shared server configuration:
Keeping in mind the end goal to communicate with Oracle database, Oracle clients require a program, for example, SQL *Plus which can issue SQL statements and few processes which can execute these SQL statements. These processes are partitioned into user process, server process and background processes. Client process runs client application like SQL * Plus. Server process oversees Oracle user process's requests. Server process executes SQL statements and returns result to client process. Background processes are the center of Oracle database which handle over all database operations.