Hi paul,

Use the TKPROF Utility to find Exect time to know how much you query have took to fetch that record set.

Refer Oracle Tunning Utilities Documentation guide for further information




Originally posted by parijat67
Hi all,


how can i know the exact time taken by a query to fetch data? I can very well set the timing on at the SQL prompt and check for the time after the select statement ran through, but that doesn't show the fetch time , it shows the fetch + display time together. Can anyone pls help me in this matter?

Thanks

Parijat Paul