PL/SQL block in TKPROF, how to see whats going on?
BEGIN jet_snapshot_report_sql_fs.month_retail_price(:1,:2,:3,:4,:5,:6,:7);
END;
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 0 0.00 0.00 0 0 0 0
Execute 1 305.82 7082.52 1980096 13952512 5 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 1 305.82 7082.52 1980096 13952512 5 1
Misses in library cache during parse: 0
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: 520 (recursive depth: 1)
How can I view whats going on here? The sum of all SQL:s in the trace file is not even close to 7000s. Is there a way to get a trace from the execution of jet_snapshot_report_sql_fs.month_retail_price?