Database Utilities (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center