Degraded Performance Of Oracle Spatial Queries After Upgrading To 12.1.0.2 (Doc ID 2112307.1)

Last updated on MARCH 01, 2016

Applies to:

Oracle Spatial and Graph - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Performance of spatial queries degraded since upgrading to 12.1.0.2 from 11.2.0.3. A query with an average runtime of 0.41 seconds in 11.2.0.3 went to 1.35 seconds in 12.1.0.2.

Example query:

Changes

Database was upgraded from 11.2.x to 12.1.0.2.

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