Time Synch on Oracle

[Leon Allen]

What little I know on the subject is this:

Setting time forward is no drama whatsoever: Oracle just see it as a period of no activity.

setting time backwards is a little bit trickerer, but usually OK as Oracle does not primarily use the system clock, but its own SCN's (system change numbers) to order a nd sequence things.

I've just synced a couple of servers using NTP with no drama.

[Alexander M. Ermes]

Hi Paul.
The idea with the system clock is correct.
We have some Oracle Applcations running.
The timestamps are exactly from the system clock, no matter if Unix, Linux or MS Win. So try to find a time server and sync your database servers to this one.
Rgds
Alex
p.s.
Hope you are allright after your trip

[Yogeeraj_1]

hi,

Oracle gets the time from
the OS. It does not have its own clock for telling wall clock time!

Also, the database server uses an internal clock called the SCN (system change number). It does not rely on the system wall clock.

cheers
Yogeeraj