oracle建队列,oracle 队列表（Oracle队列表）.doc

oracle 队列表(Oracle队列表)

oracle 队列表(Oracle队列表)

List of Oracle teams

The first contact with this gadget, found that the introduction of its online information is not much, to find a predecessor blog, more detailed, but the process is too long to read at first glance is not easy to understand,

Therefore, write a combination of his articles, and their own tests and official documents on the data to sort out the cost of writing. What is amiss, forget to correct. (there's no real use of it, just to sort out the process of testing.)

I. overview

Preface

1. The application of a general system can be divided into: immediate execution and delayed execution; it is important to distinguish this.

In order to improve the system performance and shorten the system waiting time, the queue technique is introduced.

A queue is a technique that efficiently divides application processing tasks into foreground tasks and background tasks. When the processing capacity is allowed, this technique stores messages, determines the priority of message processing, and goes to the application

Submit messages to play a part. It enables you to balance the load on your local computer, or assign tasks to remote computers. In order to reduce the waiting time of the user, the application allows the messages that need to be processed to be dropped into the team

Column. You can then remove the processing task from the presentation of the page. A background process reads and queues these messages, or can even be handed over by a separate system to process them.

The queue can realize the data sharing among each system, message communication.

2, functional overview

The purpose of writing this article is to use Oracle advanced queue to implement pl/sql code, and to interface for other languages to implement advanced queue functions.

The Oracle advanced queue has some benefits:

A advanced queue management is a feature of the Oracle database, which provides message queue management capabilities. This is a very reliable, secure, and scal