Different Values For SGA_MAX_SIZE Between Spfile/Pfile and V$PARAMETER/Show Parameter (Doc ID 2922003.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Different values are found for parameter SGA_MAX_SIZE between spfile or pfile and v$parameter/show parameter. The parameter is set explicitly to 0 in spfile or pfile, but after database startup, "show parameter" always shows a non-zero value
The behavior can be easily reproduced as below:

TEST CASE

1. Explicitly set following parameters

4. Repeat with step 1, but change the SGA_MAX_SIZE to a value which is smaller than the value from V$PARAMETER in the previous step (let's say, set SGA_MAX_SIZE to 100M). After restarting the instance, the parameter is also being overridden with the value which is the same as we get from the previous test.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.