In this Document
Symptoms
Cause
Solution
References
Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.8 to 11.1.0.7 - Release: 9.2 to 11.1Information in this document applies to any platform.
***Checked for relevance on 15-Dec-2011***
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
BUG:6112730 - ORA-600 [13011] WHEN DELETING FROM TABLE![](https://i-blog.csdnimg.cn/blog_migrate/200491d1ae6203cbdf7e02dca39a75b1.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/200491d1ae6203cbdf7e02dca39a75b1.gif)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17252115/viewspace-753115/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17252115/viewspace-753115/