Re: AQ - Check and troubleshoot

Thanks thats helpful to start this particular apps is for DB to DB replication , is there a was we can identify that AQ is working or not like we se status of objects and see if its valid or invalid ,

I queries dba_queues and it gave me the apps_quetablename , after querying apps_quetablename I found messages which are enqued by not dequed , in my case AQ$<queue_table_name> is same as apps_quetablename.

On Fri, Mar 24, 2023 at 7:28 AM Karthikeyan Panchanathan < keyantech_at_gmail.com> wrote:

> 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
>

-- 
Asad Hasan
+91 9582111698

--
http://www.freelists.org/webpage/oracle-l