Oracle 126.96.36.199.0 OS : WinNT4.0
Can anybody explain me SGA_MAX_SIZE in Oracle9i. According to my understanding, this parameter defines the Maximum size for SGA that you could ever allocate.
I have seen very strange behaviour by setting this parameter.
First of all, I took out SGA_MAX_SIZE parameter from my init.ora and here is the result of show sga command
Thanks for your response but I don't agree with this. I know about granularity. I have read in Metalink about this and it does not works as expected. e.g. if you define SGA_MAX_SIZE=500M and suppose, the actual size of SGA is 128MB , but still Oracle will reserve 500M and when you say show sga, it is going to show you 500M.
I have read in Metalink, that in Solaris 8 when you enable DISM (some os feature), then SGA_MAX_SIZE works as expected.