I'm testing for database upgrade from 10.2.0.4 to 188.8.131.52. 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!
Are your geometry 3D or 2D, geodetic or non-geodetic(projected)?
How many rows in PARKS_SURVEYS? How complex these geometries?
select max(SDO_UTIL.GETNUMVERTICES(geometry)), avg(SDO_UTIL.GETNUMVERTICES(geometry)) from PARKS_SURVEYS
Edited by: yhu on Jun 27, 2012 2:34 PM