Report takes a long time, SQL in TKPROF is OK...? Many seconds on package, not SQLs
This is the output of the packages which is run:
BEGIN my_snapshot_report_sql_fs.month_price(:1,:2,:3,:4,:5,:6,:7);
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 1 1035.70 9075.11 2109514 4561714 9 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1 1035.70 9075.11 2109514 4561714 9 1
If I add up ALL the SQL:s in the trace file, I not even close to 9000s.
What have I missed here?
Regards
U