I am having these settings in my Windows Server : a) Physical Memory of 32GBs and b) One database with sga_target=2Gb and SGA_Max_size= 8Gb.
I am confuse with a few things.
a) If the server have 32gb, those the Oracle database reserves 2GB for it uses, if it needs more goes no more than 8Gb ?
b) The server have 30Gb for others process because there are 2GB reserves for Oracle ? ---
c) If database requires more memory , let say a batch process requires 12Gb , the database will only goes no more than 8Gb ?
d) If there some others process using RAM, and the database need it, it will take out those process to use virtual memory and the OS will prioritize the database and let it use RAM until 8Gb ( sga_max_taget). ?
I am confuse on how the memory managament works.