Solution : https://service.sap.com/sap/support/notes/557447 (SAP Service marketplace login required)
Key words :
prerequisites insufficient process memory, statements raising theora-4031 error, sap note 507524for systems, additional memory usage, sap objects included, sap parameterrsdb/max_in_blocking_factor, rule based optimizer, cost based optimizer, symptom ora-4031 occuring, ora-4031 error whilerunning
Related Notes :
| 863248 | Note 797972 - Removing 'rule' hints - Oracle |
| 744315 | LDB PSJ: Elimination of 'rule' hints Oracle |
| 521264 | Hang situations |
| 507254 | ORA-4031 and ORA-3113 when processing large IN lists |
| 505246 | Several ora-600 [12333] and ora-4031 errors |
| 403704 | BRCONNECT - Enhanced function for Oracle DBA |