Re: ms accuracy from Oracle

From: Naren Chintala <naren_at_mink.att.com>
Date: 1997/04/03
Message-ID: <3343DDA6.DB8@mink.att.com>#1/1

Joel Nylund wrote:
>
> I can get the time from oracle by doing a :
>
> Select to_char( SYSDATE, 'HH24:MI:SS:MM' ) SYSTEM_TIME from dual;
>
> but this only gives me seconds.
>
> I would like to do some benchmarks on SQL statements using millisecond
> precision, any ideas?
>
> thanks
> Joel

You may want to try this

1. Log into sqlplus
2. SET TIMING ON

This gives the time in 1/100th of a second for each SQL statement that is executed. This is the latency time and not the CPU execution time.

-- 
Naren

Received on Thu Apr 03 1997 - 00:00:00 CST