Streams AQ: waiting for messages in the queue

The session is waiting on an empty OLTP queue (Advanced Queuing) for a message to arrive so that the session can dequeue that message.

Wait Time: The amount of time that the session wants to wait is determined by the parameter wait time


Parameter Description

queue id

The ID of the OLTP queue for which this session is waiting

process#

The process number of the process in which this session runs

wait time

The intended wait time for this session