Re: TKPROF does it work, and if so, HOW?!

In article <36fk1fINN4g5_at_news.ougf.fi>, likkiar1_at_news.ougf.fi (Ari Likki) writes:
> If you are using SQL*Plus, use command
>
> SQL> set timing on
>
> and then submit your transaction. SQL*Plus will tell you the
> total elapsed time.
>
> TKPROF is good for example finding out how your select statement works
>
> TKPROF nnn.nnn EXPLAIN=UN/PW
>
> where nnn.nnn is the trace file name
> UN is then table owner and PW the password
>
> About those timings you get with TKPROF, I don't know. Sorry.
>
> Regards
>
> Ari Likki
> Yhtyneet Kuvalehdet Oy/United Magazines Ltd
> Helsinki, Finland
>
>
>
>
>

I don't know if these problems are related to EXPLAIN PLAN, but I can't get that to work either. No matter what transaction I try to "explain", the total time is always zero (even though some of the intermediate-stage times shown are not zero).
It isn't worth wasting my time on now. I've already got three TARs logged that ORACLE is ignoring.

-- 
Max Magliaro
MMM_at_ICF.HRB.COM
Philipsburg, Pennsylvania

"He may look like an idiot, and he may sound like an idiot, but don't
 let him fool you.  He really is an idiot." --- Groucho Marx