Oracle 188.8.131.52.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