How to Modify Request Diagnostic Output
The Request Diagnostics window provides the user with request status information. This information consists of messages that explain the request's current status. You can enhance the information provided to include runtime statistics (CPU time) collected from previous runs of the request.
Collect Runtime Data
Set the profile option Concurrent:Collect Request Statistics to "Yes" to collect runtime statistics.
A concurrent request may be comprised of one or two processes: a sql*net shadow which consumes database server resources, and a front-end process such as a C executable. The time used by the CPU is collected for both of these types of processes.
Summarize and View Runtime Statistics
To review the statistics you must run the Purge Concurrent Request and/or Manager Data program to process the raw data and have it write the computed statistics to the FND_CONC_STAT_SUMMARY table. You can review the statistics on a request by request basis using the Diagnostics window from the Requests window.
