Re: Measuring query performance - Newbie question

Real xxx represents the time in hundreths of seconds. You can't format it. To get the real query time, change timed_statistics to true in init<sid>.ora (which is in $ORACLE_HOME/dbs on Unix and %ORACLE_HOME%\database on NT) and bounce the database.
Next, issue alter session set sql_trace = true before your query runs and run tkprof on your trace file.
Of course this is all described in the Tuning guide.

Hth,

--
Sybrand Bakker, Oracle DBA

<gabby97_at_my-deja.com> wrote in message news:7rjjs3$4pl$1_at_nnrp1.deja.com...
> I would like to measure the performance of a SQL statement using
> SQL/Plus. I would like to measure the time it took to execute the query
> and not the time it took for the query to display in SQL/Plus. How do I
> do that?
>
> I have tried using "SET TIMING" command, but I am confused with the
> results that I get back. I get a result that says "real 29345". What
> does that number represent? How do I format the result so it is
> displayed in mm:ss format?
>
> Thanks.
>
> Farzana
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Sep 13 1999 - 15:59:03 CDT