Microsoft KB Archive/232828

= INFO: Oracle Opens Three Sessions to the Database for Each Transactional Component =

Article ID: 232828

Article Last Modified on 11/18/1999

-

APPLIES TO


 * Microsoft Windows DNA

-



This article was previously published under Q232828



SUMMARY
The Oracle client opens one session to the Oracle database when performing non-transactional operations and three sessions when performing XA transactional operations.



MORE INFORMATION
The Oracle client opens two sessions to the Oracle database server whenever xa_open is called to establish a transactional database connection. The Oracle client opens a third session when xa_start is called to begin work on a new transaction.

All three sessions communicate over a single Oracle database connection. Oracle does not establish a separate database connection for each session. To verify this, follow these steps:
 * 1) Run the TestOracleXaConfig program.
 * 2) Insert a break point after the xa_open call.
 * 3) Verify that there are two sessions open.
 * 4) Insert a breakpoint after the xa_start call.
 * 5) Verify that a third session is open.

