tkprof questions

From: Vik <viklall_at_my-deja.com>
Date: Wed, 23 Aug 2000 23:54:07 GMT
Message-ID: <8o1o6o$ri4$1@nnrp1.deja.com>

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 Wed Aug 23 2000 - 18:54:07 CDT