Using SDO_BUFFER(geom,5) Results In Process Hang And High CPU Usage (Doc ID 2222687.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

On 11.2.0.4 version, the following query hangs and consumes CPU

select SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(geom,5e-8) ,sdo_geom.sdo_buffer(t.geom, 5, 5e-6)
from KOTA.LM t
where rn=4;

top - 08:17:17 up 214 days, 11:51, 3 users, load average: 1.05, 0.86, 0.47
Tasks: 450 total, 2 running, 448 sleeping, 0 stopped, 0 zombie
%Cpu(s): 6.3 us, 0.1 sy, 0.0 ni, 93.5 id, 0.0 wa, 0.0 hi, 0.0 si, 0.0 st
KiB Mem : 14854476+total, 57028224 free, 3738316 used, 87778224 buff/cache
KiB Swap: 67108860 total, 67108860 free, 0 used. 13617088+avail Mem

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
13487 bugmnt 20 0 2081748 1.136g 151144 R 99.3 0.8 7:10.22 oracle
5924 bugmnt 20 0 818832 167868 157776 S 0.3 0.1 33:04.57 oracle_5924_tar
12469 bugmnt 20 0 684856 19328 17116 S 0.3 0.0 0:00.18 oracle
25973 bugmnt 20 0 1274612 106076 102184 S 0.3 0.1 12:58.38 ora_dbrm_orcl
26082 bugmnt 20 0 1273356 19336 16984 S 0.3 0.0 0:37.18 ora_p00k_orcl

The problem is not seen on 11.2.0.3 or 12.1.0.x

Using 10 instead of 5 does not duplicate the problem

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