My Oracle Support Banner

Stats Gathering Spinning On Spatial Data After Upgrade To (Doc ID 2051573.1)

Last updated on JULY 13, 2018

Applies to:

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


In an upgraded database, statistics gathering on tables with spatial index spins or generates errors.

Alert.log shows:

Fri Jul 03 03:58:13 2015
Errors in file /ora/app/oracle/diag/rdbms/orcl12c/ORCL12C/trace/ORCL12C_ora_18808.trc  (incident=49210):
ORA-00600: internal error code, arguments: [17147], [0x7F95D6C08040], [], [], [], [], [], [], [], [], [], []
Incident details in: /ora/app/oracle/diag/rdbms/orcl12c/ORCL12C/incident/incdir_49210/ORCL12C_ora_18808_i49210.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /ora/app/oracle/diag/rdbms/orcl12c/ORCL12C/trace/ORCL12C_ora_18808.trc  (incident=49211):
ORA-00600: internal error code, arguments: [kghuclientasp_03], [0x7F95FACA8128], [0], [0], [0], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17147], [0x7F95D6C08040], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "MDSYS.SDO_STATISTICS", line 10

And the incident trace file shows:

----- Current SQL Statement for this session (sql_id=1ahg7a7ub5qws) -----


Database was upgraded to


To view full details, 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 a vibrant support community of peers and Oracle experts.