Answer the question
In order to leave comments, you need to log in
Oracle AQ: options for reading a queue?
Good afternoon.
There is a table of queues in Oracle (queue_table), which records in large quantities.
The first thing that comes to mind is to add a subscriber to the table that will dequeue each record. But it's too costly. You can run a job that will read an array (dequeue_array) of records once a minute. But the job is also not the best solution.
What other options could there be for reading the queue?
Thank you.
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question