Allocations Total Process Time Longer than SQL Trace Execution Time

(Doc ID 316451.1)

Last updated on AUGUST 18, 2005

Applies to:

Oracle Financial Services Applications (OFSA) 4.5
Oracle Performance Analyzer - Version: 4.5
This problem can occur on any platform.

Symptoms

The total processing time of a batch of Allocations is significantly longer than the SQL execution time listed in the trace file.  Additionally, in the Server Status Update screen, the time listed in the "Title" column (ex. Complete in 00:03:33) is shorter than the difference between the End Date time and Start Date time.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms