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

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