High Number of Parses/Executes for Recursive Spatial Queries
Last updated on JANUARY 22, 2013
Applies to:Oracle Spatial - Version 10.2.0.1 to 10.2.0.3 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 22-Jan-2013***
A very high number of parses/executes are seen for recursive SQL statements like the following when executing a Spatial query having Spatial functions:
select wktext, srid from mdsys.cs_srs where srid = :"SYS_B_0"
select count(*) from mdsys.geodetic_srids where srid = :"SYS_B_0"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms