Re: tkprof

"cot_r" <bvanespen_at_yahoo.com> wrote in message news:a8u72s$ncc$1_at_naxos.belnet.be...
> hi
> -
> I need to do some analyses on db performance.
> this is what i did:
> 1) set the user_dump_dest directory
> 2) set trace and timing stats on
> 3) ran a simple query:
> select id,name from performance where id between 3500 and 7000
> 4) unleashed TKPROF ( release 8.1.6.0.0) on the generated *.trc file in de
> dump directory.
>
> in sql i got an elapsed time:32.77
>
> the tkprof output shows me the lines below. Results show that the cpu time
=
> 937.5 SECONDS !!!!!! this is more than 15 minutes!!!! while the elapsed
time
> in sqlplus shows me: 32.77 seconds.
> What is wrong here?
> All suggestions are welcome!

OK problem solved. I used tkprof rel 8.1.6 on a 9i db. Since tkprof is not found on 9i for windows, i used 9i on a linux machine. On the linux machine there is a newer version of tkprof available. Received on Tue Apr 09 2002 - 07:28:24 CDT