OPEN_LINKS_PER_INSTANCE
OPEN_LINKS_PER_INSTANCE
specifies the maximum number of migratable open connections globally for each database instance. XA transactions use migratable open connections so that the connections are cached after a transaction is committed. Another transaction can use the connection, provided the user who created the connection is the same as the user who owns the transaction.
OPEN_LINKS_PER_INSTANCE
is different from OPEN_LINKS
, which indicates the number of connections from a session. The OPEN_LINKS
parameter is not applicable to XA applications.