Re: Measuring query execution times

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 24 Dec 2000 14:03:54 +0100
Message-ID: <924sru$5kqf2$2@ID-62141.news.dfncis.de>

alter system set timed_statistics=true
and alter session set sql_trace=true
for a complete overview, which will break down the total time according to the different execution phases
or
set timing on
for the total time only.

Further info is available in the performance tuning manual.

Hth,

Sybrand Bakker, Oracle DBA

<abhinavvora_at_my-deja.com> wrote in message news:9248ah$es8$1_at_nnrp1.deja.com...
>
>
> I need some help with measuring how long it takes for my sql queries to
> run. I am running SQL*Plus on oracle 8.
>
> Any help appretiated.
>
> Abhinav
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Sun Dec 24 2000 - 07:03:54 CST