Shared database link is link between local server process & remote database

Discussion

• Nirja Shah   -Posted on 21 Sep 15
  - A shared database link can exist in any of these four configurations.
  
  - Shared links differ from standard database links in the following ways:
  
  - Different users accessing the same schema object through a database link can share a network connection.
  
  - When a user needs to establish a connection to a remote server from a particular server process, the process can reuse connections already established to the remote server.
  - The reuse of the connection can occur if the connection was established on the same server process with the same database link, possibly in a different session.
  - In a non-shared database link, a connection is not shared across multiple sessions.
  
  - When you use a shared database link in a shared server configuration, a network connection is established directly out of the shared server process in the local server.
  - For a non-shared database link on a local shared server, this connection would have been established through the local dispatcher, requiring context switches for the local dispatcher, and requiring data to go through the dispatcher.

➨ Post your comment / Share knowledge