Spatial Query Fails With ORA-00600 [kdsgrp1]
Last updated on OCTOBER 05, 2015
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
Database reporting the following error(s) in the alert.log:
Incident details in: /u01/app/oracle/diag/rdbms/dmsnpdb/dmsnpdb1/incident/incdir_2112559/dmsnpdb1_s000_5767_i2112559.trc
The internal error is raised for a Spatial query:
select cdmalcibop0_.BTS_ID as col_0_0_, cdmalcibop0_.SECTOR as col_1_0_, cdmalcibop0_.CARRIER as col_2_0_, cdmalcibop0_.RECORD_STATE as col_3_0_, cdmalcibop0_.LATITUDE as col_4_0_, cdmalcibop0_.LONGITUDE as col_5_0_, cdmalcibop0_.CELLID as col_6_0_, cdmalcibop0_.PN_OFFSET as col_7_0_, cdmalcibop0_.AZIMUTH as col_8_0_, cdmalcibop0_.FCC_CHANNEL as col_9_0_, cdmalcibop0_.CARRIER_TYPE as col_10_0_, cdmalcibop0_.SID as col_11_0_, cdmalcibop0_.NID as col_12_0_, cdmalcibop0_.MSC_ID as col_13_0_, cdmalcibop0_.HORIZONTAL_BEAM_WIDTH as col_14_0_, cdmalcibop0_.PN_INCREMENT as col_15_0_, cdmalcibop0_.BAND_CLASS as col_16_0_, cdmalcibop0_.CHANNEL_LIST as col_17_0_, cdmalcibop0_.REGISTRATION_ZONE as col_18_0_, cdmalcibop0_.TOTAL_ZONE as col_19_0_, cdmalcibop0_.VENDOR_ID as col_20_0_,cdmalcibop0_.CSFB_CAPABILITY as col_21_0_ from CDMA_LCIB_DATA_RECORD_ cdmalcibop0_ where SDO_WITHIN_DISTANCE(GEOM, SDO_GEOMETRY(2001, 8265, SDO_POINT_TYPE(77.670327 , 12.924859 , null), null, null), 'distance=25 unit=km')='TRUE' and RECORD_STATE=1;
and the call stack trace is rather generic for this ORA-600:
...kdsgrp1_dump qetlbr qertbFetchByRowID opifch2 opifch...
Checking for TABLE/INDEX inconsistency :-
analyze table CDMA_LCIB_DATA_RECORD_ validate structure cascade;
table is analyzed successfully.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms