Red Gate forums :: View topic - Registering database every time , taking long time
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Data Compare for Oracle
Data Compare for Oracle forum

Registering database every time , taking long time

Search in Data Compare for Oracle forum
Post new topic   Reply to topic
Jump to:  
Go to page Previous  1, 2
Author Message
Michael Christofides



Joined: 20 Apr 2011
Posts: 85
Location: Red Gate Software

PostPosted: Mon Apr 22, 2013 7:42 pm    Post subject: Re: Reply with quote

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
Back to top
View user's profile Send private message
Michael Christofides



Joined: 20 Apr 2011
Posts: 85
Location: Red Gate Software

PostPosted: Tue Apr 23, 2013 10:41 am    Post subject: Reply with quote

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".
Back to top
View user's profile Send private message
ursusmaj



Joined: 10 Apr 2013
Posts: 4
Location: United Kingdom

PostPosted: Thu Nov 14, 2013 9:57 am    Post subject: A possible workaround Reply with quote

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
Back to top
View user's profile Send private message
Michael Christofides



Joined: 20 Apr 2011
Posts: 85
Location: Red Gate Software

PostPosted: Thu Nov 14, 2013 10:58 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Go to page Previous  1, 2
Page 2 of 2

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group