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
User-mode dumps upon unmanaged exceptions
To enable ODP.NET for tracing,
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