Oracle Database Advanced Queuing (AQ)

Oracle Advanced Queuing (AQ) is a robust message queuing system integrated with the Oracle Database. This functionality leverages the functions of Oracle Database so that messages can be stored persistently, propagated between queues on different computers and databases, and transmitted using Oracle Net Services and HTTP(S).

Because Oracle Database Advanced Queuing is implemented in database tables, all operational benefits of high availability, scalability, and reliability are also applicable to queue data. Standard database features such as recovery, restart, and security are supported by Oracle Database Advanced Queuing. You can use database development and management tools such as Oracle Enterprise Manager to monitor queues.

Like other database tables, queue tables can be imported and exported. Similarly, advanced queues are supported by Oracle Data Guard for high availability, which can be critical to preserve your messages when using a stateless middle tier. By being in the database, enqueues and dequeues can be incorporated in database transactions without requiring distributed transactions.