WF_DEFERRED Entries bearing incorrect ENQ_TIME with -05:00 TZ offset
edited Aug 16, 2011 3:18AM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered
WF_DEFERRED Entries bearing incorrect ENQ_TIME with -05:00 TZ offset
We've verified the below Oracle notes but they both say that the issue has been fixed in 11.2
Note:429630.1 - A Dequeue Condition fails to work properly after a Daylight Savings Time Change
and Note:429681.1 - Casting AQ$QUEUE_TABLE Enqueue and Dequeue Time Values To SESSIONTIMEZONE causes Reporting and Message Processing issues.
This issue is happening in all our R12 envs including Production. We are on 11.2.0.1.
We've observed WF_DEFERRED table is having the TIMEZONE value of "-05:00" in AQ$_QUEUE_TABLES.
Also,
SQL> select dbtimezone, sessiontimezone,SYSTIMESTAMP,CURRENT_TIMESTAMP from dual;
We've verified the below Oracle notes but they both say that the issue has been fixed in 11.2
Note:429630.1 - A Dequeue Condition fails to work properly after a Daylight Savings Time Change
and Note:429681.1 - Casting AQ$QUEUE_TABLE Enqueue and Dequeue Time Values To SESSIONTIMEZONE causes Reporting and Message Processing issues.
This issue is happening in all our R12 envs including Production. We are on 11.2.0.1.
We've observed WF_DEFERRED table is having the TIMEZONE value of "-05:00" in AQ$_QUEUE_TABLES.
Also,
SQL> select dbtimezone, sessiontimezone,SYSTIMESTAMP,CURRENT_TIMESTAMP from dual;
0