Need help with tkprof
Hello! Our env is as follows: Oracle EBS 12.1.3, database 19c, OS RHEL 8.5.
One of our EBS reports is running forever, earlier it used to complete in 20 minutes. I took a trace of the database session. Here is the last part of tkprof output:
********************************************************************************
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 5 0.00 0.05 0 0 0 0
Execute 16 0.06 0.97 0 0 0 13
Fetch 2 0.00 0.00 0 13 0 2
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 23 0.06 1.02 0 13 0 15
Misses in library cache during parse: 3
Misses in library cache during execute: 3
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited