SGA_target and SGA_maxsize

What is the difference between SGA_target and SGA_maxsize?

Questions by Pragati.rch

Showing Answers 1 - 3 of 3 Answers

shreya_phadnis

  • Oct 1st, 2008
 

SGA_target if set to positive value enables automatic shared memory mgmt. with this you do not have to set memory for the 5 auto tuned memory parameters like - shread pool, large pool, Java pool, streams pool and buffer cache. setting sga_tgt = 0 disables auto shared memory mgmt.

SGA_maxsize is the max amt of memory that can be allocated to all the components of SGA.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions