3 Replies Latest reply: Jun 27, 2012 4:38 PM by user10160672 RSS

    Any known performance issue of SDO_GEOM.validate_layer_with_context in 11g?

    user10160672
      Hello,

      I'm testing for database upgrade from 10.2.0.4 to 11.2.0.3. It seems the SDO_GEOM.validate_layer_with_context procedure is much slower than in 10g. This one table takes 26 seconds in 10.2.0.4 and now it takes more than 20 minutes to validate.

      EXEC SDO_GEOM.validate_layer_with_context ('PARKS_SURVEYS', 'GEOMETRY', 'INVALID_RESULTS_6222012');

      Is there any known issues around this. Or do I need to do something to fix this?

      Thanks for any help!

      Sharon