OPENLINKS is static initialization parameter - Administering and Managing an Oracle Database

Q.  OPEN_LINKS is the static initialization parameter that controls the number of remote connections that a single user session can use concurrently in distributed transactions.
- Published on 29 Jul 15

a. True
b. False

ANSWER: True
 

    Discussion

  • Nirja Shah   -Posted on 27 Aug 15
    - You can limit the number of connections from a user process to remote databases using the static initialization parameter OPEN_LINKS.

    - This parameter controls the number of remote connections that a single user session can use concurrently in distributed transactions.

    - Consider the following for setting this parameter:

    1. The value should be greater than or equal to the number of databases referred to in a single SQL statement that references multiple databases.

    2. Increase the value if several distributed databases are accessed over time. Thus, if you regularly access three databases, set OPEN_LINKS to 3 or greater.

    3. The default value for OPEN_LINKS is 4. If OPEN_LINKS is set to 0, then no distributed transactions are allowed.

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