How to trace a remote statement

  • From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 2 Oct 2014 19:04:52 +0000

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


Other related posts: