ODP.NET Managed Driver Performance Indicators Missing in perfmon

Question

How to enable performance counters for ODP.NET managed drivers in execution so that they can be controlled? Currently, I cannot see the "Oracle Data Provider for.NET" category in perfmon at all.

I tried to register the counters from the configure script int in the xcopy installation kit (ODP.NET_Managed121010.zip), but the corresponding part failed with the error:

OraProvCfg / action: register / product: odpm / component: perfcounter / providerpath: "D: \ svnroot \ tech \ Nasadzovanie \ Assemblies \ Oracle.ManagedDataAccess \ tmp \ odp.net \ managed \ x64 \ .. \ common \ Oracle.ManagedDataAccess .dll "ERROR: There was a problem registering ODP counters

The relevant sections of my app.config are correct, I hope:

<configSections> <section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.121.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342" /> </configSections> <oracle.manageddataaccess.client> <version number="*"> <settings> <setting name="PerformanceCounters" value="4095" /> </settings> </version> </oracle.manageddataaccess.client> 

Answer 1

In addition to the above application configuration settings, you need to run the following command as "Administrator". Before you run, make sure you replace the {path} with the correct directory.

OraProvCfg / action: register / product: odpm / component: perfcounter / providerpath: "{path} \ oracle.manageddataaccess.dll"

You can find the OraProvCfg.exe file in the xpdf download of ODP.NET.