SAP Note 1472386 - ORA-04031 out of memory error in BW systems

Component : Oracle - BW ORACLE

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 :

869006Composite SAP note: ORA-04031
830576Parameter recommendations for Oracle 10g
690241The Shared SQL Area in the Shared Pool and large SQL Stmnts