What are the challenges you face when working across database platforms? Take the survey

How many impact when it do comparing the data?

jerrylinjerrylin Posts: 2
edited July 8, 2016 10:34AM in Data Compare for Oracle
I want to know how does the "Data compare for Oracle" to compare the data?
When it comparing ,does any impact for OS or Oracle ?

Thank you.


  • Options
    Our comparison tool uses select statements in order to compare data so as per my knowledge shouldn't be having any performance impact on source or target.

    The speed of the comparisons depends heavily on the structure of the data, amount of data and of course the speed of the connection. As a general guide, small, simple, data sets over local connections can take seconds. Huge data sets with many BLOB and CLOB columns can take several hours.

    Speed is generally cited by our customers as a key advantage of our tools over competitors, there are several testimonials here: http://www.red-gate.com/products/oracle ... le/reviews

    You can filter a comparison to a much smaller set to test the tool in various ways. You can reduce the number of tables in the comparison, or select only specific columns to compare, or you can specify a where clause on individual tables to reduce the number of rows being compared. Details on all of these can be found from this page: http://documentation.red-gate.com/displ ... comparison
    Sarah Beckett| Customer Support| Redgate Software
    Have you visited our Help Center? 
Sign In or Register to comment.