Solution : https://service.sap.com/sap/support/notes/124106 (SAP Service marketplace login required)
Key words :
symptom smon consuming high percentage, drop index create temporary segments, free space coalescing---------------------smon wakes, 8 temporary extentsper space transaction, alter tablespace xxxx coalesce, performing temporary segment cleanup, temporary segment cleanup-------------------------, free space coalescing, coalescing free space, create temporary segments
Related Notes :
| 183791 | Locking on temporary tablespace of Oracle |