Solution : https://service.sap.com/sap/support/notes/1472386 (SAP Service marketplace login required)
Key words :
$sgastat displays increasing memory consumption, automatic work process restart, sufficiently large shared pool, bw cubes terminate, build termporary tables, star transformation query, related chunk exists, lower guide values, terms oracle ora-4031, database alert log
Related Notes :
869006 | Composite SAP note: ORA-04031 |
830576 | Parameter recommendations for Oracle 10g |
690241 | The Shared SQL Area in the Shared Pool and large SQL Stmnts |