Query Execution Time "alone"
Date: Tue, 15 Mar 2011 07:28:26 -0700 (PDT)
I need to take the elapsed time / response time / query execution time alone of a particular query. For example, if i try to take the response time of the following query :
set timing on
select * from table_name;
8000 rows selected
elapsed time : 2 mins
so my log gets filled up with 8000 rows and when i try for more
queries, the log if going like 1GB in size. but i need to check only
the elapsed time of the query and not the query output. Is there
anyway to do so?
Can anyone please help me out on this? Thanks in Advance.
Raja. Received on Tue Mar 15 2011 - 09:28:26 CDT