Go4hosting
FORUM

What is dedicated server in Oracle?

Oracle database creates server processes. These server processes are created to handle the requests of user processes. These user processes are connected to an instance.

Server processes can be of two types. The first being a dedicated server process, serves the processes of only one user. The second being a shared server process, serves multiple user processes.

When an Oracle instance is connected to, by a user, it creates a process, which is known as Oracle SID or Security Identifier. This SID is useful in identifying a database on a system. This SID is a dedicated SID to only one database and this prevents any other database with the same SID to create a process.

Dedicated server connections need huge resources for memory. This requirement is often not met by database servers. This reduces the speed of the process, since the connection is not functioning. A dedicated server connection is found to be most suitable to handle administration work or group work, which requires a good quantum of resources for the user.

The users need to put up new requests to activate connections to dedicated servers. This not putting up requests by the users not only destroys the resources but also prevents other users to put up their requests.

A shared server has been found as more efficient here, since it does not have one to one connection, like a dedicated server. A shared server can scale more efficiently than a dedicates server, as it allows several connections to a number of users at a time.
_________________
Sales: [email protected]

Links To Our Service Pages:

Data Center | Cloud Hosting | VPS Hosting | Colocation in India