Re: TKPROF questions

Hi Sybrand,

Is the time given in SQL*Plus (set timing on) is equal to the elapsed time in TKPROF output? What is the time unit in SQL*Plus when timing is setting on?

Thanks,
Alan

In article <382d4ead.5594147_at_news.demon.nl>,   postbus_at_sybrandb.demon.nl (Sybrand Bakker) wrote:
> On Sat, 13 Nov 1999 06:23:09 GMT, alan_psb_at_yahoo.com wrote:
>
> >I have few questions about using TKPROF. (on Oracle8)
> >
> >1) Is it possible to specify the resulting file in using TKPROF? This
is
> >because I found that all the output information is forwarded to one
> >particular file. However, I want each SQL statmenet trace file
forwarded
> >to different files.
> >
> >2) I found that the resulting file has the following error:
> >
> >Misses in library cache during parse: 0
> >Optimizer goal: CHOOSE
> >Parsing user id: 37 (TESTING)
> >error during parse of EXPLAIN PLAN statement
> >ORA-00942: table or view does not exist
> >
> >However, I have already run the utlxplan.sql (user TESTING). Why such
an
> >error message
> >shown and how to solve this problem?
> >
> >3) Besides the SQL statmenet that I executed, I find that two more
> >statmenets:
> >
> >OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS
> >...
> >OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS
> >...
> >
> >Is the above information generated by Oracle other sessions when
using
> >TKPROF? What is the use of the above information? SHould I ignore
this?
> >
>
> 1) No, the trace file name always includes the hex of the process id
> on the server. You could easily calculate the projected trace file. If
> you want statements to go to different files you need to reconnect and
> you still have the chance of getting the same file.
>
> 2) TKPROF creates it's own plan table in the user specified by
> explain= . You should either specify the user who originally ran the
> statements or the owner of the tables.
>
> 3) The overall totals are overall totals, they are calculated by
> tkprof from the trace file,as you could suspect
> >Thanks,
> >Alan
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Nov 14 1999 - 10:39:37 CST