This option controls whether ODP.NET instruments only those operations that are assocociated with root spans created by the application or not.
By default, this property is set to false, which means that ODP.NET will instrument operation regardless of whether the application
creates the root span or not.
But if this property is set to true, ODP.NET will only instrument operations associated with root spans that are created by the application.
This option controls whether Open(), Close(), and OpenAsync() methods on the OracleConnection objects get instrumented.
Possible settings are
EnableOpenCloseTracing.None : No instrumentation for open/close
EnableOpenCloseTracing.HardOpenCloseOnly : Instrumentation for hard open/close only
EnableOpenCloseTracing.AllOpenClose : Instrumentation for all both soft + hard open/close
In order to instrument hard open/close, EnableDBRoundTripTracing option has to be set to true
By default, this property is set to EnableOpenCloseTracing.None.
Automatic Instrumentation and Dynamic Enablement
ODP.NET adds new OpenTelemetry automatic instrumentation support that delivers traces to observability backends without requiring source code changes. ODP.NET OpenTelemetry is now enabled automatically. It no longer requires adding Oracle.ManagedDataAccess.OpenTelemetry NuGet package nor calling AddOracleDataProviderInstrumentation() extension method to enable OpenTelemetry.
ODP.NET OpenTelemetry is now enabled by default. It can be turned off or on by setting OracleConfiguration.OpenTelemetryTracing to false or true, respectively. It can also be set in the OpenTelemetryTracing .NET configuration file setting for .NET Framework.
Note: The ODP.NET activity source name is "Oracle.ManagedDataAccess.Core" for ODP.NET Core and "Oracle.ManagedDataAccess" for managed ODP.NET