Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Off Topic: Obtaining Thousandths of A Second from the O/S

Re: Off Topic: Obtaining Thousandths of A Second from the O/S

From: <jkstill_at_cybcon.com>
Date: Thu, 18 Jan 2001 16:03:29 -0800 (PST)
Message-Id: <10745.127096@fatcity.com>


On Thu, 18 Jan 2001, MacGregor, Ian A. wrote:

> A member of our controls group, they're the people who actually run the accelerator,
> is talking about storing "real time" status information of various components in
> oracle. She needs to store the status time down to milliseconds. So sysdate will
> not do. I was thinking of using an oracle date field, plus another field to store
> the fractional seconds.
>

...

Ian, check out the high resolution timer.   man gethrtime

It will do nanoseconds.

This could be used as an external lib
in Oracle 8+. Received on Thu Jan 18 2001 - 18:03:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US