Moving from Dedicated to Shared Server
mosleeMar 10 2013 — edited Mar 19 2013Hi 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.