Database Tuning (MOSC)

MOSC Banner

Report takes a long time, SQL in TKPROF is OK...? Many seconds on package, not SQLs

edited Oct 9, 2012 9:45PM in Database Tuning (MOSC) 28 commentsAnswered ✓
Hi,

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

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