Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: tkprof questions

Re: tkprof questions

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 26 Aug 2000 21:10:22 +0100
Message-ID: <967321166.21325.2.nnrp-10.9e984b29@news.demon.co.uk>

  1. No - this gives you only execution elapsed time, you should add in the fetch time too, probably with:
                    sort=\(exeela, fchela\)


2)      You can't unless you can do clever edits on the trc file.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Vik wrote in message <8o1o6o$ri4$1_at_nnrp1.deja.com>...

>1. If I run:
>
>TKPROF x.trc ora x.txt SORT = exeela PRINT = 10
>
>shouldnt that give me the 10 most expensive queries in terms
>of time to execute?
>
>2. How do I get tkprof to aggregate queries that are repeated with
>a different parameter? like:
>select id from foo where name = a
>select id from foo where name = b
>
>I tried the aggregate = yes but it doesnt do this.
>
>Any other tkprof tips on how to figure out which queries
>are taking the longest would be most useful.
>
>thanks.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sat Aug 26 2000 - 15:10:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US