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@xxxxxxxxx> 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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on
behalf of Asad <asad.hasan2004@xxxxxxxxx>
*Sent:* Thursday, March 23, 2023 9:00:47 PM
*To:* oracle-l@xxxxxxxxxxxxx <oracle-l@xxxxxxxxxxxxx>
*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