Re: changing server time which affects oracle time

From: Yong Huang <yong321_at_yahoo.com>
Date: 8 Sep 2004 06:39:04 -0700
Message-ID: <b3cb12d6.0409080539.2e93e2b6@posting.google.com>

yls177_at_hotmail.com (yls177) wrote in message news:<c06e4d68.0409070001.1338d5d3_at_posting.google.com>...
> hi, oracle transaction time comes from the server time? Therefore, if
> we changed the oracle time, then inherently, this will affect the
> oracle and transaction time, right? currently, we have an issue here.
> Some jobs were not run properly and we were advised by the other party
> that the only solution is to change the server time to past times, so
> as to enable the job to run. Afterwhich, we can update the time to the
> present time.

Hi, yls,

Can you find the reason why the job didn't run? Does dba_jobs.broken show 'Y'? Why not try running it manually (dbms_jobs.run) instead of messing with the system time?

What kind of job is it? If it's AQ and you see the queue table enqueue time ahead of sysdate, you hit a bug.

Yong Huang Received on Wed Sep 08 2004 - 08:39:04 CDT