Oracle Advanced Queuing

Oracle Advanced Queuing
Name	Oracle Advanced Queuing
Developer	Oracle Corporation
Released	1999
Latest release version	12c / 19c (varies by platform)
Programming language	PL/SQL, SQL
Operating system	Oracle Database on Unix, Linux, Windows
License	Proprietary

Oracle Advanced Queuing

Oracle Advanced Queuing is a message queuing and notification feature integrated into the Oracle Database family that provides asynchronous communication, reliable messaging, and event notification for enterprise applications. It enables developers and architects to implement decoupled systems across distributed environments, integrating with middleware such as Oracle Fusion Middleware, IBM MQ, Apache Kafka, and Microsoft Message Queuing via adapters and gateways. Widely used in industries relying on AT&T-scale telecommunication systems, JPMorgan Chase banking integrations, and enterprise resource planning projects involving SAP SE and PeopleSoft, it supports transactional semantics and queuing models suited to enterprise workflows.

Overview

Oracle Advanced Queuing operates as a native queuing subsystem within the Oracle Database engine, offering persistent and non-persistent message storage, scheduling, and publish/subscribe patterns. It competes and interoperates with technologies like RabbitMQ, ActiveMQ, and TIBCO products while leveraging database features such as Oracle Real Application Clusters (RAC), Oracle Data Guard, and Oracle Streams for high availability and data replication. Designed for integration with middleware stacks from vendors including Red Hat, Microsoft, and IBM, it provides standards-based connectivity and supports enterprise integration scenarios found in organizations like Amazon (company) and Goldman Sachs.

Architecture and Components

The architecture centers on database-resident objects—queues, queue tables, subscribers, and agents—managed via SQL and PL/SQL. Core components include message stores in Oracle tablespaces, queuing agents that work with Oracle Scheduler, and propagation mechanisms that can use Advanced Replication or external gateways to interoperate with SOAP or REST endpoints. In clustered environments such as Oracle RAC and virtualized deployments on VMware ESXi, the queuing subsystem integrates with Oracle features like Flashback and ASM (Automatic Storage Management) for durability. Enterprise deployments often tie into Oracle Enterprise Manager, Splunk, or Dynatrace for monitoring.

Message Types and Payloads

Messages can be RAW, ADT (Abstract Data Type), or JMS-compliant, supporting payloads stored as BLOBs, CLOBs, or structured PL/SQL types. ADT messages allow schema-driven payloads modeled after ISO 20022 or FIX Protocol structures used in Deutsche Bank and Morgan Stanley integrations. JMS-mapped messages facilitate interoperability with Java EE, Spring Framework, and application servers like Oracle WebLogic Server and Apache Tomcat. Message attributes such as correlation identifiers, delay, expiration, and priority support enterprise patterns used by organizations like FedEx and UPS.

APIs and Interfaces

APIs include PL/SQL packages, SQL procedural calls, Java Message Service (JMS) providers for JDBC clients, and RESTful wrappers for web-based integration. Java clients use the javax.jms API and integrate with frameworks like Hibernate and Spring Boot for transaction management. .NET applications can connect via ODP.NET and interoperate with Microsoft SQL Server ETL processes in Informatica or Talend pipelines. Connectors exist for Oracle GoldenGate, Oracle SOA Suite, and cloud integration platforms such as Oracle Cloud Infrastructure and Amazon Web Services.

Administration and Management

Administration tasks are performed through SQL*Plus, Oracle SQL Developer, and Oracle Enterprise Manager consoles, with command-line utilities for creating queue tables, starting and stopping queue consumers, and purging messages. DBA responsibilities include space management in UNDO tablespaces, backup strategies aligned with RMAN, and tuning for workloads encountered in firms like Bloomberg L.P. or Reuters. Monitoring integrates with Prometheus and Grafana in modern DevOps stacks, and automation often uses Ansible or Terraform for infrastructure-as-code in deployments involving Google Cloud Platform or Microsoft Azure.

Security and Transactional Behavior

Security leverages database authentication, roles, and privileges, integrating with Oracle Identity Management, LDAP, and Kerberos realms for enterprise single sign-on used by Cisco Systems and Siemens. Messages participate in database transactions with ACID guarantees via two-phase commit coordination compatible with XA Transactions and middleware transaction managers from IBM WebSphere and Red Hat JBoss. Encryption at rest and in transit uses Transparent Data Encryption and TLS configurations consistent with compliance regimes such as PCI DSS, HIPAA, and GDPR enforced by large enterprises like Visa and Mastercard.

Performance, Scalability, and Use Cases

Performance tuning involves indexing strategies, partitioning, and parallel consumers to scale for high-throughput scenarios encountered by Netflix-style streaming, financial tick distribution used by Nasdaq and NYSE, and order processing at retailers like Walmart and Target Corporation. Scalability is achieved through sharding, partitioned queues, and integration with Oracle RAC and Oracle Exadata for I/O optimization. Common use cases include asynchronous integration in service-oriented architecture deployments, event-driven processing in microservices ecosystems, and enterprise workflow orchestration in supply chain systems used by Maersk and DHL. Optional categories: Category:Oracle software, Category:Message queuing