Scenario :
I have a Queue which is used to send the data between Schema's ,so the subscriber is oracle(19c version).
Due to some reasons queue was being stopped so all the messages in the queue table are pending now to be dequeued.
After the Dequeue was up and a new message was enqueued only the new message was enqueued and dequeued.
Is there any parameter or a way that i can use to push the pending enqueued messages whenever the dequeue process stops and starts.
Parameters i am using are as below
First_message,next_message,no_wait,consume_name and msg_id