| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Off Topic: Obtaining Thousandths of A Second from the O/S (SOL ARIS)
Hi Ian!
I do know that Oracle offers a timer in the virtual table v$timer.
How exact this timer is on different platforms might be found in the platform depended documentation.
The command "select * from v$timer;" returns a timer in hundredths of seconds.
Cheers
DO
email: info_at_materialdreams.com
web: www.materialdreams.com
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of MacGregor,
Ian A.
Sent: Thursday, January 18, 2001 11:03 PM
To: Multiple recipients of list ORACLE-L
Subject: Off Topic: Obtaining Thousandths of A Second from the O/S (SOL
ARIS)
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.
Is it possible to get milliseconds from a solaris O/S. When I was researching the infamous 248 days bug, I found that the time tick in solaris can be set to either hundredths or thousandth's of a second. Those with it set to thousandth's of a second would have seen the bug in 24.8 days. The clock ticks on our machines are set to hundredths of a second. Is it possible to get thousandths without changing this setting
Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MacGregor, Ian A.
INET: ian_at_SLAC.Stanford.EDU
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 18 2001 - 16:50:24 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |