Solution : https://service.sap.com/sap/support/notes/7462 (SAP Service marketplace login required)
Summary :
When deleting an old client in SAP and creating a new one, the released space does not seem to be reused, as the database requests new extents. This issue occurs because ORACLE reuses released space based on the block's occupancy level defined by the PCTUSED parameter, which defaults to 40%. Space won't be reused for new inserts until occupancy drops below this threshold. The solution involves increasing the PCTUSED parameter, such as setting it to 80%, using the ALTER TABLE statement, e.g., ALTER TABLE SAPR3.ATAB PCTUSED 80;, executed via sqlplus to apply this change to any table.
Key words :
symptom key word, data base requests, additional key words, alter table sapr3, occupancy level sinks, occupancy level, atab table, prerequisites oracle, released space, called pctused
Related Notes :
| 35952 | Client deleted, space still filled in database |