High Number of Parses/Executes for Recursive Spatial Queries

(Doc ID 1072918.1)

Last updated on JANUARY 22, 2013

Applies to:

Oracle Spatial - Version to [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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms