From: "astalavista" <nobody@nowhere.com>
Newsgroups: comp.databases.oracle.server
Subject: Timing a query in sqlplus
Date: Fri, 2 Feb 2007 13:41:00 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
Lines: 11
Message-ID: <45c3315a$0$16191$426a74cc@news.free.fr>
Organization: Guest of ProXad - France
NNTP-Posting-Date: 02 Feb 2007 13:40:58 MET
NNTP-Posting-Host: 82.243.104.51
X-Trace: 1170420058 news-1.free.fr 16191 82.243.104.51:2546
X-Complaints-To: abuse@proxad.net
Path: news.f.de.plusline.net!news-fra1.dfn.de!news.visyn.net!news2.arglkargh.de!news.ecp.fr!feed.ac-versailles.fr!proxad.net!cleanfeed3-a.proxad.net!nnrp18-2.free.fr!not-for-mail
Xref: news.f.de.plusline.net comp.databases.oracle.server:193494

Hi,

In sqlplus, how to time a query ?
I set  timing on
but the result seems to skewed by the display of the output lines (lot of 
rows), no ?
How to get the correct timing for a query ?

Thanks in advance