SDO_AGGR_MBR on points randomly causes ORA-00600 internal error with argument 'kope2_readstr232'
Hi all,
on two distinct 11.2 databases I have a problem: The following SQL randomly (in about 30% of the calls) fails when certain selected data from table E0101 is in table TEMP_WAHL_FFMKANAL (which serves as a "selection set" in our application and contains certain 28 entries).
---
select SDO_AGGR_MBR(E0101.GEO) BBOX from E0101 E0101
where (E0101.C01, E0101.C02) in (select C01, C02 from TEMP_WAHL_FFMKANAL where CTAB = 'E0101')
---
The error message is:
ORA-00600: internal error code, arguments: [kope2_readstr232], [81], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [19703], [13], [], [], [], [], [], [], [], [], [], []
If I get a result it is
SDO_GEOMETRY(3001, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1, 1), SDO_ORDINATE_ARRAY(3465139,536, 5550419,032, 95,76))
on two distinct 11.2 databases I have a problem: The following SQL randomly (in about 30% of the calls) fails when certain selected data from table E0101 is in table TEMP_WAHL_FFMKANAL (which serves as a "selection set" in our application and contains certain 28 entries).
---
select SDO_AGGR_MBR(E0101.GEO) BBOX from E0101 E0101
where (E0101.C01, E0101.C02) in (select C01, C02 from TEMP_WAHL_FFMKANAL where CTAB = 'E0101')
---
The error message is:
ORA-00600: internal error code, arguments: [kope2_readstr232], [81], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [19703], [13], [], [], [], [], [], [], [], [], [], []
If I get a result it is
SDO_GEOMETRY(3001, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1, 1), SDO_ORDINATE_ARRAY(3465139,536, 5550419,032, 95,76))
0