From: hassan_ayub@yahoo.com (Hassan Ayub)
Newsgroups: comp.databases.oracle
Subject: Re: Measure querytime
Date: 7 Jul 2002 07:53:12 -0700
Organization: http://groups.google.com/
Lines: 13
Message-ID: <1df2b71.0207070653.2891bd03@posting.google.com>
References: <p1VV8.15136$p56.4914941@newsb.telia.net>
NNTP-Posting-Host: 210.56.10.254
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1026053593 11217 127.0.0.1 (7 Jul 2002 14:53:13 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 7 Jul 2002 14:53:13 GMT


Hi there,
    I presume you are talking abut the SQL* PLus environment.
  Use the timing variable and turn it on using the following command:

  set timing on

after this whenever you will run your query it will give you the
elapsed time for that query.

good luck!!!


Hassan Ayub