NEED SOME HELP
CLICK HERE OR CALL US ON
hosting provider in india 1-800-212-2022
web hosting services in USA 1-888-288-3570
Have questions? Let us answer them all!

Go4hosting
FORUM

Go4hosting offers top-notch services, such as dedicated server hosting, VPS hosting, Co- location,Web hosting,
Email hosting, and Cloud Computing solutions. All the services offered by Go4hosting are efficient, reliable,
andcost-effective. , remaining essentially unchanged.

It is currently Tue Nov 26, 2024 7:12 am

All times are UTC + 5:30 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
PostPosted: Wed Mar 15, 2017 1:26 pm 
Offline

Joined: Wed Jul 27, 2016 3:35 pm
Posts: 50
What Is Dedicated Server In Oracle?


Top
 Profile  
 
PostPosted: Wed Mar 15, 2017 1:29 pm 
Offline
Site Admin

Joined: Sat Jan 04, 2014 12:08 pm
Posts: 231
Oracle database creates two types of server processes to handle user requests shared and dedicated connections. The dedicated server process that serves the request of a single user. The second server process is a shared server that services multiple users.

When a user connects to the Oracle instance, it creates a process termed as Oracle SID where SID identifies a database on a system. The SID is dedicated to only one database and does not allow any other database with the same SID. These dedicated server connections require a lot of memory resource and often, the database servers fall short of memory as the connection remains idle. This slows down the process. Dedicated server connection is desirable for administrative works or batch jobs where the user needs plenty of resources.

Most of the dedicated server connections are not active until such time that the user comes up with a new request. This not only eats up resources but blocks up another user to come up with their requests. A shared server, on the other hand, works out to be more efficient. Instead of a one to one connection, it has one to multiple connections. It also scales efficiently allowing connections to multiple users at one single time.

_________________
Our Service Pages:
Zimbra Mail Hosting | Cloud Hosting India | VPS Hosting India | Colocation India | Dedicated Server India


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

Users browsing this forum: No registered users and 1 guest


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: