Re: Q: views related to advanced queuing ?

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 23 Dec 1999 09:38:55 -0800
Message-ID: <38625E2F.8E650746@us.oracle.com>

Ted

Not sure what you mean by advanced queuing time, but the error itself means this:

ORA-25228 timeout or end-of-fetch during message dequeue from string.string

Cause: User-specified dequeue wait time has passed or the end of the queue has been reached but no message has been retrieved.

Action: Try dequeue again with the appropriate WAIT_TIME or the FIRST_MESSAGE option.

So in most cases you'd need to look at what wait time was set for the dequeue.

HTH. Pete

tedchyn_at_yahoo.com wrote:

> Sir:
> Which view contain(s) advanced queuing time when I have
> following error:
> ORA-25228: timeout or end-of-fetch during message dequeue from
> AQ_MANAGER.Q_MONITOR_MESSAGES
>
> thanks in advance
> Ted Chyn
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Received on Thu Dec 23 1999 - 11:38:55 CST