TKPROF, a lot of overall totals for all recursive statements, why?

19.12

Windows 2019

Hi,

Traced a user session and saw this in the end of the trace file. 700s of recursive statements, seems like alot compared to the 70s in non-recursive.

Have I missed somethin, how to find out what takes so long during the recursive statements?

Regards

WestCoast_DBA

OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS

call   count    cpu  elapsed    disk   query  current    rows

------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse    0   0.00    0.00     0     0     0      0

Execute  1237   15.65   15.81     0    391     0    1144

Fetch    93   55.93   52.95     0    2570     0     369

------- ------ -------- ---------- ---------- ---------- ---------- ----------

total   1330   71.59   68.76     0    2961     0    1513

Misses in library cache during parse: 0

Elapsed times include waiting on following events:

 Event waited on               Times  Max. Wait Total Waited