Re: AQ - Check and troubleshoot

From: Karthikeyan Panchanathan <keyantech_at_gmail.com>
Date: Fri, 24 Mar 2023 01:58:56 +0000
Message-ID: <CO6P220MB0610500C0A32074112CE3624FF849_at_CO6P220MB0610.NAMP220.PROD.OUTLOOK.COM>

Usually AQ replication can be done DB to DB or DB to Application with MQ.

I would start from dba_queues/dba_queue_tables and their schedules in dba_queue_schedules

AQ messages will be on table AQ$<queue_table_name>

AQ subscriber details dba_queue_subscribers

If application access DB using MGW_GATEWAY make sure agent is in running state in above view.

HTH
Karth

Sent from Outlook for iOS<https://aka.ms/o0ukef>

---

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Asad <asad.hasan2004_at_gmail.com> Sent: Thursday, March 23, 2023 9:00:47 PM To: oracle-l_at_freelists.org <oracle-l_at_freelists.org> Subject: AQ - Check and troubleshoot

Hi All ,

        I have an application which is dependent on AQ for replication of its data , recently they said replication is not working . How do I start troubleshooting this what basic sql's can I use to understand whether AQ is working or not or its an application issue ?

--

Asad Hasan
+91 9582111698

--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 24 2023 - 02:58:56 CET