What is dedicated server in oracle?

Find all info related to dedicated server or post about dedicated server issues.
navin33
Posts: 16
Joined: Fri Jul 14, 2017 6:01 am
Contact:

What is dedicated server in oracle?

Postby navin33 » Thu Jul 27, 2017 12:04 pm

What is dedicated server in oracle?

Meghasoni
Posts: 32
Joined: Tue Aug 02, 2016 8:56 am
Contact:

Re: What is dedicated server in oracle?

Postby Meghasoni » Thu Jul 27, 2017 12:51 pm

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.


Return to “Dedicated Server”

Who is online

Users browsing this forum: No registered users and 20 guests