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
esta***@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

Ian wrote:
Don't cross-post to every oracle ng you found, please.
Assuming you use SQL*Plus, issue: set timing on
before you execute the query.
There are a lot of possibilities; documentation can be
found on http://docs.oracle.com

Ian wrote:

Please don't post to every usenet group you can spell: One is
sufficient. And if you don't know which one is the correct one
then the onus is on you to read the group's charter.

Thank you.

OMLET: Get Intimate with Oracle Internals
Ansi SQL and stored procedures
Preferable option for moving data from Oracle 9i into Oracle 10g??
Reports :Multipanel / logical page printing problem
tool drawing ora9 database relation schema???
JDeveloper 10g and Redhat 9
Simple forms question
Avoiding automatically starting Oracle
Probl. criteres extraction
Forms 9i Debugger - simple question