Query Execution Time
Date: Thu, 13 Nov 2008 20:29:37 -0800 (PST)
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.
Raja. Received on Thu Nov 13 2008 - 22:29:37 CST