Solution : https://service.sap.com/sap/support/notes/857998 (SAP Service marketplace login required)
Summary :
When configuring number range buffering for SAP BW environments, it’s advised to buffer the dimension table's (DIM IDs) number range object under specific conditions, such as a significant increase in data records per request, regular increase during initialization, frequent NRIV table access, or regular table deletions causing substantial growth. Similarly, SID number buffering is recommended for InfoObjects when there is anticipated large master data upload, frequent large SID table updates, or periodic deletions. To locate relevant number range objects, filter using transaction SE16 on NRIV, seeking 'BID*' or 'BIM*' where NRLEVEL is high and exported to Excel for further analysis. Adjust the buffer size between 100-500, and monitor load to scale as necessary. Avoid buffering for package dimension or request ID number range objects to prevent system resource issues.
Key words :
terms number range buffering, activate number range buffering, se16 'nriv'-> object = 'bid ', high number range level, number range object directly, sid table significantly increases, find number range objects, dim table increases significantly, number range buffering, number range object
Related Notes :
| 1013912 | FAQ: Oracle BW performance |
| 619188 | FAQ: Oracle wait events |