|Dedicated Server in Oracle
|Page 1 of 1|
|Author:||Aarush Gupta [ Tue Jan 09, 2018 1:16 pm ]|
|Post subject:||Dedicated Server in Oracle|
What is Dedicated Server in Oracle?
|Author:||Gaurav Mani [ Tue Jan 09, 2018 1:24 pm ]|
|Post subject:||Re: Dedicated Server in Oracle|
To get access to the Oracle database, users need to apply server processors which are in two forms called shared server and dedicated server processors. While the shared server processors serve multiple users, the dedicated server processor serves only one single user. Every database is enabled to let dedicated server processes although the users are expected to explicitly configure and enable shared server process.
When a request is generated to the Oracle instance or database, a new process called Oracle SID is created. SID is a unique name that identifies the database on a system. A SID is dedicated to one database and is not repeated on any other database. Each connection requires a lot of resources like memory which is not sufficient if run on a shared server.
In the dedicated server configuration, the listener creates a process that runs on the database server machine and receives inward client connection requests and brings about the traffic requests to the database server. Once the session is complete, the server machine process is terminated. The process is recreated when a new client request is started and so requires more resources than what is offered in a shared server configuration.
So, till such time that a request is recreated by the user, the dedicated server remains idle and the resources are unnecessarily wasted. On the other hand, in a shared server, the listener can support multiple client connections at the same time. The dedicated server connects are much faster than the shared server.
However, the costs are much lower on the shared server as instead of one to one connection, the shared server offers one to multiple connections. Dedicated server connection is more suitable for batch works and other administrative jobs for which there is a need for plenty of resources.
|Page 1 of 1||All times are UTC + 5:30 hours|
|Powered by phpBB® Forum Software © phpBB Group