Re: Query Execution Time "alone"
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 15 Mar 2011 19:44:36 -0000
Message-ID: <sPudnXWPB50PXOLQnZ2dnUVZ8iudnZ2d_at_bt.com>
Date: Tue, 15 Mar 2011 19:44:36 -0000
Message-ID: <sPudnXWPB50PXOLQnZ2dnUVZ8iudnZ2d_at_bt.com>
set timing on
set arraysize {something fairly big - maybe 1000}
set autotrace traceonly statistics
{queries}
Oracle fetches the data, but dumps it straight into /dev/null. No time wasted on formatting and filing. The times you get are query and network traffic only
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com "raja" <dextersunil_at_gmail.com> wrote in message news:bec87a19-579a-4276-8d0d-b3af26db271b_at_y31g2000prd.googlegroups.com...Received on Tue Mar 15 2011 - 14:44:36 CDT
> Hi,
>
> 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.