Solution : https://service.sap.com/sap/support/notes/620803 (SAP Service marketplace login required)
Key words :
data1' size 100m extent management local segment space management auto, create tablespace tsp_assmdatafile '/oracle/sid/sapdata1/test/test, extent management local segment space management auto, pctused/freelists/freelistgroups storage parameters manually, instances simultaneously execute parallel dml operations, oracle function 'automatic segment space management, symptom automatic segment space management, - drop empty tablespaces - update statistics, configured manual segment space management, assm automatic segment space management
Related Notes :
| 1037755 | Performance problems with ASSM tablespaces |
| 912918 | Massive UNDO/REDO generation when you use ASSM |
| 830965 | VBDATA, DDLOG: size and increase in size |
| 821687 | FAQ: Space utilization and fragmentation in Oracle |
| 775810 | Use of ASSM in R3 Releases 31I to 610 |
| 764015 | Segment corruption in ASSM tablespace |
| 708721 | Table enlargement possible with ASSM |
| 647697 | BRSPACE - New tool for Oracle database administration |
| 646681 | Reorganization of tables with BRSPACE |
| 619188 | FAQ: Oracle wait events |
| 598678 | Oracle 9i: New functions |
| 572060 | Options in the Oracle database during archiving |
| 541538 | FAQ: Reorganization |
| 214995 | Oracle locally managed tablespaces in the SAP environment |