3 Replies Latest reply: Jun 27, 2012 5:00 PM by Ying Hu-Oracle RSS

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


      I'm testing for database upgrade from to It seems the SDO_GEOM.validate_layer_with_context procedure is much slower than in 10g. This one table takes 26 seconds in 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!