Solution : https://service.sap.com/sap/support/notes/359835 (SAP Service marketplace login required)
Key words :
svrmgrl> connect internal svrmgrl> set timing, svrmgrl> drop tablespace psaptest including contents, raw-device>' size 500m reuse, svrmgrl> create tablespace psaptest '<, underlying data files correctly, initial hash_area_sizenext hash_area_sizenext hash_area_sizeinitial, schedule job sap_drop_tmptable periodically, required temporary tablespace increases, require massively temporary tablespace, dictionary-managed oracle tablespace
Related Notes :
| 761171 | CPCC Service Package 2.2.300 |
| 745639 | FAQ: Oracle enqueues |
| 659946 | FAQ: Temporary tablespaces |
| 619188 | FAQ: Oracle wait events |
| 567745 | Composite note BW 3.x performance: DB-specific setting |
| 485755 | ORA-03232: unable to allocate an extent of blocks |
| 443544 | IO Problems on AIX Filesystems |
| 432377 | ODMA modifies Storage settings for Temporary TS |
| 416772 | General tablespace types, temporary tablespace parameters |
| 387946 | USE OF LOCALLY MANAGED TABLESPACES FOR BW SYSTEMS |
| 354080 | Note collection for Oracle performance problems |
| 334713 | SAP BW 2.1C Installation on UNIX |
| 308533 | Temporary Database Objects in BW 2.0 |
| 180605 | Oracle database parameter settings for BW |
| 164925 | Storage parameter of tablespace PSAPTEMP |