Re: Sysdate time-resolution ?

In the article <320f5ace.10432050_at_dcsun4>, tkyte_at_us.oracle.com (Thomas J. Kyte) wrote :
>
> Unfortunately I started this bad habit.
>
> The problem is the value in v$timer at the level of hsecs but from some
> arbritrary point in time. The clock in v$timer is NOT in sync with the clock
> used by SYSDATE. (well you have a 1 in 100 chance of them being in sync).
>
> Basically you can get times like:
>
> 12-AUG-1996 10:33:14.49
> 12-AUG-1996 10:33:14.76
> 12-AUG-1996 10:33:15.90
> 12-AUG-1996 10:33:15.15
> 12-AUG-1996 10:33:15.40
>
> (eg: they are not increasing all the time, the SYSDATE clock rolled over to 15
> seconds before the v$timer clock does).
>

Ok !
Now to the easy part :
Is it possible to somehow synchronize the sysdate-timer and v$timer ?

If not.., any other ideas ?

--
----------------------------------------------------------
| Alexander Moan	 --:-)		      moan_at_sn.no |
| Any statements I make are my own, and are not to be    |
| taken as an statement from my employer.                |
|                                                        |
| Norwgian Defence Command Norway			 |
| Home Guard Staff					 |
|							 |
| "Don't blame me, I just work here !"			 |
---------------------------------------------------------