Deactivated/Shared server - Definition - Administering and Managing an Oracle Database

Q.  Which server mode application uses a standard public database link in which 100 users simultaneously require a connection and then 100 direct network connections to the remote database are required?
- Published on 04 Aug 15

a. Deactivated/Shared server
b. Shared Server
c. Dedicated
d. None of the above

ANSWER: Deactivated/Shared server
 

    Discussion

  • Nirja Shah   -Posted on 27 Aug 15
    - Look carefully at your application and shared server configuration to determine whether to use shared links.

    - A simple guideline is to use shared database links when the number of users accessing a database link is expected to be much larger than the number of server processes in the local database.

    - There are three possible configurations involving database links:

    1. Dedicated/shared server - If your application uses a standard public database link, and 100 users simultaneously require a connection, then 100 direct network connections to the remote database are required. It uses a nonshared link type.

    2. Shared server - If 10 shared server processes exist in the local shared server mode database, then 100 users that use the same database link require 10 or fewer network connections to the remote server. Each local shared server process may only need one connection to the remote server. It uses a shared link type.

    3. Dedicated - If 10 clients connect to a local dedicated server, and each client has 10 sessions on the same connection (thus establishing 100 sessions overall), and each session references the same remote database, then only 10 connections are needed. With a nonshared database link, 100 connections are needed. It uses a shared link type.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)