Stats Gathering Spinning On Spatial Data After Upgrade To 12.1.0.2
(Doc ID 2051573.1)
Last updated on JUNE 17, 2021
Applies to:
Oracle Spatial and Graph - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
In an upgraded 12.1.0.2 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
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) -----
BEGIN DBMS_STATS.GATHER_DATABASE_STATS (degree=>8); END;
BEGIN DBMS_STATS.GATHER_DATABASE_STATS (degree=>8); END;
Changes
Database was upgraded to 12.1.0.2.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |