Registering database every time , taking long time

Compares and synchronizes Oracle data

Moderators: eddie davis, richardjm, Michael Christofides, neil.anderson

Re:

Postby Michael Christofides » Mon Apr 22, 2013 7:42 pm

ginjupalli.pavan wrote:I cannot find any option in this forum for me to attach the screenshot of the error but here is the text of error
X Creating Deployment Script
"Exception has been thrown by the target of the invocation"


Please do feel free to email the screen shot in to oracle@red-gate.com, and send the error report in to if there was one.

Best regards,
Michael
Michael Christofides
 
Posts: 94
Joined: Wed Apr 20, 2011 6:37 pm
Location: Red Gate Software

Postby Michael Christofides » Tue Apr 23, 2013 10:41 am

Thank you for sending in the screenshot and error report Pavan.

For anybody else that comes across a similar error in future, this one turned out to be an \"ORA-01555: snapshot too old\".
Michael Christofides
 
Posts: 94
Joined: Wed Apr 20, 2011 6:37 pm
Location: Red Gate Software

A possible workaround

Postby ursusmaj » Thu Nov 14, 2013 9:57 am

The approach we have taken to dealing with this performance issue has been to create a specific user and role in Oracle (\"the data compare user\") with access to only a sub-set of the tables within the schema we are trying to compare.

The somewhat simplistic approach we have taken is to use a stored procedure to only grant access to non-empty tables to the data compare user. This reduces the number of tables visible to the DCO user to around 3500 which has a dramatic effect on the performance for us:

1. The project stored on disk is some 20 Mb rather than 700 Mb+.
2. The time taken to open/modify the project is reduced from an hour to a couple of minutes.
3. The memory usage of the DCO application is reduced significantly.

Obviously, there are some issues with the approach we have taken:

(a) You need to choose the list of tables to which access is granted AND ensure the same list is granted in each database since the same set of tables may not be empty in each one.
(b) The list of accessible tables needs to be updated as changes occur.

However, compared to the alternative performance issue these are minor from my perspective.

I hope this helps others experiencing this issue.
Regards,
Cliff
ursusmaj
 
Posts: 4
Joined: Wed Apr 10, 2013 9:49 am
Location: United Kingdom

Postby Michael Christofides » Thu Nov 14, 2013 10:58 am

Cliff, thank you for sharing this, and nice idea.

I'll make sure this gets to the right people for next time we're planning Data Compare work.

Best regards,
Michael
Michael Christofides
 
Posts: 94
Joined: Wed Apr 20, 2011 6:37 pm
Location: Red Gate Software

Previous

Return to Data Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests