dbTalk Databases Forums  

serious problem in advanced replication

comp.databases.oracle comp.databases.oracle


Discuss serious problem in advanced replication in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
steve
 
Posts: n/a

Default serious problem in advanced replication - 02-09-2005 , 04:10 AM






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


Reply With Quote
  #2  
Old   
steve
 
Posts: n/a

Default Re: serious problem in advanced replication - 02-11-2005 , 03:36 PM






On Wed, 9 Feb 2005 18:10:26 +0800, steve wrote
(in article <0001HW.BE3002920001F820F04885B0 (AT) news (DOT) newsguy.com>):

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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.