SAP Note 354080 - Note collection for Oracle performance problems

Composant : Oracle - Please use component node SV-BO*

Solution : https://service.sap.com/sap/support/notes/354080 (Connexion à SAP Service Marketplace requise)

Mots Clés :
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

Notes associées :

1013912FAQ: Oracle BW performance
1002062Additional merge fix for Oracle 10.2.0.2
992261Optimizer merge fix for Oracle 9.2.0.8
981875Optimizer merge fix for Oracle 10.2.0.2
896903Optimizer merge fix for Oracle 9.2.0.7
889038Collective note: NWDI server component configuration
871455Poor performance when accessing DBA and V$ views
838725Oracle dictionary statistics and system statistics
834100Merge fix for Oracle 9.2.0.6
766827Composite SAP note: Performance SCM 4.0
766349FAQ: Oracle SQL optimization
755342Incorrect execution plans with bind variable peeking
727310Wrong Results with ODS or Non-Star_Transformation Queries
7213329204: MJC in temporary table causes ORA-1652 (PARALLEL hint)
7213319204: MERGE JOIN CARTESIAN IN TEMP TABLE- STAR and FACT Hint
695841TRUNCATE TABLE can take a long time
695080Merge fix for Oracle 9.2.0.4
692646Performance Content Integrator
684545Statistics generation: DBMS_STATS runs longer than ANALYZE
632336Long runtimes when compiling statistics on Oracle 9.2.0.x
626615Oracle 9i: Problems because of _B_TREE_BITMAP_PLANS
618868FAQ: Oracle performance
610445Merge fix for Oracle 9.2.0.3
601668Merge fix for Oracle 8.1.7.4
567745Composite note BW 3.x performance: DB-specific setting
563359Performance optimization for tables with LOB columns
558746Better Oracle Data Dictionary BW Performance
558197upgrade hangs in PARCONV_UPG, XPRAS_UPG, SHADOW_IMPORT_UPG2,
556764Upgrade hangs in phase ACT_<REL>
521264Hang situations
520568CBO: Long runtimes for large IN lists
519407Performance problems accessing the datadictionary views
488583Database hangs: Waits for cache buffer chain latch
449136"cache buffers chains" latch contention on 8.1
359835Design of the temporary tablespace in the BW System
336402Massive performance problems with 8.1.6
198752TCP delay problem under Oracle 8.1.x
184905Collective note Performance BW 2.0
170989Poor performance under Oracle 8044, 805*, 8.0.6
164925Storage parameter of tablespace PSAPTEMP
128221Increased memory consumption with Oracle >8.0.X