Stack Overflow
Stack Overflow

Questions tagged [advanced-queuing]

Oracle Advanced Queuing (AQ) is a sort of Message Oriented Middleware developed by Oracle Corporation and integrated into its Oracle database.

Oracle Advanced Queuing (AQ) is a sort of Message Oriented Middleware developed by Oracle Corporation and integrated into its Oracle database.

AQ uses database structures as a repository for asynchronous queuing as an element in various Oracle-oriented and heterogeneous operations.

For more info, check Introduction to Oracle Advanced Queuing

96 questions
0
votes
2 answers

Oracle AQ dequeue-ing parameters

I'm trying to dequeue messages from Oracle queueue and am having trouble with setting up dequeue_options. I am trying to dequeue messages that have ENQ_TIME greater than input value (timestamp). I managed to dequeue messages wihout parameters or by…
user1941235
  • 113
  • 1
  • 10
0
votes
1 answer

An example for using DBMS_AQ.POST and explanation of its utility

The DBMS_AQ package has a method called POST. The documentation says, This procedure posts to a list of anonymous subscriptions, allowing all clients who are registered for the subscriptions to get notifications of persistent messages.…
Mark Brady
0
votes
1 answer

Building Custom List Data Structure, Bound mismatch error in test harness

I'm writing a List ADT where I will be able to add/remove items anywhere in the list unlike (Stacks and Queues). I also want to be able to iterate through the list. So I'm creating pointers to keep track of items.When I try to add items in the list…
Shadid
  • 4,133
  • 9
  • 30
  • 53
0
votes
2 answers

Too much selects when using oracle aq and spring-jms

We started to use oracle AQ and spring-jms and it works fine. But when ~1000 messages goes though my queue BUS_BILLING_RECEIVE_QT there is 110000 selects I wrote below: select /*+ INDEX(TAB AQ$_BUS_BILLING_RECEIVE_QT_I) */ tab.rowid, tab.msgid,…
boris_dev
  • 232
  • 3
  • 12
0
votes
1 answer

GV$PERSISTENT_QUEUES Fields

I am wondering what the fields on the oracle table GV$PERSISTENT_QUEUES really mean. The Documentation: ENQUEUED_MSGS NUMBER Number of messages enqueued DEQUEUED_MSGS NUMBER Number of messages dequeued Note: This column will…
Florian Müller
  • 7,448
  • 25
  • 78
  • 120
0
votes
1 answer

Oracle AQ Java interface and custom message types

I am using the Oracle Java interface for AQ and want to dequeue messages. These messages consist out of two fields: A unique row id. A non-unique id. I successfully decoded messages using a single RAW payload like this: AQDequeueOption option =…
yawn
  • 8,014
  • 7
  • 29
  • 34
1 2 3 4 5 6
7