Skip to Main Content
  • Questions

  • tracing session's pl\sql and temp usage

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, moshko.

Asked: June 23, 2011 - 12:07 pm UTC

Last updated: June 23, 2011 - 12:25 pm UTC

Version: 10.2.0.4

Viewed 1000+ times

You Asked

hi tom, when i use tkprof for tracing a session i get information about its SQL. is there an option to see also information about its pl\sql (how long took every command and so) and how much space in the temp/undo tablespace each command has used (to see what the command that cause my temp to reach its threshold)? thanks.

and Tom said...

Only SQL uses temp - I consider LOBs to be "SQL" things and they might be in temp tool. So there isn't really any way to track "plsql and its temp usage" since it doesn't use temp really.

You can use dbms_profiler and dbms_trace to trace/profile your plsql execution:

http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/tuning.htm#sthref2171

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

DBMS_PROFILER

More on PL/SQL routine DBMS_PROFILER here