Re: display speed of queries?

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 28 Feb 2005 10:11:36 -0500
Message-ID: <2tudnS9b48g0qb7fRVn-1Q@comcast.com>

"Ian" <not_at_available.com.au> wrote in message news:42233346$1_2_at_news.chariot.net.au...
> Hi,
> Am relatively new to Oracle,
> Is there a way to display the speed of queries - how long it took?
> Useful for testing/comparing efficiency
> regards
> Ian
> estacey_at_chariot.net.ZZ
> change ZZ to au if you want to direct reply.
>
>

simplest way is in SQL*Plus

SQL> SET TIMING ON
SQL> SELECT *
2 FROM dept;

DEPTNO DNAME LOC
---------- -------------- -------------

        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

Elapsed: 00:00:00.25
SQL> Note that other tools will have other techniques... for example Free TOAD automatically show query time, in milleseconds, the lower left of the screen

For more exact information on SQL timing and tuning, reference the tuning manuals available via http://tahiti.oracle.com

++ mcs Received on Mon Feb 28 2005 - 09:11:36 CST