Query Execution Time

Hi,

I am using both 9i/10g.
I am checking the performance of a query, so i have 2 queries, one before change and one after changing the query. Let the testing environment be any of these sql*plus / sqltools / toad / oracle sql developer.

The problem here is that:
when i executed the query the second time, the query execution time decreases than before, which means that it has been taken in cache.

I tried no cache hint, but it didnt look to work good.

Is there any way to clear the cache, so that we can check the query execution properly ?

Also, how can view the exection time, fetch time, parse time separately for a particular query ...

Thanks in Advance.

With Regards,
Raja. Received on Thu Nov 13 2008 - 22:29:37 CST