Solution : https://service.sap.com/sap/support/notes/840553 (SAP Service marketplace login required)
Summary :
For SAP BW systems, performing TRUNCATE on large memory Oracle instances may result in prolonged execution times compared to DELETE operations for emptying temporary tables. SAP Note introduces an alternative where DELETE can be used instead of TRUNCATE for tables managed by functions RSDU_TABLE_TRUNCATE(_ORA) if they contain fewer than 1,000 records. The determination of the operation type (DELETE or TRUNCATE) is automated based on record counts, leveraging the ORA_TABTRUNCATE_MINIMUM parameter written to RSADMIN. Essential updates and improvements are made available through Support Packages specified for different SAP BW releases.
Key words :
sapbwnews bw support package 13 nw'04 stack 13, delete complete table contents, 10 content import support package 21, 0b import support package 27, unpartitioned table called abc, 50 import support package 13, 1 content support package 21, temporary bw tables, sql statement delete, temporary table reason
Related Notes :
| 1013912 | FAQ: Oracle BW performance |
| 783254 | SAPBWNews BW Support Package 13 NW'04 Stack 13 RIN |
| 745639 | FAQ: Oracle enqueues |
| 723263 | SAPBWNews BW 3.1 Content Support Package 21 |
| 723258 | SAPBWNews BW 3.0B Support Package 27 |
| 619188 | FAQ: Oracle wait events |