Use Performance Counters with the Oracle E-Business Suite adapter

Microsoft BizTalk Adapter Pack clients can use performance counters to gauge the performance of the adapters. The BizTalk Adapter Pack setup program creates the performance counter category BizTalk .NET Adapter for Oracle E-Business Suite along with installing the BizTalk Adapter Pack.

LOB Time (Cumulative) performance counter

The BizTalk .NET Adapter for Oracle E-Business Suite category has one performance counter called the “LOB Time (Cumulative).” This performance counter denotes the time, in milliseconds, that the LOB client library takes to complete an action that the adapter initiates. The Oracle E-Business adapter creates an instance of the performance counter in any of the following patterns:

<process id>:<app domain id>:<oracle data source>:<string>  

Where "string" could be:

  • Connection.Open

  • Connection.Close

  • Metadata

  • Message action. For example, if the action is InterfaceTables/Insert/FND/APPS/MS_SAMPLE_EMPLOYEE then the string will be InterfaceTables.Insert.FND.APPS.MS_SAMPLE_EMPLOYEE.

    The Oracle data source is the same as specified in the connection URI.

    The performance counter is initialized only after the adapter makes the first call to the Oracle database. Also, the InstanceLifetime property of the performance counter is set to 'Process', which means that the performance counter ceases to exist as soon as the program that creates the counter terminates.

Note

The precision of the LOB Time (Cumulative) performance counter is 16 milliseconds.

Enabling Performance Counters

The performance counters can be enabled or disabled by setting the binding property EnablePerformanceCounters. To enable performance counters, set the EnablePerformanceCounters binding property to True. To disable performance counters, set EnablePerformanceCounters to False. By default, EnablePerformanceCounters is set to False.

Performance Counters and the WCF LOB Adapter SDK

Changing the value of the EnablePerformanceCounters binding property also changes the value of the corresponding performance counter for the WCF LOB Adapter SDK. Also, the binding property for the WCF LOB Adapter SDK is static, whereas that for the BizTalk Adapter Pack is dynamic. Therefore, if there are two instances of the Oracle E-Business adapter binding in the AppDomain, and the EnablePerformanceCounters binding property is set to True in one and False in the other, the adapter-specific performance counter will be enabled in one and disabled in the other. However, because the binding property for WCF LOB Adapter SDK is static, it will either be set to True or False depending on what value was specified last.

See Also

Troubleshooting the adapter