SAP Note 981875 - Optimizer merge fix for Oracle 10.2.0.2

Component : BW ORACLE - Oracle

Solution : https://service.sap.com/sap/support/notes/981875 (SAP Service marketplace login required)

Key words :
ziphp-ux pa-risc 64-bit /oracle/oracle 64-bit/oracle 10, ziphp-ux itanium 64-bit /oracle/oracle 64-bit/oracle 10, 10g hard parse cpu regression [ appopd->qksfrochild ]   5724540, appsperf rdbms optimizer chooses full scan due, zipsun solaris 64-bit /oracle/oracle 64-bit/oracle 10, zipsun solaris x86-64 /oracle/oracle 64-bit/oracle 10, ziplinux ibmpower 64-bit /oracle/oracle 64-bit/oracle 10, ziphp tru64 /oracle/oracle 64-bit/oracle 10, ziplinux itanium 64 /oracle/oracle 64-bit/oracle 10, nest loop join costing ignore parallelism

Related Notes :

1120875Shutdown immediate may take a long time > Oracle 9208/10202
1049390Poor performance for multiple OR conditions and IN lists
1040300Wrong values with Star Transformation Hint 9.2.0.8 /10.2.0.2
1039060Corrupt Blocks when using physical Standby DB
1037651Oracle 10.2.0.2: Long parsing times for complex joins
999126Performance improvement for star queries
997889Error ORA-04031 due to "_fix_control"
977319Incorrect values in Oracle 10.2 (II)
964858Incorrect vals w/ STAR_TRANSFORMATION_ENABLED in Oracle 10.2
929560ORA-00600[13009] occurs w/ SELECT FOR UPDATE on Oracle 9/10
871096Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.2
850306Oracle Critical Patch Update Program
354080Note collection for Oracle performance problems
176754Problems with CBO and RBO