Database Utilities (MOSC)

MOSC Banner

PL/SQL block in TKPROF, how to see whats going on?

edited Apr 29, 2013 5:04AM in Database Utilities (MOSC) 8 commentsAnswered
11.2.0.2

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?

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