BUG 13931044 – ORA-600 [13009], [5000], [1], [17]

在BUG 13931044 – ORA-600 [13009], [5000], [1], [17]中  相关的语句:
SELECT * FROM PART_BRANCH_PC_BATCH_VIEW2 WHERE PAB_BRA_BRANCH_CODE = :B1 FOR UPDATE
 
也是没有Nested Loop的,但是通过”_nlj_batching_enabled”=false 绕过了该问题, 所以还是建议先使一下使用“_nlj_batching_enabled”=false作为workaround的情况。
DIAGNOSTIC ANALYSIS
===================
The same batch job fails on several databases but does not reproduce at
will. The databases are not clones of eachother but are running the same
batch job.
The problem started after the database was upgraded from 10.2 to 11.2 via
datapump.
Underlying tables have been analyzed without problems.
The patch for bug 13117043 was applied but the problem continued.
Running with “_nlj_batching_enabled”=0 avoids the error but testing is still
underway to see if this can be used as a temporary workaround.
The query plan doesn’t change if set “_connect_by_use_union_all” =
old_plan_mode;
WORKAROUND?
===========
Yes
TECHNICAL IMPACT
================
Customer runs the same batch on multiple databases which includes select for
update statement – the batch fails on some of the databases
SELECT * FROM PART_BRANCH_PC_BATCH_VIEW2 WHERE PAB_BRA_BRANCH_CODE = :B1 FOR
UPDATE
RELATED ISSUES (bugs, forums, RFAs)
===================================
Select For Update Fails With Ora-600 [13009] Error On A Table With A
Recently Added Column (Doc ID 863779.1) –> solved in 11.2 and CT doesn’t
want to recreate the tables involved in the view called in the failing SQL
 

 


Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *