High Number of Parses/Executes for Recursive Spatial Queries (Doc ID 1072918.1)

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***

Symptoms

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"

Cause

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