Menu
How do I enable the performance counters for ODP.NET Managed Driver in perfom in order to be able to monitor them? Currently I am unable to see the category "Oracle Data Provider for .NET" in perfmon at all.
I've tried to register the counters from within the configure script int the xcopy installation bundle (ODP.NET_Managed121010.zip), but the relevant part ended with an 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: Encountered a problem while 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>
291
ODP.NET, Managed Driver is 100% managed code . NET Framework provider. Developers deploy a single assembly in a deployment package smaller than 10 MB. ODP.NET, Unmanaged Driver is the traditional Oracle ADO.NET provider that uses the Oracle Database Client.
Installing Oracle Data Provider for .NET creates a set of performance counters on the target system. These performance counters are published by ODP.NET for each ODP.NET client application. These performance counters can be viewed using Windows Performance Monitor (Perfmon).
This article provides a list of performance counters you can find in the Windows Performance Monitor. The Performance console .NET CLR Exceptions category includes counters that provide information about the exceptions thrown by an application.
Networking performance counters can be accessed and managed using the PerformanceCounter and related classes in the System.Diagnostics namespace. Networking performance counters can also be viewed with the Windows Performance Monitor console. Networking performance counters need to be enabled in the configuration file to be used.
Interop performance counters. The Performance console .NET CLR Interop category includes counters that provide information about an application's interaction with COM components, COM+ services, and external type libraries.
In addition to the app config settings mentioned above, you need to run the following command as 'Administrator'. Before executing make sure to 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 in the ODP.NET xcopy download.
192
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
