Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Moving from Dedicated to Shared Server

mosleeMar 10 2013 — edited Mar 19 2013
Hi to all

My Production DB Specs
--------------------------------------------------------------------------------
Oracle 11g Enterprise Edition (11.2.0.3)
Windows Server 2012 Standard (64 bit)
HP ProLiant DL360p Gen8
Processors Intel Xeon CPU E5-2620 0 @2GHz
16GB RAM
Total disk space 745GB
Database size 20GB

I would like to move from Dedicated to Shared Server for my db. My concerns here are as follow:

1] What are those configurations that I need to test first BEFORE implementing Shared Server?
2] How much improvement in performance can I expect when I implement Shared Server? (reduced memory demand?)

On another note, is it true that:
"The use of a shared server is tied to the assumption that the connecting client will use only a small fraction of his/her time executing queries or ‘talking’ to the database, so that the rest of the time can be used to do work for other clients. The more active a client is, the greater the number of shared server processes have to be created and if the number of clients and their quantum of activity keeps on increasing, then there will come a point where the entire concept of shared server will become meaningless. While shared server does reduce the demand for memory, it is in no way going to improve performance. "?

3] What are the things that I need to check and monitor AFTER implementing Shared Server? (for example, number of processes?)
4] What kind of behavioural changes should I anticipate? (does shared server allow the use of RMAN? or archivelog mode? or Materialized view?)

Thank you for sharing with me your precious experiences.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2013
Added on Mar 10 2013
19 comments
831 views