INFO: Oracle Opens Three Sessions to the Database for Each Transactional Component (232828)


The information in this article 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.

REFERENCES

For more information on Microsoft Transaction Server and Oracle, please see the articles at the following site:

ftp://ftp.microsoft.com/bussys/viper/docs

Modification Type:MajorLast Reviewed:11/18/1999
Keywords:kbDTC kbinfo kbOracle kbOracle700 kbOracle800 KB232828
©2002 Microsoft Corporation. All rights reserved.