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

Composant : Oracle - BW ORACLE

Solution : https://service.sap.com/sap/support/notes/1472386 (Connexion à SAP Service Marketplace requise)

Mots Clés :
$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

Notes associées :

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