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.

See Also:

"Configuring Oracle Data Provider for .NET" for further details