Solution : https://service.sap.com/sap/support/notes/1043380 (SAP Service marketplace login required)
Summary :
This SAP Note addresses performance issues encountered when using R3ta for calculating range splits in large Oracle database tables during UNICODE migrations. It points out that R3ta lacks Oracle-specific optimizations for efficient splitting operations. The introduction of a new PL/SQL splitter package offers a solution by enhancing the calculation efficiency for various table types, leveraging Oracle-specific features. The note details installation and utilization steps for the SPLITTER package and lists versions of R3load compatible with this optimization. Operational guidelines and prerequisites such as database versions and permission settings are clearly outlined to ensure proper implementation.
Key words :
choosing 'oracle specific pl/sql splitter', certified db/os migration specialists, folder <sapinst installation directory>/split/, sqlplus connect <sapr3> start splitter2, early customer experiences show, r3load rowid table splitting works, specific rowid table splitting limitations, install pl/sql package, sysdba start presplitter <sapr3>, large oracle database tables
Related Notes :
| 1319517 | Unicode Collection Note |
| 954268 | Optimization of export: Unsorted unloading |
| 952514 | Using the table splitting feature |
| 936441 | Oracle settings for R3load based system copy |
| 855772 | Distribution Monitor |
| 806554 | FAQ: I/O-intensive database operations |