Solution : https://service.sap.com/sap/support/notes/514758 (SAP Service marketplace login required)
Key words :
ORA-4031 database hang 8.1.7.3
Related Notes :
869006 | Composite SAP note: ORA-04031 |
521264 | Hang situations |
520568 | CBO: Long runtimes for large IN lists |
505246 | Several ora-600 [12333] and ora-4031 errors |