Re: oracle: measurement in microseconds

From: Harald Maier <maierh_at_myself.com>
Date: Sat, 23 Aug 2003 09:38:55 +0200
Message-ID: <m3vfsox1ps.fsf@ate.maierh>

Daniel Morgan <damorgan_at_exxesolutions.com> writes:

> Pascal Ziegler wrote:
>
>> Hi,
>>
>> I need to measure the duration of a pl/sql-function
>> in microseconds. Do you know any possibility to do this
>> measurement with oracle (9i)?
>>
>> Thank you for the help. :-)
>>
>> - Pascal
>
> Look at the timestamp data type. It is as close as you are going to
> get.

Here an example:

,----

| SQL> select systimestamp from dual;
| 
| SYSTIMESTAMP
| -------------------------------
| 23.08.03 09:37:58,501550 +02:00

`---- Received on Sat Aug 23 2003 - 02:38:55 CDT