Debug Tracing

ODP.NET provides debug tracing support, which allows logging of all the ODP.NET activities into a trace file. Different levels of tracing are available.

The provider can record the following information:

• Entry and exit information for the ODP.NET public methods

• User-provided SQL statements as well as SQL statements modified by the provider

• Connection pooling statistics such as enlistment and delistment

• Thread ID (entry and exit)

• HA Events and Load Balancing information

• Distributed Transactions

• Self-tuning information

• User-mode dumps upon unmanaged exceptions

To enable ODP.NET for tracing, TraceFileName, TraceLevel, and TraceOption must be set appropriately either in the Windows Registry or in an XML configuration file.