Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: display speed of queries?

Re: display speed of queries?

From: Cris Carampa <cris119_at_operamail.com>
Date: Mon, 28 Feb 2005 16:11:46 +0100
Message-ID: <422334c8$0$6320$5fc30a8@news.tiscali.it>


Ian wrote:

> Is there a way to display the speed of queries - how long it took?

SQL> set timing on
SQL> select count(*) from emp;

   COUNT(*)


         14

Elapsed: 00:00:00.02

Please do not crosspost anymore.

Kind regards,

-- 
Cris Carampa (cris119_at_operamail.com)

- We're gonna be like three little Fonzies here. And what's Fonzie like?
- Cool?
Received on Mon Feb 28 2005 - 09:11:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US