在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_
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
Leave a Reply