Getting Started with Oracle AQ

There are five basic steps involved in using Oracle AQ:

  1. Install Oracle AQ for use in your database. For this, the underlying database objects must be created and the initialization file for the instance modified.

  2. Authorize administrative and operational privileges on queues.

  3. Set up the message queue tables and corresponding queues.

  4. Enqueue messages to a queue.

  5. Dequeue messages from a queue.

In many organizations, steps 1 through 3 will be performed by a database administrator. They require specific authorization and can be a complex process, depending on the type of queues you want to create. The fourth and fifth steps will be performed from within the PL/SQL programs that you have written to take advantage of this message queuing technology.

Steps 3, 4, and 5 are explained in detail later in this chapter. For now, let’s take a look at the steps you must take to install AQ and to grant the proper privileges to Oracle accounts in order to perform AQ activities.

Installing the Oracle AQ Facility

Oracle Corporation has established the following guidelines for use of Oracle AQ:

  • If you have a license to the Oracle8 Enterprise Edition with the Objects Option, then you will be able to take advantage of the full functionality of Oracle AQ.

  • If you have a license to the Oracle8 Enterprise Edition without the Objects option, then you will be able to use Oracle AQ with queues of type RAW only.

  • If you have a license to Oracle8 without the Enterprise Edition, you are not ...

Get Oracle Built-in Packages now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial