When we add Layer from Oracle 19c (SDO_GEOM geometry), there is dialog for calculating extent.
If we chose first or second option, it takes over 30 minutes for application to respond.
If we check sessions on database there is following select with full table scan which can't be terminated. Sum of elapsed time and remaining time is over 1700 seconds.
SELECT SDO_AGGR_MBR (GEOM)
FROM CGIS_WEBGIS.ZKN_GR x
WHERE x.GEOM.SDO_GTYPE IS NOT NULL
If we manualy enter Extent for that layer, why application still run this sql statement ?
Table has over 5Mio polygon records.
We have Oracle 19C and Arcgis Pro 2.9.3.