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. ODP.NET, Managed and Unmanaged Drivers support the XML configuration file. Windows Registry settings are available for ODP.NET, Unmanaged Driver only.
In ODAC 12c Release 4, ODP.NET now uses new directories to write trace files to by default.
ODP.NET, Managed Driver:
<Windows user temporary folder>
ODP.NET, Unmanaged Driver: <Windows user temporary folder>
The Windows user temporary folder is determined by your local Windows settings, such as your Windows
TEMP environment variable. Typically, it can be
\AppData\Local\Temp. ODP.NET will create an entry in the Windows event log where the trace was created anytime it creates a trace file.
For ODP.NET, Unmanaged Driver specifically,
TraceFileLocation is now supported similar to ODP.NET, Managed Driver.
TraceFileLocation defines the directory where the trace files will be created. Neither
TraceFileLocation will be created by default in the Windows Registry.
"Configuring Oracle Data Provider for .NET" for further details