How to trace a remote statement

From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Thu, 2 Oct 2014 19:04:52 +0000
Message-ID: <AF02C941134B1A4AB5F61A726D08DCED0E0CB3D4_at_USA7109MB012.na.xerox.net>

There are two systems involved in this scenario:

• System A: A system that runs a program which calls a procedure on a remote system to calculate tax
• System B: The remote system that runs an application that calculates tax

System B is a packaged application from vendor VERTEX. The problem that we are trying to solve is that when code from system A calls a procedure that is part of a package in the taxing application on system B, the application on system A spends a lot of time waiting for the call to complete on system B. The issue is that VERTEX does not provide a way to enable tracing in its package.

What would be the best way to enable tracing on the remote system to find out the root cause of the issue?

Thank you,
Amir

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 02 2014 - 21:04:52 CEST