Hello, has anyone seen this behaviour before when trying to set SGA_MAX_SIZE to 0.
I have set memory_max_target and memory_target to positive values and set PGA_TARGET, SGA_TARGET and SGA_MAX_SIZE to 0 in the spfile.
When i restart the database and show parameter SGA_MAX_SIZE it always reverts back to 4300m that is displayed.
If i look at the spfile then i have the following at the top
ppros.__java_pool_size=4194304
ppros.__large_pool_size=4194304
ppros.__oracle_base='D:\app\oracle'#ORACLE_BASE set from environment
ppros.__pga_aggregate_target=6228541440
ppros.__sga_target=4508876800
ppros.__shared_io_pool_size=536870912
ppros.__shared_pool_size=545259520
ppros.__streams_pool_size=8388608
followed by
*.pga_aggregate_target=0
*.sga_max_size=0
*.sga_target=0
I am using 11.2.0.3 Standard Edition on Windows 2008
What are the sid.__<sizes> at the top if i have set targets to be 0 (which are shown later in the spfile).
Do you know why my SGA_MAX_SIZE keeps reporting a value of 4300M?
Thanks,
Phil