Re: views related to advanced queuing ?

From: ykhogaly <ykhogaly_at_us.oracle.com>
Date: Thu, 23 Dec 1999 21:23:45 -0700
Message-ID: <83uout$5nb$1@inet16.us.oracle.com>

Hello,

 Check out Appendix A in Oracle8 Server Reference Guide--lists all the wait events including this one "WaitEvent: queue messages"

 Definition: This is part of the Advanced Queuing. The dequeuer waits on this until a timeout or an enqueuer posts us.

 Wait Time: The time waited depends on where we are dequeuing from and whether we were asked to wait forever or not.

 Parameters:

---

 P1 queue id
 P2 process#
 P3 wait time

 Commentary: This is basically an idle event while waiting to dequeue.

 Thanks!

"The Views expressed here are my own and not necessarily those of Oracle Corporation"

<tedchyn_at_yahoo.com> wrote in message news:83tg9p$k09$1_at_nnrp1.deja.com...
> 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 - 22:23:45 CST