set timing on

From: <Zabair.Ahmed_at_natwest.com>
Date: Fri, 19 May 2000 15:48:24 +0100
Message-Id: <10502.106103@fatcity.com>

Hello all

Quick question, how do you get the timing in mins and secs when you set timing on in sqlplus.

SQL-ORACLE-AHMEDZ> set timing on
SQL-ORACLE-AHMEDZ> select * from v$database;

NAME CREATED LOG_MODE CHECKPOINT_CHANGE# ARCHIVE_CHANGE#

--------- -------------------- ------------ ------------------
---------------
ORACLE    12/10/99 14:53:44    NOARCHIVELOG              10598

10471

 real: 211
SQL-ORACLE-AHMEDZ> As you can see it returns the time in real.

Thanks

Zabair

---

The contents of this e-mail may be privileged and are confidential. It may not be disclosed to or used by anyone other than the addressee(s), nor copied in any way. If received in error, please advise the sender, then delete it from your system. National Westminster Bank Plc is regulated by the Personal Investment Authority and IMRO for investment business. A member of the NatWest and Gartmore Marketing Group advising on the life assurance, pensions and unit trust products only of that Marketing Group. Registered Office: 41 Lothbury London EC2P 2BP Registered Number: 929027 England

---

Received on Fri May 19 2000 - 09:48:24 CDT