1. Administrator's Guide
  2. Optimizing Performance
  3. Tuning Oracle 11g Databases for Financial Management
  4. Tuning Guidelines for Oracle 11g Databases
  5. SGA_MAX_SIZE

SGA_MAX_SIZE

SGA_MAX_SIZE specifies the maximum size of the SGA for the lifetime of the instance. This parameter sets the upper limit for SGA_TARGET. If Automatic Memory Management is enabled, the Oracle database cannot increase the total size of SGA components beyond SGA_MAX_SIZE.

Suggested setting: Use the default setting if Automatic Memory Management is enabled; otherwise refer to How to Determine Memory Settings for Oracle Database Release 11g.