Solution : https://service.sap.com/sap/support/notes/936441 (Connexion à SAP Service Marketplace requise)
Résumé :
This SAP Note discusses how to optimize the Oracle database configuration for R3Load migrations such as Unicode migrations, heterogeneous system copies, and platform migrations. The main challenge addressed is the excessive time these operations take due to certain inefficiencies in Oracle settings under migration conditions. Recommendations include altering Oracle configuration and parametrization, specifically targeting parameters like pga_aggregate_target and db_cache_size. Key steps like using 'loadprocedure fast option', creating Oracle Data Dictionary statistics for older Oracle versions, and optimizing database and network configuration are advised to boost throughput during R3Load migrations. Implementation of these changes should result in markedly reduced migration times.
Mots Clés :
dedicated private network segments sql net configuration, 64bit operating systems solution migrations based, concurrent r3load processes 2 processes = processes + parallel_max_servers 4, filesystemio_options = setall disk_asynch_io = true db_writer_processes = 20, network connection configure jumbo frames, create oracle data dictionary statistics, parallel_execution_message_size = 16384 parallel_threads_per_cpu = 1 parallel_max_servers = number, process address space limitations, hardware vendor specific techniques, put redo log files
Notes associées :
| 1319517 | Unicode Collection Note |
| 1045847 | ORACLE DIRECT PATH LOAD SUPPORT IN R3LOAD |
| 1043380 | Efficient Table Splitting for Oracle Databases |
| 999524 | Oracle 10.2 platform support for Async IO |
| 971646 | 6.40 Patch Collection Hom./Het.System Copy ABAP |
| 970518 | Hom./Het.System Copy SAP NetWeaver 7.0 (2004s) SR2 |
| 940561 | ORACLE DIRECT PATH LOAD DOES NOT LOAD PARALLEL SINGLE TABLE |
| 926085 | (OUTDATED) Hom./Het.System Copy SAP NetWeaver 7.0 SR1 |
| 870863 | (OUTDATED) Hom./Het.System Copy SAP NetWeaver 2004s |
| 857081 | Unicode conversion: downtime estimate |
| 834343 | Oracle 9.2 Platform Support for Async IO |
| 806554 | FAQ: I/O-intensive database operations |
| 784931 | Hom./Het.System Copy SAP Web AS 6.40 SR1 ABAP |
| 765475 | Unicode Conversion: Troubleshooting |
| 632556 | Oracle 9.2.0.* database parameterization for BW |
| 575280 | Add info about upgrade to SAP Web AS 6.20 ORACLE 9.2.0 |
| 558746 | Better Oracle Data Dictionary BW Performance |
| 554031 | Creating space statistics with BRCONNECT |
| 548016 | Conversion to Unicode |
| 124361 | Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x) |