SAP Note 558746 - Better Oracle Data Dictionary BW Performance

Composant : BW ORACLE - Oracle

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

Mots Clés :
createdremset timing onset echo onspool ana_dictexecute dbms_stats, createdremset timing onset echo onspool del_dictexecute dbms_stats, analyze cluster c_file#_block# compute statistics, analyze cluster c_file#_block# delete statistics, analyze cluster c_obj#_intcol# compute statistics, analyze cluster c_obj#_intcol# delete statistics, analyze cluster c_obj# compute statistics, analyze cluster c_obj# delete statistics, analyze cluster c_user# compute statistics, analyze cluster c_ts# compute statistics

Notes associées :

1319517Unicode Collection Note
936441Oracle settings for R3load based system copy
871455Poor performance when accessing DBA and V$ views
618868FAQ: Oracle performance
588668FAQ: Database statistics
567745Composite note BW 3.x performance: DB-specific setting
565075Recommendations for BW systems with Oracle 8.1.x
558197upgrade hangs in PARCONV_UPG, XPRAS_UPG, SHADOW_IMPORT_UPG2,
519448Performance problems when deactivating aggregates
519407Performance problems accessing the datadictionary views
387946USE OF LOCALLY MANAGED TABLESPACES FOR BW SYSTEMS
354080Note collection for Oracle performance problems
180605Oracle database parameter settings for BW
138639Poor DML performance with Oracle DDIC statistics