Re: to find execution time..

On 28 Mar 2005 04:47:22 -0800, "sam" <sameer.ocp_at_gmail.com> wrote:

>Hi
>
>U can do that after connecting as a user and write
>set timing on

That's fine, but who says the OP is using sql*plus ?

Instead, as simple as :

select systimestamp as Query_start from dual; -- statement to measure goes here
select systimestamp as Query_end from dual;

and substract Query_start from Query_end.

• Kenneth Koenraadt