1873631 - Best practices to set SGA and PGA

This document was designed to server as a basic Oracle memory configuration guide.

You may have reached it either by facing one of the errors below, or due performance issues.

After the system is running for a while, you starting receiving ORA-04031 errors.

ORA-04031: unable to allocate <bytes> bytes of shared memory

You have already checked the following SAP Notes but they didn't help:

• 1472386 - ORA-04031 out of memory error in BW systems
• 1478228 - Oracle ORA-4031 WHEN GATHER STATS IN PARALLEL
• 869006 - Composite SAP note: ORA-04031
• 690241 - The Shared SQL Area in the Shared Pool and large SQL Stmnts

If you did not check this notes yet, please make sure you go through them before applying the solution proposed here.

• SAP systems based on NetWeaver;
• Oracle database
• Automatic Shared Memory Management (ASMM) or Automatic Memory Management (AMM) enabled.

overflow buffer user session fails crash ORA-04030 shared pool buffer cache stop abort hang sga system global area memory pga program work process fail sga_max_size ORA-04031 tuning performance recommendation , KBA , BC-DB-ORA , Oracle , Problem