Hi Gurus,
Just need some clarifications here. One of our client doesnt use AMM or ASMM but manually manages the memory structures (buffer_cache, shared_pool and so on). Now based on addm_reports and awr analysis we wanted to increase the buffer_cache size but we couldnt because we reached the max sga size (not set by us but Oracle did by summing up all them memory structures).
My questions is will i face any problem if i increase the sga_max_size to a high value so that i can increase the sizes of any of the memory structures dynamically without restarting the database. Example below
sga_max_size 50GB
sum of all the memory structures 30GB
sga memory left for allocation 20GB
so we are left with another 20GB. With this setting i can increase buffer_cache or shared_pool size dynamically without even restarting the database. But is this a good practice? if it is will the Operating System allocate 50GB or 30GB for SGA?