Oracle MEMORY_TARGET minimum size

For my own reference, as I was asked what the minimum memory size for an Oracle database is. It turns out, that both in Oracle 11g R2 (11.2) as well as in Oracle 12c (12.1), the minimum value for MEMORY_TARGET (sum of SGA and PGA) is 152MB:

Range of values: 152 MB to MEMORY_MAX_TARGET

Source: Oracle Documentation (11.2, 12.1)

Just for completeness: In Oracle 10g R2, the minimum settings for SGA_TARGET was 64MB and the minimum setting for PGA_AGGREGATE_TARGET was 10MB, resulting in a 74MB minimum memory size for Oracle 10g R2.

Hello world

My name is Simon Krenger, I am a Technical Account Manager (TAM) at Red Hat. I advise our customers in using Kubernetes, Containers, Linux and Open Source.

Elsewhere

  1. GitHub
  2. LinkedIn
  3. GitLab