In this Document
Symptoms
Cause
Solution
References

Applies to:

Symptoms

ORA-600[13011] deleting rows.

Analyze of the table and indexes in question doesn't fail with errors.

Cause

Bug 6112730 ORA-600 [13011] WHEN DELETING FROM TABLE
closed as a duplicate of Bug 7007924 WRONG RESULT FROM BITMAP INDEX

To reproduce the error/bug the following must be seen:

1) We have for both table and index stats gathered

2) Execution plan shows BITMAP CONVERSION

3) Error doesn't reproduce if any one of the indexes are dropped

REPRODUCIBILITY:

9.2.0.8 (64-Bit): No
9.2.0.8 (32-Bit): Yes
10.2.0.1/10.2.0.2: Yes
10.2.0.3 : Yes (but Ora-7445[_intel_fast_memcmp] instead of ora-600[13011])

Solution

Check to see if Patch 7007924 is available for your platform/version via My Oracle Support.

Or, any of these workarounds could be used:

a) Disable statistics on affected table.

b) use RULE hint:

DELETE /*+ RULE */ ........

c) set _b_tree_bitmap_plans=false in init.ora

References