help with tkprof

RBDMS 19.15

RHEL 7

Hi!

Trying to debug an application that is "slow". This is the stats from the slowest running query.

What exactly do Fetch mean? Do we send data 3763 times to the application server and it takes less then 2 seconds?

call   count    cpu  elapsed    disk   query  current    rows

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

Parse    1   0.00    0.00     0     0     0      0

Execute   1   0.00    0.00     0     0     0      0

Fetch   3763   1.73    1.74     0   314683     0   234975

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

total   3765   1.73    1.75     0   314683     0   234975

Elapsed times include waiting on following events:

 Event waited on               Times  Max. Wait Total Waited

 ----------------------------------------  Waited ---------- ------------

 SQL*Net message to client          3763   0.00     0.00

 PGA memory operation             105    0.00     0.00

 SQL*Net message from client         3763   0.03     10.56