Solution : https://service.sap.com/sap/support/notes/787533 (SAP Service marketplace login required)
Key words :
deletedmlspace managementcoalesce free spacealter tablespace coalescereorganizationnext extent size reason, st04 -> detailed analysis menu -> oracle sessions match, command sql> truncate table <tablename> reuse storage, st04 -> detail analysis menu -> oracle sessions, commandsql> alter table <tablename> deallocate unused, sql> alter table <tablename> deallocate unused, st04 --> detailed analysis session -> oracle sessions, sql> alter table <tablename> allocate extent, oracle sessions show enqueue waitsthere, sqlsql> select' alter index
Related Notes :
| 745639 | FAQ: Oracle enqueues |
| 618868 | FAQ: Oracle performance |
| 541538 | FAQ: Reorganization |
| 214995 | Oracle locally managed tablespaces in the SAP environment |