Solution : https://service.sap.com/sap/support/notes/502782 (SAP Service marketplace login required)
Key words :
hash-join subhcallheapkoh dur heapkxfrheapsort subheappga heap solution, prevents increased pga allocations due, regularly restarting sap work processes, sufficiently large swap area ensure, operating system users <sid>adm, automatic pga administration releases memory, correct users <sid>adm, oracle process requests pga memory, restart work processes regularly, sufficiently large swap area
Related Notes :
| 1535843 | Delete connector background job failed with error ORA-04030 |
| 1013912 | FAQ: Oracle BW performance |
| 804186 | sga size > 2GB on Linux |
| 789011 | FAQ: Oracle memory areas |
| 766349 | FAQ: Oracle SQL optimization |
| 712624 | High CPU consumption by Oracle |
| 619876 | Oracle9i: Automatic PGA Memory Management |
| 613872 | Oracle traces with ORADEBUG |
| 515080 | Importing Support Packages hangs. Work process with SEM -17 |
| 513524 | Composite ORA-12540 SAP note |
| 441663 | USING > 3 GB of memory for Oracle on WINDOWS platforms |
| 437362 | Composite note ORA-12500 |
| 142019 | 3GB Memory and Oracle 8 on Windows (NT or 2000) |
| 130140 | ORA-4030 on NT, out of process memory |
| 128221 | Increased memory consumption with Oracle >8.0.X |
| 101717 | Automatic restart of SAP R/3 work processes |
| 70197 | Is Multi-Threaded Server supported with SAP |