Solution : https://service.sap.com/sap/support/notes/354080 (SAP Service marketplace login required)
Key words :
Performance, runtime, TIME_OUT, timeout
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 |