Non-shared database link connection shared across multiple sessions - Oracle Distributed Database concepts

Q.  In a non-shared database link, the connection is shared across multiple sessions.
- Published on 12 Aug 15

a. True
b. False

ANSWER: False
 

    Discussion

  • Nirja Shah   -Posted on 21 Sep 15
    - 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.

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.)