serious problem in advanced replication

[steve]

Hi,

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

[steve]

On Wed, 9 Feb 2005 18:10:26 +0800, steve wrote
(in article <00*****************************@news.newsguy.com> ):

Hi,

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

fixed , a loop