Re: HELP! Execution time of Select stmt
From: Robert Chin <chinman_at_optonline.net>
Date: Thu, 11 Oct 2001 05:25:08 GMT
Message-ID: <U2ax7.197171$w7.32201320_at_news02.optonline.net>
[Quoted] exec dbms_output.put_line(DBMS_UTILITY.GET_TIME); set termout off
PUT YOUR SELECT QUERY HERE
(eg, Select * from my_table ;)
set termout on
exec dbms_output.put_line(DBMS_UTILITY.GET_TIME);
Date: Thu, 11 Oct 2001 05:25:08 GMT
Message-ID: <U2ax7.197171$w7.32201320_at_news02.optonline.net>
[Quoted] Put the following code in a file, and run it in sql*plus
you should see 2 numbers on output.
The difference of which is the elapsed time to the 1/100 of a second.
[Quoted] exec dbms_output.put_line(DBMS_UTILITY.GET_TIME); set termout off
PUT YOUR SELECT QUERY HERE
(eg, Select * from my_table ;)
set termout on
exec dbms_output.put_line(DBMS_UTILITY.GET_TIME);
"Ho" <kowho_at_singnet.com.sg> wrote in message
news:9q2ftd$b3e$1_at_coco.singnet.com.sg...
>
> How to determine the execution time of a SELECT statement in order to
> fine tune the SELECT stmt ?
>
> Many thanks for your help in advance.
>
>
Received on Thu Oct 11 2001 - 07:25:08 CEST