Solution : https://service.sap.com/sap/support/notes/869521 (SAP Service marketplace login required)
Key words :
worst-case scenario terminations, long-term tm locks, rebuild / create attempts <level> times, alter index rebuild online, rebuild online / create online, create index online starts, table-wide tm enqueue, scheduling rebuild online, index remains fragmented, tm enqueue permanently
Related Notes :
| 883346 | Performance problems in realignment framework |
| 712098 | RSORAISQ: Index Storage Quality Management |
| 682926 | Composite SAP note: Problems with "create/rebuild index" |
| 618868 | FAQ: Oracle performance |
| 521264 | Hang situations |
| 334224 | Important notes for creating indexes |