Introduction to Oracle Advanced Queuing (AQ)

1.   Introduction

http://www.oracle-developer.net/display.php?id=411

2.   Troubleshooting Advanced Queuing and Oracle Streams Propagation Issues (Doc ID 233099.1)

http://blogs.oracle.com/db/entry/oracle_support_master_note_for_troubleshooting_advanced_queuing_and_oracle_streams_propagation_issue

3.   Data Dictionary Views for Advance Queuing

 -- List of Queue Tables

SELECT * FROM dba_tables;

-- List of all the Queues

SELECT * FROM dba_queues;

-- List of Messaging Gateways

SELECT * FROM mgw_gateway

-- List of Queues in Queue Table

SELECT * FROM ppid_staging.aq$ppid_qtab_ack

-- List of Queues and its Subscribers/Consumers

select * from all_queue_subscribers

-- List of Foreign Queues

SELECT * FROM mgw_foreign_queues

--List of MQ Links Details (Host/Port/Channel)

SELECT * FROM mgw_mqseries_links

--List of Schedules, Types(Outbound/Inbound) Source,Target

SELECT * FROM mgw_schedules;

--List of Queue Schedules for AQ to AQ messaging

SELECT * FROM dba_queue_schedules

-- Registry

SELECT * FROM dba_registry

BEGIN

    dbms_mgwadm.startup;

END;

/

BEGIN

    dbms_mgwadm.shutdown;

END;

/