Query Execution Time "alone"

From: raja <dextersunil_at_gmail.com>
Date: Tue, 15 Mar 2011 07:28:26 -0700 (PDT)
Message-ID: <bec87a19-579a-4276-8d0d-b3af26db271b_at_y31g2000prd.googlegroups.com>


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.

With Regards,
Raja. Received on Tue Mar 15 2011 - 09:28:26 CDT

Original text of this message