Optimizer merge fix for Oracle 10.2.0.4

June 14, 2009 at 8:47 am

[] [] [] [] []

Symptom
Due to optimizer-specific patches, a new optimizer merge patch (8526100) was created and it fixes the following bugs:
8526100: OPTIMIZER MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR SAP (#13)
6642751: SELECT USING OPTIMIZER_MODE = FIRST_ROWS_10 FAILS WITH
ORA-7445 [_QKABXO+18]
7695742: DBMS_STATS.IMPORT_SCHEMA_STATS TAKES VERY LONG
8355120: PEFORMANCE PROBLEM BASED ON SUBQUERY UNNESTING
8366255: WRONG RESULT FROM DIFFERENT SESSIONS EVEN PLANS ARE [...]

kks* merge fix for Oracle 10.2.0.4

June 14, 2009 at 8:47 am

[] [] [] [] []

Symptom
Due to various Oracle errors in the kks* program modules, the additional merge fix 8501908 is provided to fix the following bugs:
8501908: MERGE LABEL REQUEST ON TOP OF 10.2.0.4
FOR BUGS 8493594 6053134
6053134: PERF REGRESS PQ 503, SORT ON DISK 25 %, DUE TO PROBLEM WITH
ALTER SESSION
8493594: MERGE LABEL REQUEST ON TOP OF 10.2.0.4
FOR BUGS [...]