Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tkprof questions
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>...Received on Sat Aug 26 2000 - 15:10:22 CDT
>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.