Placing the queues in the database extends the core benefits of a database
to the queues themselves.
The data that flows through queues represents the ebb and flow of business activity.
Analyzing the types and volumes of message traffic can help to identify how different
business functions are operating and interacting and this, in turn, can provide
valuable insights into the operation of your business. AQ supports the notion of
Oracle Streams and Advanced Queuing | 219
message warehousing, in which the content and details of the queues can be queried
and analyzed because they??™re already in the database. Oracle can dequeue messages
but can leave historical data in the queues for subsequent analysis.
Applications can enqueue and dequeue messages as part of a transaction or as a separate
event that occurs as soon as the specific enqueue or dequeue statement is
issued. Queue actions included in the scope of a transaction are committed or rolled
back with that transaction. Should a failure occur, the queue activities are recovered
along with the rest of the database activity.
Pages:
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484