Hello,

We are executing a COBOL program calling a stored procedure in an Oracle database.  We are having a problem with the elapsed time of the stored procedure call.

From the perspective of the database (as shown in the AWR report), all calls to the stored procedure have an elapsed time of 0.01 sec or less.

From the perspective of the COBOL program, almost all calls to the stored procedure have an elapsed time of .01 sec or less.  In a sample program run, 367 out of 16291 calls had a run time of 2.0 sec or greater. 

We need to trace why this occurs, and are looking for recommendations on how to trace/investigate the issue.

Our environment is MicroFocus COBOL on Linux.

Thanks.