Remote server can either be shared server or dedicated server - Oracle

Discussion

• Nirja Shah   -Posted on 30 Sep 15
  - You can configure shared database links in the following ways:
  
  Creating Shared Links to Dedicated Servers
  - A shared server process in the local server owns a dedicated remote server process.
  - The advantage is that a direct network transport exists between the local shared server and the remote dedicated server.
  - A disadvantage is that extra back-end server processes are needed.
  - The remote server can either be a shared server or dedicated server.
  - There is a dedicated connection between the local and remote servers.
  - When the remote server is a shared server, you can force a dedicated server connection by using the (SERVER=DEDICATED) clause in the definition of the service name.
  
  Creating Shared Links to Shared Servers
  - It uses shared server processes on the remote server.
  - This configuration eliminates the need for more dedicated servers, but requires the connection to go through the dispatcher on the remote server.
  - Note that both the local and the remote server must be configured as shared servers.

➨ Post your comment / Share knowledge