Path: news.easynews.com!easynews!news-out.visi.com!hermes.visi.com!nntp1.roc.gblx.net!nntp.gblx.net!nntp.gblx.net!feeder.qis.net!sn-xit-02!supernews.com!postnews1.google.com!not-for-mail
From: allanwtham@yahoo.com (godmann)
Newsgroups: comp.databases.oracle.server
Subject: Re: Time a sql statement
Date: 3 Mar 2002 18:49:43 -0800
Organization: http://groups.google.com/
Lines: 8
Message-ID: <95cd51c.0203031849.7d04cfcb@posting.google.com>
References: <95cd51c.0202271829.2645ecf6@posting.google.com> <d7hr7u8b3l8asuu52rbevcab8k3o3lmn73@4ax.com> <a5lsno$7cm$1@helle.btinternet.com> <95cd51c.0202281721.49d9446c@posting.google.com> <3C7F01A3.7020606@home.com>
NNTP-Posting-Host: 161.142.78.83
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1015210183 24506 127.0.0.1 (4 Mar 2002 02:49:43 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 4 Mar 2002 02:49:43 GMT
Xref: easynews comp.databases.oracle.server:137334
X-Received-Date: Sun, 03 Mar 2002 19:47:40 MST (news.easynews.com)

Adrian,

    set timing on gives you the round trip. How am I getting the 
ACTUAL execution time of an SQL statement without using stakspack
for this moment. Oracle 7.3.4.5 is in use!

Allan W. Tham
Oracle DBA