serious problem in advanced replication

I have a 2 demo systems for testing code, they use advance replication.

I am seeing single transactions with >6000 calls!!!, obviously something is very wrong.

I suspect an application loop.

normally you can use the admin console to display the transactions and get a breakdown of the calls.
oracle very thoughtfully, did not allow , a sub-selection of the transactions to be shown.  

In this case this is obviously not going to work!!, to try to pull 6000 calls to view the information.

does anyone have a sql query to see the information & display it , I can then add row limits.

steve Received on Wed Feb 09 2005 - 11:10:26 CET