It looks like Oracle shared server process model is better than dedicated server process model. In a shared server configuration, client user processes connect to a dispatcher and it can support multiple client connections concurrently (source). Also, shared server can be configured for connection pooling and session multiplexing, so all these things should bring a huge performance boost. So, with these advantages, are there any cases when dedicated server process model should be used instead?

1 Answer 1


1) One Tom Kyte maintains that with shared server, the only performance that will surely increase is processing of CONNECTs. For the rest of statements, shared server is inherently a bit slower, unless it happens that pooling/multiplexing is sufficient to maintain advantage.

2) Dedicated is simpler - it has less components. Since much of administrator's job is investigating strange behaviors, tracing, analyzing... simpler means better.

3) Most importantly, everybody uses dedicated, and a best approach in case of any "enterprise-level" software is to take a path more traveled by - my personal opinion. A side-effect would be when contacting Oracle support with problems, you may receive more often the advice to "try again using dedicated server instead" than "well, why don't you try it using shared server instead". So it's one less thing to discuss with those beautiful people.

  • Thanks for sharing the thoughts. I always thought the main Oracle strengths are flexibility, features and full configuration in order to have a better performance than other RDBMS when designing high availability systems. Otherwise why to use Oracle that is expensive and requires more knowledge and effort to administrate than MS SQL Server, of course, if the selection of RDBMS is not restricted to Oracle). Did you administrated large and overloaded systems with Oracle? I always thought dedicated model is OK when designing system with low number of concurrent users and not for high crowded web.
    – Centurion
    Commented Sep 29, 2012 at 12:19
  • 1
    I administer a few fairly large OLTP systems. The owners/customers happily bought enough RAM&CPU so they could use dedicated servers and not be overloaded - but they didn't ask me for advice. If I would sponsor a system with my own money, I'd probably test shared server.
    – kubanczyk
    Commented Sep 29, 2012 at 16:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.