Solution : https://service.sap.com/sap/support/notes/548221 (SAP Service marketplace login required)
Summary :
When creating or modifying temporary tablespaces in Oracle, the system may utilize sparse files, which do not initially allocate the full declared space on the disk. This discrepancy can be observed when comparing the file size as per 'ls -l' command against available disk space as shown by 'du' or 'df'. Sparse files dynamically adjust their disk space usage, which can lead to potential issues if multiple sparse files compete for insufficient disk space. To prevent sparse file utilization, administrators can copy the file using specific OS commands, ensuring the copied file does not maintain the sparse property, thereby reflecting true size allocation.
Key words :
terms sparse ls du df temporary tablespace filesize add datafile psaptemp psaptemp2 reason, alter tablespace add tempfile '<path, operating system offers sparse file functionality, create temporary tablespace tempfile '<path, prerequisites oracle creates files, operating system level, temporary tablespace, unix operating systems, 'sparse' property anymore, 2000m initially allocates
Related Notes :
| 659946 | FAQ: Temporary tablespaces |
| 633914 | Error when executing DBMS_STATS |
| 546006 | Problems with Oracle due to operating system errors |