AQ issue with delayed message

We have a process that deliberately delays all enqueued messages by a max of 900 seconds. Usually between 60 and 900 seconds. Since Sunday (fall back switchover) what we have seen is in the aq$queue_table view, enq_time, enq_timestamp and delay column show correct value. First two columns are close to sysdate and delay column is 15 minutes away. But the delay_timestamp time is an hour away.

This is causing all messages to be sent out delayed by an hour, which of course is unacceptable. While we are working with OWS, I wanted to find out if anyone has encountered this issue.

DB: 10.1.0.4 <http://10.1.0.4>, RAC. Bouncing AQ processes didn't help. What i noticed is that for the view aq$queue_table the delay column has a timestamp with timezone conversion but I think that value is wrong.

 msg_id enq_time enq_timestamp delay delay_timestamp 04C2AA7B041180ACE043AC16A84180AC 11/4/2005 1:42:22 PM 11/4/2005 1:42: 22.235464 PM 11/4/2005 1:57:22 PM 11/4/2005 2:57:22.235464 PM 04C285531BBE801EE043AC16A841801E 11/4/2005 1:31:59 PM 11/4/2005 1:31: 58.863202 PM 11/4/2005 1:46:59 PM 11/4/2005 2:46:58.863202 PM 04C285531BBE801EE043AC16A841801E 11/4/2005 1:31:59 PM 11/4/2005 1:31: 58.863202 PM 11/4/2005 1:46:59 PM 11/4/2005 2:46:58.863202 PM 04C261257F4360C0E043AC16A84160C0 11/4/2005 1:21:52 PM 11/4/2005 1:21: 51.894160 PM 11/4/2005 1:36:52 PM 11/4/2005 2:36:51.894160 PM 04C261257F4360C0E043AC16A84160C0 11/4/2005 1:21:52 PM 11/4/2005 1:21: 51.894160 PM 11/4/2005 1:36:52 PM 11/4/2005 2:36:51.894160 PM

The timezone conversion is as follows ... cast(FROM_TZ(qt.delay, '-04:00') at time zone sessiontimezone as date) delay but since it is auto generated code, we can't mess with it.

any clue's as to what is happening?? sysdate and host date time is accurate, we have and use our own time server (been doing this since a long time).

TIA
Raj
--
--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 04 2005 - 13:24:27 CST