Wrong time showing in Oracle, however in OS time is running without problem
bsac14Dec 16 2009 — edited Dec 16 2009Hi ,
SYSDATE time is wrongly showing, Which is generating more number of junk sessions in database causing performance degrade.
1. What errors we are seeing?
There is a time change in database only for 10 seconds, which is going back one minute before and again it is resuming the actual time
Please find the log for more info
SYSDATE
--------------------
16-DEC-2009 09:35:27
SQL> /
SYSDATE
--------------------
16-DEC-2009 09:35:28
SQL> /
SYSDATE
--------------------
16-DEC-2009 09:35:28
SQL> /
SYSDATE
--------------------
16-DEC-2009 09:36:46
SQL> /
SYSDATE
--------------------
16-DEC-2009 09:36:46
SQL> /
SYSDATE
--------------------
16-DEC-2009 09:36:47
SQL> /
SYSDATE
--------------------
16-DEC-2009 09:36:47
SQL> /
SYSDATE
--------------------
16-DEC-2009 09:36:47
SQL> /
SYSDATE
--------------------
16-DEC-2009 09:36:48
SQL> /
SYSDATE
--------------------
*16-DEC-2009 09:36:48*
SQL> /
SYSDATE
--------------------
*16-DEC-2009 09:35:32*
SQL> //
SYSDATE
--------------------
16-DEC-2009 09:35:33
2. What changes have been done before this occurred?
We suspect the daylight saving might affect this issue
3. How often does this happen?
Every one minute
4. How does this impact your business?
Generating more duplidate sessions and degrade the performance.
Can you please help us
Thanks
Sakthi