List of Tables

1-1 Oracle Streams AQ Demonstrations

1-2 Oracle Streams AQ JMS Demonstrations

1-3 Oracle Streams AQ XML Demonstrations

2-1 AQ$_REG_INFO Type Attributes

2-2 AQ$_DESCRIPTOR Attributes

2-3 Enumerated Constants in the Oracle Streams AQ Administrative Interface

2-4 Enumerated Constants in the Oracle Streams AQ Operational Interface

3-1 Oracle Streams AQ Programmatic Interfaces

3-2 Comparison of Oracle Streams AQ Programmatic Interfaces: Administrative Interface

3-3 Comparison of Oracle Streams AQ Programmatic Interfaces: Operational Interface-Create Connection, Session, Message Use Cases

3-4 Comparison of Oracle Streams AQ Programmatic Interfaces: Operational Interface-Enqueue Messages to a Single-Consumer Queue, Point-to-Point Model Use Cases

3-5 Comparison of Oracle Streams AQ Programmatic Interfaces: Operational Interface-Publish Messages to a Multiconsumer Queue/Topic, Publish/Subscribe Model Use Cases

3-6 Comparison of Oracle Streams AQ Programmatic Interfaces: Operational Interface-Subscribing for Messages in a Multiconsumer Queue/Topic, Publish/Subscribe Model Use Cases

3-7 Comparison of Oracle Streams AQ Programmatic Interfaces: Operational Interface-Browse Messages in a Queue Use Cases

3-8 Comparison of Oracle Streams AQ Programmatic Interfaces: Operational Interface-Receive Messages from a Queue/Topic Use Cases

3-9 Comparison of Oracle Streams AQ Programmatic Interfaces: Operational Interface-Register to Receive Messages Asynchronously from a Queue/Topic Use Cases

4-1 Operations and Required Privileges

9-1 AQ$Queue_Table_Name View

9-2 AQ$Queue_Table_Name_S View

9-3 AQ$Queue_Table_Name_R View

9-4 AQ$INTERNET_USERS View

9-5 GV$STREAMSMETRIC View

9-6 GV$STREAMSMETRIC View

9-7 DBA_HIST_STREAMSMETRIC View

9-8 DBA_ATTRIBUTE_TRANSFORMATIONS View

9-9 MGW_GATEWAY View Properties

9-10 MGW_AGENT_OPTIONS View

9-11 MGW_LINKS View Properties

9-12 MGW_MQSERIES_LINKS View Properties

9-13 MGW_TIBRV_LINKS View Properties

9-14 MGW_FOREIGN_QUEUES View Properties

9-15 MGW_JOBS View

9-16 MGW_SUBSCRIBERS View Properties

9-17 MGW_SCHEDULES View Properties

11-1 StreamMessage Conversion

11-2 MapMessage Conversion

11-3 Oracle Streams AQ and Oracle JMS Buffered Messaging Constants

18-1 SID_DESC Parameters

19-1 Messaging Gateway Propagation Job Subprograms

19-2 WebSphere MQ Link Properties

19-3 Optional Configuration Properties for WebSphere MQ Base Java

19-4 Optional Configuration Properties for WebSphere MQ JMS

19-5 TIB/Rendezvous Link Properties

19-6 Optional Properties for TIB/Rendezvous

20-1 MGW Names for WebSphere MQ Header Values

20-2 Default Priority Mappings for Propagation

20-3 TIB/Rendezvous Datatype Mapping

20-4 TIB/Rendezvous and MGW Names for Oracle Streams AQ Message Properties

20-5 Oracle JMS Message Conversion

22-1 Propagation Between Different Types of Queues

A-1 Actions Performed for Nonpersistent Queues When RAW Presentation Specified

A-2 Actions Performed for Nonpersistent Queues When XML Presentation Specified