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

Q.  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.
- Published on 12 Aug 15

a. True
b. False

ANSWER: True
 

    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


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