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
1
vote
1 answer

Oracle Advanced Queue - Performance Issue in Consumption Rate

We've performed a performance test with Oracle Advanced Queue on our Oracle DB environment. We've created the queue and the queue table with the following script: BEGIN DBMS_AQADM.create_queue_table( queue_table =>…
Casper
  • 107
  • 2
  • 12
1
vote
1 answer

Oracle Advanced Queue - Removing Message after Dequeue

We're using Oracle JMS APIs to read messages from Advanced Queue. We use the following piece of code to read the messages from the queue: MessageConsumer consumer = sess.createConsumer(q); for (Message m; (m = consumer.receive()) != null;)…
Casper
  • 107
  • 2
  • 12
1
vote
1 answer

advanced queuing for table replication to other database

So, I am trying to replicate the data in tables to another database using Advanced Queuing. I created a table on both databases: create table test ( id number(10) primary key, text varchar2(100) ); then I created the queue create type…
a.j. tawleed
  • 894
  • 1
  • 8
  • 22
1
vote
1 answer

How to execute oracle DMBS_AQ.REGISTER behalf of different user?

One privileged scheduler user - user1 receive email notifications while two another (user2, user3) no. I want to execute code below on user3 schema, we tried this successfully on user2 (code executed directly on schema with temporary sys.dbms_aq…
jareeq
  • 311
  • 2
  • 9
1
vote
2 answers

Oracle AQ Enqueue Default Schema

From the Oracle documentation on the enqueue method of DBMS_AQ, it is specified that "Names for objects are specified by an optional schema name and a name. If the schema name is not specified, the current schema is assumed." [1] The system in…
Andrew
  • 777
  • 1
  • 7
  • 19
1
vote
1 answer

is it possible to achieve exponential retry-delay on Oracle AQ?

I would like to find out if it is possible to setup exponential retry delay on Oracle AQ subscription if the message is dequed from the AQ and cannot be processed I would like to rollback the meesage to the queue and retry after 1 min then 2 min and…
Yury Fedorov
  • 56
  • 4
1
vote
1 answer

Oracle AQ dequeue order

A trigger in an Oracle 10g generates upsert and delete messages for a subset of rows in a regular table. These messages consist out of two fields: A unique row id. A non-unique id. When consuming these message I want to impose an order on the…
yawn
  • 8,014
  • 7
  • 29
  • 34
1
vote
2 answers

Oracle: problem with constructing JMS message

After some struggle with Oracle Advanced Queuing and dbms_aq package I encountered another issue. I copied code from Oracle tutorials but when I compile this code: create or replace procedure jms_test(msg varchar2) is id …
Michał Niklas
  • 53,067
  • 18
  • 70
  • 114
0
votes
1 answer

Put a message from PL/SQL to a JMS Queue running OpenJMS Server

I want to put a message out of PL/SQL directly into a running Queue, which runs on the OpenJMS Server. Is this possible? I've read the Oracle Advanced Queue section, but I don't really get it. Could you add some code samples or snippets? Thank you…
Florian Müller
  • 7,448
  • 25
  • 78
  • 120
0
votes
1 answer

How to dequeue messages that were enqueued when app was offline (Oracle Advanced Queue)

I have 2 question. The following is the scenario - There are 2 different processes Process A and Process B. Process A enqueue's the message in the message queue. Process B dequeue's the message from the message queue. 1) Process B shuts down for…
Anand Emmanuel
  • 21
  • 1
  • 4
0
votes
2 answers

Is it a good idea to use Oracle 11g Client against a 10g database for Oracle Advanced Queuing?

I am developing some integration software for a client using amongst other things, C#, NServiceBus and Oracle 10g (client and server). The requirement is that I need to develop a new plugin for NServiceBus to create an implementation of ITransport…
Peter vd Merwe
  • 200
  • 6
0
votes
2 answers

Any possibilities for asynchronous task execution on oracle database

I work with a piece of software (WMS) where Oracle PL/SQL packages are a huge part of the business logic. I would like to introduce a way to asynchronously do some calculations which are triggered by an event. For some better understanding, we are…
Valsby
  • 13
  • 1
0
votes
0 answers

Event Based Oracle scheduler Job

I would like to create an event-based scheduled job. This job should stop whenever a scheduler generates an event of type JOB_OVER_MAX_DUR. I have written the following code, which currently only works for scheduler jobs within the admin schema.…
Zurich
  • 1
0
votes
0 answers

What is difference between Oracle Advanced Queues(AQs) and Oracle Transactional Event Queues (TEQs)?

What is difference between Oracle Advanced Queues(AQs) and Oracle Transactional Event Queues (TEQs) from usage/user perspective ?
Chandu
  • 1,837
  • 7
  • 30
  • 51
0
votes
0 answers

Oracle AdvancedQueuing: failing to broadcast (ORA-24033: no recipients for message, Python client)

I am referring to the following project on GitHub: poc-oracle-aq The code responsible for publishing messages is located in scripts/publisher.py: def loop(connection, queue_high, queue_low, name): recipients = ['Subscriber01', 'Subscriber02',…
Christophe
  • 1,942
  • 3
  • 21
  • 29
1 2 3
4
5 6 7