Solution : https://service.sap.com/sap/support/notes/546385 (SAP Service marketplace login required)
Key words :
analyze table <table_name> estimate statistics sample percent, st04 => detailed analysis => oracle sessions transaction, terms performance analyze indexed dbms_stats reason, sysdba set long 4000 spool view_def, analyze table <table_name> compute statistics, oracle cost based optimizer, symptom performance problems occur, sysdba select table_name, oracle sessions view, oracle session belonging
Related Notes :
| 567144 | Processing BW tables changed in BRCONNECT stats |
| 523249 | SAPBWNews BW 3.0B Support Package 12 |
| 523217 | SAPBWNews for BW 3.0A Support Package 12 |
| 493976 | SAPBWNews BW 3.0B Support Package 05 |