Solution : https://service.sap.com/sap/support/notes/354080 (SAP Service marketplace login required)
Key words :
execution plan shows sort-merge-joins, oracle data dictionary bw performance symptoms, oracle locks central database resources, cache buffer chains latches symptoms, insert operations perform poorly explanation, deactivating bw aggregates takes, cache buffer chains latchesoracle 8, dictionary-administered temporary tablespace, cbo makes incorrect decisions, lob information takes longer
Related Notes :
| 1013912 | FAQ: Oracle BW performance |
| 1002062 | Additional merge fix for Oracle 10.2.0.2 |
| 992261 | Optimizer merge fix for Oracle 9.2.0.8 |
| 981875 | Optimizer merge fix for Oracle 10.2.0.2 |
| 896903 | Optimizer merge fix for Oracle 9.2.0.7 |
| 889038 | Collective note: NWDI server component configuration |
| 871455 | Poor performance when accessing DBA and V$ views |
| 838725 | Oracle dictionary statistics and system statistics |
| 834100 | Merge fix for Oracle 9.2.0.6 |
| 766827 | Composite SAP note: Performance SCM 4.0 |
| 766349 | FAQ: Oracle SQL optimization |
| 755342 | Incorrect execution plans with bind variable peeking |
| 727310 | Wrong Results with ODS or Non-Star_Transformation Queries |
| 721332 | 9204: MJC in temporary table causes ORA-1652 (PARALLEL hint) |
| 721331 | 9204: MERGE JOIN CARTESIAN IN TEMP TABLE- STAR and FACT Hint |
| 695841 | TRUNCATE TABLE can take a long time |
| 695080 | Merge fix for Oracle 9.2.0.4 |
| 692646 | Performance Content Integrator |
| 684545 | Statistics generation: DBMS_STATS runs longer than ANALYZE |
| 632336 | Long runtimes when compiling statistics on Oracle 9.2.0.x |
| 626615 | Oracle 9i: Problems because of _B_TREE_BITMAP_PLANS |
| 618868 | FAQ: Oracle performance |
| 610445 | Merge fix for Oracle 9.2.0.3 |
| 601668 | Merge fix for Oracle 8.1.7.4 |
| 567745 | Composite note BW 3.x performance: DB-specific setting |
| 563359 | Performance optimization for tables with LOB columns |
| 558746 | Better Oracle Data Dictionary BW Performance |
| 558197 | upgrade hangs in PARCONV_UPG, XPRAS_UPG, SHADOW_IMPORT_UPG2, |
| 556764 | Upgrade hangs in phase ACT_<REL> |
| 521264 | Hang situations |
| 520568 | CBO: Long runtimes for large IN lists |
| 519407 | Performance problems accessing the datadictionary views |
| 488583 | Database hangs: Waits for cache buffer chain latch |
| 449136 | "cache buffers chains" latch contention on 8.1 |
| 359835 | Design of the temporary tablespace in the BW System |
| 336402 | Massive performance problems with 8.1.6 |
| 198752 | TCP delay problem under Oracle 8.1.x |
| 184905 | Collective note Performance BW 2.0 |
| 170989 | Poor performance under Oracle 8044, 805*, 8.0.6 |
| 164925 | Storage parameter of tablespace PSAPTEMP |
| 128221 | Increased memory consumption with Oracle >8.0.X |