Solution : https://service.sap.com/sap/support/notes/883346 (SAP Service marketplace login required)
Key words :
long queue times occur, full table scan reason, full table scan, attached correction instructions, primary smohmsgq~0 index, smohmsgq~opt index, realignment framework considerably, smohmsgq table, table mentioned, large table
Related Notes :
| 875798 | Index rebuilds (Oracle) for R&R specific CRM tables |
| 869521 | Oracle <= 10g: TM locks with REBUILD ONLINE / CREATE ONLINE |
| 771929 | FAQ: Index fragmentation |