Re: Query Execution Time "alone"
From: yossarian <yossarian99_at_operamail.com>
Date: Tue, 15 Mar 2011 15:37:21 +0100
Message-ID: <4d7f79a1$0$30916$5fc30a8_at_news.tiscali.it>
raja wrote:
Date: Tue, 15 Mar 2011 15:37:21 +0100
Message-ID: <4d7f79a1$0$30916$5fc30a8_at_news.tiscali.it>
raja wrote:
> i need to check only
> the elapsed time of the query and not the query output. Is there
> anyway to do so?
Using PL/SQL?
hr_at_> declare
2 junk owa_text.vc_arr ;
3 begin
4 select object_name bulk collect into junk from all_objects ;
5 end ;
6 /
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.43 Received on Tue Mar 15 2011 - 09:37:21 CDT