SAP Note 124106 - SMON - Temp Segment Cleanup and Free Space Coalesce

Component : Oracle -

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 :

183791Locking on temporary tablespace of Oracle