When to use Shared Server in Oracle

Posted on 2011-10-10
Last Modified: 2013-11-11
What is the optimal condition to use the shared server in oracle? How to decide of Shared server has to be used?
Question by:Cha1tu
    LVL 76

    Accepted Solution

    Use it when you do not have enough memory to handle the number of dedicated connections your app needs.

    Expert Comment

    Have a look at this :
    LVL 3

    Expert Comment

    Also, do not use it if the amount of memory required per connection is significant, eg if you are running a data warehouse.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now