RE: EXPIRED messages in the WF_NOTIFICATION_OUT queue
- From: "Rolfe, Kent \(GTI AIS OPS/SE\)" <kent_rolfe@xxxxxx>
- To: <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Fri, 16 Jun 2006 12:59:56 +0100
Look up the definition of "retention" in the dba_queues - i.e. desc
dba_queues and you will see a column - look it up in the manual and it
should give you your answer.
-----Original Message-----
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Jurijs
Velikanovs
Sent: 16 June 2006 12:54
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: EXPIRED messages in the WF_NOTIFICATION_OUT queue
Hello team,
Please take a look on the following output.
There are 795 messages in the WF_NOTIFICATION_OUT queue in our LIVE
system.
Some of them have been put in the queue just today.
I wonder how messages in that queue become EXPIRED?
Is anybody experienced the same behavior?
Those messages are not dequeued and are not sent to end users.
What would be the right method to troubleshoot those type of messages?
Thank you in advance,
Yury
APPS:LIVE> alter session set nls_date_format='YYYY.MM.DD HH24:MI:SS';
Session altered.
APPS:LIVE>
APPS:LIVE> SELECT msg_state, count(*)
APPS:LIVE> FROM applsys.aq$wf_notification_out
APPS:LIVE> group by msg_state;
MSG_STATE COUNT(*)
------------- ----------
EXPIRED 795
PROCESSED 633
APPS:LIVE>
APPS:LIVE> SELECT o.enq_time
APPS:LIVE> FROM applsys.aq$wf_notification_out o
APPS:LIVE> where o.msg_state = 'EXPIRED'
APPS:LIVE> and trunc(o.enq_time) = trunc(sysdate);
ENQ_TIME
-------------------
2006.06.16 00:46:15
2006.06.16 00:46:15
2006.06.16 00:46:15
APPS:LIVE>
--
Yury
+44 7738 013090 (GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html
--------------------------------------------------------
If you are not an intended recipient of this e-mail, please notify the sender,
delete it and do not read, act upon, print, disclose, copy, retain or
redistribute it. Click here for important additional terms relating to this
e-mail. http://www.ml.com/email_terms/
--------------------------------------------------------
Other related posts:
