In
order to communicate with oracle database, oracle users need a program
such as SQL *Plus which can issue SQL statements and few processes which
can execute these SQL statements. These processes are divided into User Process, Server Process and Background Processes.
User process runs user application like SQL *Plus. Server process
manages oracle user process’s requests. Server process executes SQL
statements and returns result to user process. Background processes are
the core of oracle database which handle over all database operations.
Dedicated server connection:
A dedicated process has one to one relationship with user process. The
user connected with dedicated server connection has the dedicated
resource that is whether or not the user is doing work the connection
remains allocated to that user. Thus if your user is not working and if
there is less network resource then this user is blocking another user
to connect or to execute the user request by making this user works
queued. This connection is preferable when you have lot of
resource or to some administrative user like "SYS" , "SYS" for
administrative works and for batch jobs,
Shared server connection:
Shared server architecture consists of Listener Process, Dispatcher Process, Request Queue, Shared server process and Response Queue.
Network Listener process listens the user process request. If user
process request requires a dedicated server process, listener process
starts a dedicated server process. If
the request can be assigned to a shared server process, then the
request is forwarded to dispatcher process. Shared server configuration
requires at least on dispatcher process. Dispatcher process places the
request on request queue. Request Queue is created in SGA and shared by
all dispatcher processes. On of free Shared server process picks up the
request from request queue. After processing the request, shared server
process places the result in response queue. Each dispatcher process has
its own response queue in SGA. Dispatcher knows about the user process
which placed the request, so the response is returned back to user
process.
When
there is shared server the user connection is shared, that is user is
connecting by dispatchers and when a user is idle his resource can be
used by other users, thus lessen the load on system, this is more likely
in a environment where user is mostly idle, like in a order entry
system.
So, what should I choose?
If
your environment is OLTP then shared is preferable because the tasks
need short time. Whether is Warehouse, OLAP, Data Mining the users are
running time consuming and heavy load query where it is best to use
dedicated server.
How to configure a shared server configuration?
Below are the two links that helps in configuring the same.
Please let me know if you’re looking for a article writer for your site. You have some really great posts and I feel I would be a good asset. If you ever want to take some of the load off, I’d absolutely love to write some material for your blog in exchange for a link back to mine. Please send me an email if interested. Thank you!
ReplyDeleteCPanel vps servers
ReplyDeleteThank you for sharing valuable information about Difference between dedicated and shared server configuration. Nice post. I enjoyed reading this post. The whole blog is very nice found some good stuff and good information here Thanks. We also provide Server hosting solution in more than 30 countries like Germany , Japan, USA ,UK Africa etc.. so you may also visit my site Japan Dedicated Server
As you are providing some information about difference between dedicated and shared configuration for starting their online business. These tips are very useful & interesting to read. Thanks for posting. Our Spain VPS Server Hosting company gives you best services which are designed to offer flexibility, performance and security.
ReplyDeleteAs you told about Difference between dedicated and shared server configuration. It is very helpful article and I got lot of things through your post. As you mention that many ways we can use dedicated and shared server.we are providing Server Hosting Solution, if you need any requirement of VPS server hosting as well as dedicated server hosting you can visit our website here :
ReplyDeleteUSA Dedicated Server Hosting
Thanks for sharing an nice informative about the dedicated server and the shared hosting with us. Wish to buy or an know more about the dedicated server hosting in india or any other locations, visit the best hosting provider.
ReplyDeleteThanks for explaining the difference between the two!
ReplyDeleteWeb Hosting Services
ReplyDeleteUSA RDP is popular for communicating internet sites, Mailing, Jingling, Hitleap, currency trading, down load, add, loading, hosting and hosting functions Buy Rdp
This comment has been removed by the author.
ReplyDeleteGreat, As you told the Difference between dedicated and shared server configuration that is amazing. As we know Cheap Dedicated Server Hosting is little bit costly but it is better than shared server. With Dedicated Server, user will get complete control and maximum uptime.
ReplyDeleteAs you told about Difference between dedicated and shared server configuration. It is very helpful blogs and I got lot of things through your post. As you mention that many ways we can use dedicated and shared server. Onlive Server offers Russia Dedicated Server at the affordable price. So, I can appreciate for your work.
ReplyDeleteHello there! This is kind of off topic but I need some advice from an established blog. Is it very hard to set up your own blog? I’m not very technical but I can figure things out pretty fast. I’m thinking about creating my own but I’m not sure where to begin. Do you have any ideas or suggestions? Thanks
ReplyDeleteNorton Customer Service Phone Number
offshorededi.com/ offers high quality DMCA Ignored Hosting.
ReplyDeleteWebcare360 Provides you safe and secure cheap Offshore Hosting Best offshore hosting and dmca ignored hosting by Webcare360 with 99.9% Up time Guarantee, with Ddos protection.
ReplyDeleteNice blog.
ReplyDeletevps hosting chennai
Thanks for the article.
ReplyDeleteIf you are looking for Shared hosting in Pakistan or Dedicated server hosting in Pakistan do visit us.
thanks for post.!
ReplyDeleteweb design in india
web development in india
web design and development in india
Well Explained the difference between dedicated server connection and shared server connection.
ReplyDeleteGreat blog!!