It is currently Sun Dec 06, 2020 4:04 am

All times are UTC + 5:30 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
PostPosted: Tue Jan 09, 2018 1:16 pm 
Offline

Joined: Thu Jun 02, 2016 12:03 pm
Posts: 80
What is Dedicated Server in Oracle?


Top
 Profile  
 
PostPosted: Tue Jan 09, 2018 1:24 pm 
Offline

Joined: Tue Jul 12, 2016 12:12 pm
Posts: 71
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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 5:30 hours


Who is online

Registered users: elizabethar1


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron