Solution : https://service.sap.com/sap/support/notes/558746 (SAP Service marketplace login required)
Key words :
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
Related Notes :
| 1319517 | Unicode Collection Note |
| 936441 | Oracle settings for R3load based system copy |
| 871455 | Poor performance when accessing DBA and V$ views |
| 618868 | FAQ: Oracle performance |
| 588668 | FAQ: Database statistics |
| 567745 | Composite note BW 3.x performance: DB-specific setting |
| 565075 | Recommendations for BW systems with Oracle 8.1.x |
| 558197 | upgrade hangs in PARCONV_UPG, XPRAS_UPG, SHADOW_IMPORT_UPG2, |
| 519448 | Performance problems when deactivating aggregates |
| 519407 | Performance problems accessing the datadictionary views |
| 387946 | USE OF LOCALLY MANAGED TABLESPACES FOR BW SYSTEMS |
| 354080 | Note collection for Oracle performance problems |
| 180605 | Oracle database parameter settings for BW |
| 138639 | Poor DML performance with Oracle DDIC statistics |