I have set MEMORY_MAX_TARGET to something like 1G and SGA_MAX_SIZE to 500M. How would Oracle treat this? the 500M is treated as minimum SGA and SGA could grow till 1G-PGA??SGA_MAX_SIZE specifies the maximum size of the SGA for the lifetime of the instance.
What if i set MEMORY_MAX_TARGET= SGA_MAX_SIZE = 1G ??You do realize its default behaviour?
what if we set both? How Oracle behaves in that case?Oracle will not consider SGA_MAX_SIZE value, because MEMORY_MAX_TARGET is available from Oracle version 11.1.
Could you point me to any official documentation where it's mentioned?When either MEMORY_TARGET or MEMORY_MAX_TARGET is enabled, SGA_MAX_SIZE default value is set to the larger of the two specified parameters on non-Windows 32-bit operating system. On Windows 32-bit operating system, due to address space pressure, the default value of SGA_MAX_SIZE is calculated based on the total available virtual address space along with MEMORY_TARGET and MEMORY_MAX_TARGET.
CSM.DBA wrote:No problem; not an issue.
Sorry for the delayed response Girish.
Let me have a 'play session' on these and come back to you with my observations.That's pretty good and this is what known practicing and learning by our own. Please close this thread by marking it and if you wish to open new thread, you may mention this thread's link, if whenever you feel.