0 Replies Latest reply on Aug 13, 2013 8:55 PM by DoubleASmith

    SQL Dev 4.0 - Database Diff - Slow Performance

    DoubleASmith

      Database Diff across DBO objects (~1200) is extremely slow (~20 mins).

       

      Test Case:

      1)  Choose Database Diff function.

      2)  Choose 2 DBO schemas.

      3)  Choose all objects owned by DBO schema (~1200 objects).

      4)  Run comparison.

       

      This comparison takes ~1 min in TOAD.  This comparison takes ~20 mins in SQL Developer.