asked on oracle SGA_target, SGA_max_Size and server physical/virtual memory
Hi,
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.
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.
Oracle Database
Last Comment
joe_echavarria
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I am having some performance problems and wanted to have those things clear in mind.
Now i have a clear picture of all of this.
Thanks.
Now i have a clear picture of all of this.
Thanks.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
You may be able to get better Oracle performance by setting SGA_MAX_SIZE to 16Gb (if you have no non-Oracle programs on this server) and setting the SGA_TARGET close to 16Gb. That would allow Oracle to cache a bigger portion of the database in memory (assuming that your database size is larger than 2Gb) so tghat may give you better Oracle performance.
But, I agree with Geert, that usually slow Oracle performance is caused by poor SQL queries or statements that do not use the existing indexes to allow Oracle to give you good performance.
But, I agree with Geert, that usually slow Oracle performance is caused by poor SQL queries or statements that do not use the existing indexes to allow Oracle to give you good performance.
ASKER
Thanks a lot for you help.
http://docs.oracle.com/cd/E11882_01/server.112/e40540/memory.htm#CNCPT007
The database uses other memory besides the SGA. the PGA for example.
There are also database connections and programs that use memory outside of the database and in the OS itself.