Oracle ST_GEOMETRY update performance (ArcGIS 10.3, Oracle 11.2.0.4.0)

GertrudWaich1 — Fri, 22 Jan 2016 11:51:45 GMT

Hi,

I have to convert frequently 177723 points to ST_GEOMETRY in a geodatabase in Oracle. The points are stored in a table called PARAMS in a character field (Temp_Geometry) in the following format:

point ( 7.0 3.0 )

point (55.0 63.5)

....

The update of the GEOMETRY with the SQL statement below takes 18 minutes!

SQL> update PARAMS set GEOMETRY = (sde.st_geometry(Temp_Geometry,4326));

177723 rows updated.

Elapsed: 00:18:28.09

Updates on other fields are done within seconds -->

SQL> update PARAMS set Valid_To=sysdate where to_char(VALID_TO,'YYYY-MM-DD') = '9999-12-31';

177723 rows updated.

Elapsed: 00:00:04.14

Droping the spatial index does not have any influence on the performance. Any ideas how to speed up the ST_Geometry update?

Thanks!

Re: Oracle ST_GEOMETRY update performance (ArcGIS 10.3, Oracle 11.2.0.4.0)

George_Thompson — Fri, 22 Jan 2016 15:38:13 GMT

Adding a bigger audience.....

Geodatabase

topic Oracle ST_GEOMETRY update performance (ArcGIS 10.3, Oracle 11.2.0.4.0) in ArcGIS Enterprise Questions

Oracle ST_GEOMETRY update performance (ArcGIS 10.3, Oracle 11.2.0.4.0)

Re: Oracle ST_GEOMETRY update performance (ArcGIS 10.3, Oracle 11.2.0.4.0)